SUMMARY

• Over 6+ years of Professional Experience in Software Quality Assurance and Testing in different environments and platforms including Data Warehousing applications.
• Worked with IT Operations to ensure test environment readiness.
• Experience in SDLC methodology
• Experience using query tools for Oracle, MS SQL Server and Teradata to validate reports and troubleshoot data quality issues.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Used Quality Center and RTC for logging the Defects.
• Experience in ALM/Excel.
• Experience in Iterative / Agile / Scrum development.
• Experience in testing and writing SQL statements.
• Proficient experience in different Databases like Oracle, SQL Server and Teradata.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Ability to interact with developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Extensive background in QA methodologies.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in testing XML files and validating the data loaded to staging tables.
• Experience in Big Data technologies specifically in Hadoop ecosystem Hive.
• Experience in writing HQL queries.
• Experience in UNIX shell scripting (Korn shell/Bourne shell)
• Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS

Testing Tools: Mercury Quality Center, Rational Clear Quest, Jira, ALMRDBMS Oracle 10g/9i/8i/7.x, MS SQL Server 2008, Teradata V14

Development tools Informatica: Datastage

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

ETL Test Engineer

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Extensively used Data Stage for extraction, transformation and loading process.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc. to ensure the proper delivery of the application into the production environment.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Designed and kept track of Requirement Traceability Matrix
• Rational Clear Quest Test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Rational Clear Quest for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Extensively used Data Stage tools. The objective is to extract data stored in Teradata database to load finally into a single data warehouse repository, which is in Teradata.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Implemented and maintained tools required to support data warehouse testing.
• Performed the tests in both the QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Experience in Big Data technologies specifically in Hadoop ecosystem Hive.
• Experience in writing HQL queries.
• Participate in weekly meeting with the management team and walkthroughs.
• Experience in leading the team.
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center.

Environment: Data Stage 8.5, SQL, HP Quality Center 10, MS Excel,MS Word, Teradata SQL Assistant, Rational Clear Quest, Secure CRT, Secure FX, Jira, HIVE

Confidential

ETL Test Analyst

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Performed complex defect reports in various environments like UAT, SIT, and QA etc to ensure the proper delivery of the application into the production environment.
• Designed and kept track of Requirement Traceability Matrix
• Quality Center updates and test cases loading and writing Test Plan and executing Test Cases and printing status report for the team meetings.
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used Quality Center for defect tracking.
• Performed data quality analysis using advanced SQL skills.
• Tested slides for data flow and process flows using PowerPoint and Microsoft Visio
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Testing the reports and maintenance of daily, monthly and yearly.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2008
• Performed the tests in both the QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation in HP Quality Center
• Created different user defined functions for applying appropriate business rules

Environment: Informatica 8.6, SQL, PL/SQL, HP Quality Center 10, MS Excel, SQL Server, Toad