ETL QA Resume Chantilly, VA - Hire IT People

SUMMARY:

1.5+ year of experience in Database, Data Warehouse and ETL Testing.
Worked extensively in Data Warehousing and Business Intelligence Environments.
Extensive experience in Manual Testing of ETL and BI applications in Integration Testing, System Testing, Performance Testing, Functionality Testing, Regression Testing and Report Testing.
Proficient in Data Warehouse testing like testing batch loads, testing of SCD implementations and process dependencies.
Good understanding in Data Warehousing and ETL concepts Dimension Data Modeling, Star Schema and Snowflake Schema, Surrogate Keys, SCD Types .
Experience with different databases like Oracle and MS SQL Server to extract and load data.
Experience with different software methodologies like Water Fall and Agile.
Experience with Informatica ETL Development GUI tool.

SKILL SET:+

ETL Tools: Informatica PC 8.6.1/9.0.1

Quality Management Tool: HP ALM - Quality Center 11.0

Databases: Oracle 11g, SQL Server 2005/2008

Languages: C, C++, Java, SQL, PL/SQL

Script Languages: Shell scripting, Java Script

Operating System: Windows 2000/XP/win7/2008, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Chantilly, VA

ETL QA

Responsibilities:

Direct interaction with Business Analysts to understand technical requirements and business requirements.
Various reports are generated to actively contribute in planning the project delivery lines and played key role in shaping new Change Requests (CR).
Communicated with different production teams to develop test data for different applications and documented all the flow.
Prepared High-Level and Low-Level test cases based on Design documents, Requirement documents and developed Test plans.
Interacted with Development, Business and Reporting teams to make sure different applications on each mart are error free.
SQL, PL/SQL is used to reflect the business logics on the source data bases and compared the same logics on Target data bases.
Informatica code is debugged and parameter files are created to run different test data sets.
UNIX scripts are used to automate the testing procedures for file loads.
Performance testing, Load testing are done by collecting the production data statistics.
Involved in Test Plan, Test result and Test Matrix Documents preparation.
Involved in Regression testing, Functional testing and Integration testing.

Environment: Informatica Power center 9.0.1, Power Connect, Oracle 11g, HP ALM - QC 11.0, PL/SQL, UNIX Shell Script, Excel.

Confidential, Palo Alto, CA

Jr. ETL QA

Responsibilities:

Review of business requirements, data mappings and technical specifications documents.
Preparing and executing the corresponding test plans and test cases.
Involved in Test Plan, Test Analysis and Requirement Traceability Matrix documents' preparation.
Thorough hands-on on Quality Center - Building Test Plans, Running Test Cases, Tracking and Reporting of defects
Extensively interacted with Development team to make sure different applications are error free.
Unit Testing of Informatica code.
Involved in Regression testing, Functional testing, Integration testing, Performance testing and Load testing.

Environment: Informatica Power center 8.6.1, Power Connect, Oracle 11g, HP ALM - QC 11.0, Excel.