Post Job Free

Resume

Sign in

Informatica Developer, ETL Tester, JIRA, ALM, Oracle SQL Developer

Location:
Pune, Maharashtra, India
Posted:
October 21, 2020

Contact this candidate

Resume:

Kushagra Kumar Email:adg6o3@r.postjobfree.com

Ph: +91-971*******

Objective: Looking for a long-term association with an organization having dynamic work environment where my skills could be enhanced and grow in the hierarchy of the company.

Professional Synopsis

Total 4 years of experience in Software Testing, especially in ETL and SQL development.

Experience in team handling from 2 to 11 resources at various point of times.

Trained and hands on various ETL tools like Informatica PowerCenter and Query Surge.

Hands on experience on TOAD, PLSQL, Informatica, BO Reporting, Intellimatch.

Trained in Automation tool like UFT (QTP).

Good experience in SQL Query preparation in Oracle.

Worked with HP Quality Center and JIRA for Defect management and Bug Reporting.

Experience in all types of Test Documentation: Test Plan, Test Scenarios, Test Cases and Understanding documents etc.

Good knowledge of SQL queries, ETL concepts and process and UNIX commands.

Good exposure to Software Development Life Cycle and Testing Life Cycle.

Excellent Team Player possessing Good Communication and Interpersonal Skills.

Joined as a fresher in Wipro Ltd and was trained for six months in

Core Java and ETL with QTP.

Career Profile

Dates

Organization

Designation

June 2016 – Till Date

Wipro Limited

Senior Project Engineer

Educational Qualifications

Batch (IT) from Galgotia’s College of Engineering & Technology (Greater Noida) in 2016.

Technical Skills

Database

Oracle, Toad Data Point, Teradata, PLSQL

ETL Tools

Informatica, Unix

Test Management Tool

HP Quality Center, JIRA

Automation Tool

Query Surge, Trained on UFT

Programming Languages

Core Java,J2EE, HTML,VBA for excel Macros, SQL, CSS, PL/SQL

Operating Systems

Windows XP/Vista/7

Project Experience

Project # 1

Project Title : KYC

Client : US Bank

Domain : Banking

Testing Type : Data Warehouse Testing

Testing Tools : Query Surge, Toad Data Point

Test Management Tool : HP Quality Center 11.0(ALM)

Team Size : 11

Dated : Jan, 2017 – Dec, 2017

Description: Know Your Customer (KYC LRD) is a regulatory project. Data is moved from multiple source system to RAW layer and from RAW layer to HM Layer and from HM to LR Layer. All these layers are on HADOOP file system. We do ETL Validation and Business Transformation check between HM to LR layer.

Responsibilities:

Preparation of Test Cases from Mapping Document.

Execute Test cases and report defects using defect management tool, HP Quality Center.

Coordinating with Development Team to discuss about Defects.

Coordinating with the client on some issues.

Track the raised defects till their closure.

Validate schema of the tables like column names, data type length, nullability etc.

Validate the data from the source system to final staging area.

Build SQL queries to validate the business transformation logics.

Project # 2

Project Title : RFDAR(RISK FINANCE DATA and RECONCILATION)

Client : Credit Suisse

Domain : Banking

Development Tool : Informatica Power Center

Testing Tools : Oracle SQL Developer, PLSQL Developer, Intellimatch, BO Reporting

Test Management Tool : HP Quality Center 11.0(ALM) and JIRA

Team Size : 08

Dated : Jan, 2018 – May, 2019

Description: FARR is a reconciliation project which deals with Risk and Finance Data. We receive data in the form of flat files from the normalization layer after which it is loaded into Intellimatch and further processed. After which data flows to Business Objects which is the business intelligence layer. Project is made to understand the consistency between Risk and Finance side data. Daily a report will be generated which will show how many records matched between the two sides upon which analysis can be performed.

Responsibilities:

Develop and review Test Scenarios, Test Conditions and Test cases based on Business and Technical requirements.

Develop informatica flows to validate the business requirements.

Develop Test Scenarios to test different matching rules as per the requirement.

Create Test data to test difficult scenarios.

Coordinate with developer and BA for all clarifications.

Involved in SQL queries used for test execution.

Defect Monitoring and Bug tracking.

Documentation and presentation of test results at various phases of testing life cycle.

Ensures quality product delivery and client satisfaction.

Project # 3

Project Title : ACVA(Advanced Credit Valuation Adjustment)

Client : Credit Suisse

Domain : Banking

Testing Type : Data Warehouse Testing

Testing Tools : Oracle SQL Developer, UNIX

Test Management Tool : HP Quality Center 11.0(ALM)

Team Size : 03

Dated : June, 2019 – Dec, 2019

Description: ACVA takes into account any change in credit risk when reporting the fair value of any derivative position and is by definition the difference between the risk-free portfolio and the true portfolio value that takes into account the possibility of counterparty default.

Currently, the PB Uncollateralized Derivatives Portfolio utilizes standard exposure method in order to calculate CVA. The change which the project is bringing here is the calculation of PB Uncollateralized Derivatives Portfolio exposure using the more advanced Internal Model Method (IMM).

Responsibilities:

Develop and review Test Scenarios, Test Conditions and Test cases based on FSD provided by the BAs.

Upload the feeds from different source systems using TECTIA.

Create Test data to cover all the scenarios.

Coordinate with developer and BA for all clarifications.

Involved in SQL queries used for test execution.

Defect Monitoring and Bug tracking.

Documentation and presentation of test results at various phases of testing life cycle.

Managed two other people of the team with task allocation and queries.

Project # 4

Project Title : EUC(End User Computing)

Client : CITI Bank

Domain : Banking

Development Tools : Oracle SQL

Test Management Tool : JIRA

Team Size : 11

Dated : Jan, 2020 – Till Now

Description: EUC remediation project is all about automating the manual process done by the CITI customers using Appian as UI and Oracle SQL as the backend.

FRSS Citi team have different input systems from which they have the inputs to download and then we have to perform all the calculations on those input files and create the output to post on their different portals.

Responsibilities:

Develop the data model as per the information given by the CITI SMEs.

Prepare the FRD for all the EUCs so that anyone in future can understand the flow easily.

Assign work to the resources according to their experience and expertise.

Prepare queries to manipulate the input data and generate output as per the requirement set by SMEs.

Track the whole EUC from Dev till UAT sign off.

Attend the meeting with the stakeholders and management to provide the team progress.



Contact this candidate