Senior ETL QA Resume

SUMMARY:

6+ years total experience in IT industries. Currently associated with BNP Paribas in Business Analytics & Optimization service line as Senior ETL QA.
Experience area in Data Warehousing, Data Migration, Data Requirement Analysis, Informatica, UNIX and SQL.
Having 6+ years of experience in the Information Technology Industry as a QA in ETL testing and functional testing by following manual & automated approach.
Having sound knowledge of banking domain and life science.
Firm knowledge of different phases of Software Development Life Cycle (SDLC) and Software Testing (STLC)
Strong knowledge in data warehouse concepts like Type of Fact, Type of dimension, Type of SDC’s, snowflake, star schema etc.
Performed manual and automated testing using tools like ALM
Diverse experience with various testing methods such as Data warehouse Testing/ETL Testing, Functional testing, Regression Testing, System Testing, Integration Testing, User Acceptance Testing (UAT), Database Testing, End to End Testing
Experience in writing Test Plans, defining Test Cases, developing and maintaining Test scripts, analyzing the results of scripts, interaction with developers in fixing the errors.
Experience in Bug Tracking and Reporting using HP Quality Centre.
Strong skill in Backend Testing using SQL queries on SQL Server, Oracle.
Having knowledge of running jobs in UNIX and Informatica power centre
Proficient in all phases of Test Life Cycle from test planning to defect tracking and managing defect lifecycle.
Ability to work in a team environment or independently.
Expertise in analyzing User Requirements, Functional and Technical Specifications.
Excellent troubleshooting, project management and problem solving skills.

TECHNICAL SKILL:

ETL Tools: Informatica 9.6 PowerCenter

RDBMS: Oracle 10g/11g, Microsoft SQL Server 2012

Tools: SQL Developer, Putty, WinSCP

Bug Tracking system: HP Quality Centre 11.0

PROFESSIONAL EXPERIENCE:

Confidential

Technology: Informatica Power Center (9.1), Oracle, SQL, UNIX

Senior ETL QA

Responsibilities:

Designed and developed test script to validate transformation logic and data quality.
Experience with high volume dataset with various sources like - Oracle, Text files, CSV files
Involved in fully Data warehousing project, testing of Fact, Dim, Relational, work Tables.
Run time support on SIT, UAT and higher environment.
Analyzed the client’s requirements and functional specifications.

Confidential

ETL Tester

Technology: Informatica Power Center (9.1), Oracle, SQL, And UNIX HP Quality Center 11, SQL Loader

Responsibilities:

Designed and developed test script to validate transformation logic and data quality.
Experience with high volume dataset with various sources like- Oracle, Text files, CSV files
Provided support and quality validation through test cases for Unit Testing.
Run time support on SIT, OAT and higher environment.
Analyzed the client’s requirements and functional specifications.

Confidential

ETL Tester

Technology : SQL Scripts, PL/SQL, SSIS

Environment: SQL Server2012, SAP BO, HPALM, WinSCP.

Responsibilities:

Understanding Business requirements for change.
Involved in developing detailed test plan, test cases and test script for Functional and Regression Testing, Unit testing.
Release coordination & Implementation activities
Involved in System Testing, Positive Testing, Negative Testing, and Regression Testing and Verified data integration using SQL.
Completed Data Migration test cases as well as web based test scripts.

Confidential

ETL Tester

Technology : Informatica PowerCenter, Oracle SQL Scripts.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Toad for OracleHPALM.

Responsibilities:

Worked on Agile SDLC approach implementation for the whole testing life cycle.
Worked on Informatica Power Centre tool - Source Analyser, Warehouse Designer, Mapping and Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow Manager.
Gathered requirements and created, executed and documented Test Cases as per requirements in Quality Centre.

Confidential

ETL Tester

Technology : Informatica power centre, SQL

Environment: PowerCenter 8.6, SQL Developer, WinSCP, HP Quality Center 10.0

Responsibilities:

Analysed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Centre 10.0
Investigate defects and discuss them with developers
Involved in developing detailed test plan, test cases and test scripts using Quality Centre for Functional and Regression Testing
Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship