SUMMARY

• A Permanent Resident of teh USA and requires no visa sponsorship to work in teh US.
• Highly skilled and result oriented professional wif around 6 years of diverse experience as ETL Tester.
• Well - versed wif all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Professional experience in Integration, Functional, Retesting, Regression, System Testing, Load Testing and UAT Testing.
• Strong understanding of QA Process, SDLC, Waterfall, Agile methodologies and worked through different releases of product.
• Excellent understanding skills in Data models, mapping documents for testing strategies.
• Expert knowledge in creating Test Scenarios, Test Cases, Test Strategies and Defect Management to ensure Quality Assurance and to test all teh business requirements.
• Solid understanding of source to target data mapping.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Power Center workflows.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Extensive experience in developing SQL scripts to validate teh databases tables and reports data for backend database testing.
• Proficient in trouble shooting database issues and experienced in using performance monitor/profiler to solve dead locks/ long running queries.
• Proficient in developing solid QA documentation of all complexity levels: Test Plans, Test Cases, Test Summary report and Traceability matrix.
• Expertise in querying and testing RDBMS such as Teradata, Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
• Experience in Reports testing using OBIEE. Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Extensive working experience in applying Relational Database Concepts, Entity Relation diagrams and Normalization concepts for data analysis and backend testing to ensure data integrity.
• Expert in UsingQuality Center/TestDirectoras repository for maintaining test cases, execution and tracking teh defects.
• Experience in working wif Software Development team in resolving Defects, presenting teh Defect Status reports, resolving requirement, and observed design inconsistencies.
• Actively involved in User Acceptance Testing (UAT) and Training of teh end users. Participated in cross-functional teams to reengineer and improve business processes.
• Analyzed tests results and identified areas where regression tests could be conducted.
• Superior ability to collaborate wif all stakeholders.
• Highly analytical wif strong critical-thinking and problem-solving abilities.

TECHNICAL SKILLS

Programming Languages: C, C++, Java, SQL

Test Management Tools: HP ALM 11.0, JIRA, Bugzilla

Database: Oracle 8i/9i/10g/11g, DB2 8.0/7.0, SQL Server 2005/2008

ETL tools: Informatica Power Center 9.6/10.4, Data stage 7.0/8.0

Operating Systems: Windows XP, vista, 2010

Microsoft Office: Word, PowerPoint, Excel, Access

PROFESSIONAL EXPERIENCE

Confidential, Dallas

ETL Tester

Responsibilities:

• Reviewed Data models, mapping documents and prepared test scenarios.
• Thorough out teh project in various iterations/Sprints - conducted system testing, functional testing and integration testing.
• Developed complex SQL queries and executed queries against different data bases for data validation process.
• Prepared teh Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted wif developers, business & management teams to understand teh project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Communicated teh defects identified in testing environment to teh developers and retested when bugs got fixed.
• Prepared daily status reports wif details of executed, passed, and failed test cases and defect status.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Attended teh Requirements reviews, Design reviews, Code reviews to understand teh overall Process flow and Source to Target Mappings.
• Created test cases for ETL mappings and designed documents for production support.
• Performed set up, monitoring and using Job Control System in Development/QA/Prod.
• Extensively worked wif flat files and excel sheet data sources.
• Scheduled and automated jobs to be run in a batch process.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked wif ETL groups, Acquisition team and business analysts for understating mappings for dimensions and facts.
• Worked on issues wif migration of Data from development to QA Test Environment.

Environment: Oracle 11g, Informatica Power Center 9.6.1 (Designer, workflow manager, workflow monitor), HP ALM, JIRA, SQL developer, TOAD, SQL and PL/SQL, Web Services.

Confidential, Atlanta, GA

ETL Tester

Responsibilities:

• Developed high level test matrix based on business requirements, functional and technical specifications, and development standards for assigned projects/applications.
• Developed test cases based on test matrix including test data preparation for Data Completeness, Data Transformations, Data quality, Performance and scalability.
• Developed SQL queries /scripts to validate teh data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
• Performed data quality analysis using advanced SQL skills.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Extensive SQL querying on Staging, Data Warehouse and Data Marts.
• Ensured Error logs and audit tables are generated and populated properly
• Performed UAT and Regression Testing.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Tracking and reporting teh issues to project team and management during test cycles.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute during development of knowledge transfer documentation.

Environment: Data stage 7.0, Informatica Power Center, Oracle 11g, DB2, SQL Server, HP ALM, MS Office Suite.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Worked closely wif application development teams to ensure adherence to design specifications, proposed procedures, practices and standards.
• Gathered and documented business requirements for existing and future business systems.
• Delivered business requirements, high level and detailed technical specifications and then lead teh development and business teams through design, testing and implementation phases.
• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Designed and AnalyzedTest casedesign document basing on theFunctional Requirement Specificationsto implement through testing process.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• SupportedEnd-to-endtesting for downstream systems.
• Loaded theTest Datainto teh HP QC to prepare for teh execution ofTest Cases
• Expertise in generating thedaily defectdetailedreportusing Quality Center for teh other project stake holders and teh project Management
• Maintained bug lists for critical issues usingQuality Center
• Develop/Execute Test cases to validate business requirements.
• Assisted teh UAT sessions wif teh users which were not just limited to flow of transactional data, through teh system, performance test and updating teh defect tracking list for wif UAT feed backs.

Environment: HP ALM 11.0, Agile methodologies, Windows XP/2007/2010, MS office suite.

Confidential, Atlanta, GA

QA Analyst

Responsibilities:

• Extensively involved in writing and designing templates for theTest PlansandTest cases
• Identified theTest Casesand documented them inQuality Center.
• Worked wif teh Developers and teh Test Lead to verify theTest Cases.
• Analyzed and DevelopedTest Plan, Test Cases, Test Scripts, Expected Test ResultsandTest Procedurefromfunctional.
• Involved in creating theTraceability matrixbased onFunctional requirementin each module.
• Base-lineandRegressiontests were scheduled and performed on every Release and build.
• Loaded theTest Datainto teh HP ALM to prepare for teh execution ofTest Cases
• Expertise in generating thedaily defectdetailedreportusing Quality Center for teh other project stake holders and teh project Management
• Maintained bug lists for critical issues usingQuality Center

Environment: Windows 2010, Agile Methodologies, SCRUM, HP ALM 11.0, MS Office Suite.