SUMMARY

• Totally 7 years of professional experience as an Informatica Developer and QA Tester / ETL Tester in analysis, development, testing, maintenance, and implementation of Data Warehousing applications using ETL tool Informatica Power Center.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source files / RDBMS tables to target tables.
• Proficient in Data Warehouse designing techniques and is experienced in design and development of ETL processes required to extract, transform, cleanse, and load the data from source system to target system (data mapping).
• Experience in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and other relational databases.
• Used Informatica to validate the data flow from Source to Target tables by verifying the mappings and transformations.
• Good understanding in Data Warehousing and ETL testing concepts.
• Extensive work experience in different types of testing like data integration, data transformation, incremental, navigation, Smoke, Functional, Regression, Integration, System, Database and User Acceptance Testing (UAT).
• Reported bugs and track defects by using bug - tracking system JIRA.

PROFESSIONAL EXPERIENCE

Confidential

Informatica Developer

Responsibilities:

• Use Informatica PowerCenter for extraction, loading, and transformation (ETL) of data from various sources into the target.
• Designed, developed, and tested ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter.
• Use ETL methodology for supporting data extraction, transformations and loading processing.
• Extensively work on Informatica PowerCenter Components PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Develop and maintain ETL (Data Extract, Transformation and Loading) mappings to extract the Data from multiple source systems like MS SQL and Flat Files.
• Use Informatica PowerCenter to extract, transform and load data into target files from various sources like MS SQL and flat files.
• Responsible for creating and configuring different sessions and workflows to load the data to target/s using Informatica Workflow Manager.
• Design and develop advanced mappings using various transformations in Informatica Designer to extract the data from sources to perform mappings based on the requirements and load into targets.
• Execute and monitor Informatica workflow to load data from various sources and perform data validations.

Environment: Informatica PowerCenter, MS SQL Server, Flat Files.

Confidential

Informatica Developer / ETL Tester

Responsibilities:

• Used Informatica PowerCenter for extraction, transformation, and load (ETL) of data in the data warehouse.
• Performed extensive data integration testing, data transformation testing, incremental testing, navigation testing, smoke testing, unit testing, integration testing, system testing and Regression testing.
• Responsible for ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Tested the ETL process that loaded the data into the target database after performing all the transformations according to the business requirements in Informatica.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Tested the ETL Informatica mappings and other ETL Processes (DW testing)
• Monitored defects status and tracked them to closure using JIRA.

Environment: Agile/ Scrum Methodology, Functional Testing, Regression Testing, Integration Testing, End to End Testing, Smoke Testing, data integration testing, data transformation testing, incremental testing, navigation testing, MS Excel, MS PowerPoint, Informatica Power Center.

Confidential

QA Analyst

Responsibilities:

• Analyzed business requirements and technical specifications of application in development and produced test cases for functional testing, integration testing and regression testing.
• Performed manual testing, which may include system, regression, functional and front-end testing.
• Attended Sprint Planning, backlog grooming, defect tracking, daily scrum, Retrospective and Demos with agile/scrum team.
• Performed integration testing, Functionality testing, Regression testing and end-to-end testing of overall application to ensure end-to-end usability.
• Performed Positive, Negative and Boundary value analysis, Equivalence Partitioning, Error guessing testing around the application.
• Evaluated, troubleshooted and tested the software repeatedly to detect all errors and bugs and recommend bug fixes in JIRA.

Environment: Agile/ Scrum Methodology, SAP, Boundary Value Analysis, Equivalence Partitioning, UI Testing, Functional Testing, Regression Testing, Integration Testing, End to End Testing, Smoke Testing.

Confidential

QA Tester

Responsibilities:

• Analyzed and reviewed business requirements, Functional and Design specification documents.
• Involved in creating traceability matrix to keep track of changes in requirement and their impact on testing efforts
• Performed different kinds of testing like Black Box, GUI, Functionality, Integration, Regression, System, and User Acceptance.
• Collected positive and negative test data by executing SQL queries against the database.
• Generated test data using a spreadsheet MS Excel to verify the response.
• Performed Black-box testing, functional testing, UI testing, integration, end-to-end testing, Regression Testing, performance testing, UAT and build acceptance (smoke) testing after each build.
• Used MS Excel and JIRA to track, report, and manage defects throughout the test cycle.

Environment: Waterfall methodology, Boundary Value Analysis, Equivalence Partitioning, Functional Testing, Regression Testing, Integration Testing, End to End Testing, Smoke Testing, UAT, MS Excel.