PROFESSIONAL SUMMARY:

• Confidential has 8.5 years of work experience in ETL and Data Warehousing and has 3 years of lead experience in handling onsite, offshore and third party testing teams.
• He has excellent professional experience in ETL testing, Development and Maintenance Projects.
• He possesses admirable ETL and Domain knowledge in Insurance, Mobile networks and Banking and Financial Services and also have real time experience in Software Development Life cycle (SDLC).
• Has competent working experience with ETL tools like SSIS, Datastage and Informatica.
• He has worked with many databases including SQL SERVER, ORACLE, TERADATA, NETEZZA and HADOOP databases and possesses good hands on experience in writing T - SQL and PL/SQL scripts and also uses UNIX commands and scripts in day to day activities.
• Worked as an extensive ETL tester in many projects oriented towards ETL testing, Report testing and table data validation and has good real time experience on Data Warehousing concepts like OLAP, Star Schema, Snow Flake Schema, Data Marts, Dimension and Fact tables.

TECHNICAL SKILLS:

Programming Languages: SQL and PL/SQL and UNIX Scripts

Operating Systems: Windows XP/10/Linux/Unix

Database Tools: Oracle, SQL Server, Teradata, Netezza, Hadoop

Other Tools and Skills: TOAD, SQL Developer, FTP, WinSCP, Putty, HP ALM, Autosys

ETL and BI skillset: SSIS, Datastage 8.1, Informatica, SSRS, SSAS

PROFESSIONAL EXPERIENCE:

Confidential

Programming Languages/Tools: Informatica, Datastage, Teradata, SQL

Onsite QA Lead

Responsibilities:

• Responsible for validating the migrated code
• Compared Datastage jobs and Informatica jobs
• Performed back-end testing of ETL between the source and the target using the SQL queries
• Written SQL queries to compare and reconcile source and target tables
• Performed comparison of all tables and output files which are in scope
• Performed data cleaning to eliminate all data errors and help arriving decision making
• Keeps track of all the issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified
• Performed System Test Plan and Test Outline documents
• Responsible for testing 1000+ Informatica mappings with converted Datastage jobs, and at least 1000 tables
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Conducted Defect triage meeting and resolved defects
• Defines mock-up test data needed to execute testing
• Escalated testing defects, problems, and issues to Project Manager and Lead Test Manager for timely resolution
• Closely worked with business to understand their requirements
• Worked with operations team to coordinate the build of the testing environment for the initiative
• Developed comprehensive and reusable test cases
• Performed Test Phase Summary Reports for the projects

Confidential

Programming Languages/Tools: Datastage, PL/SQL, T-SQL, Teradata

Responsibilities:

• Provided Estimations, End to End project test outline
• Performed comparison of all tables and output files which are in scope.
• Keeps track of all issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified.
• Prepared System Test Plan, Test Outline documents.
• Responsible for testing 250+ Ad hoc reports, and at least 100 dashboard reports.
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Conducted Defect Triage meeting and resolved defects
• Prepared Test Phase Summary Report for this projects

Confidential

Programming Languages/Tools: Datastage, PL/SQL, T-SQL, Teradata

Responsibilities:

• Responsible for Estimations, End to End project test Layout
• Compared tables and output files which are in scope
• Keeps track of all issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified
• Prepared System Test Plan, Test Outline documents
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Provided Test Plan Walkthrough to the Project team
• Reviewed deliverables from Offshore team
• Conducted Defect triage meeting and resolved defects
• Prepared Test Phase Summary Report for this project

Confidential

Programming Languages/Tools: Datastage, PL/SQL, Oracle-SQL, Teradata

Onsite QA Analyst

Responsibilities:

• Prepared a PL/SQL script for validation of more than 200+ fact tables.
• Performed database testing involving SQL SERVER, ORACLE and TERADATA for this project.
• Compared tables and output files which are in scope.
• Keeps track of all issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified
• Prepared System Test Plan, Test Outline documents
• Tested 300+ jobs impacting 900+ tables
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Performed analysis of requirements, identifying the potential issues/concerns before testing starts
• Provided Test Plan Walkthrough to the Project team
• Reviewed deliverables from Offshore team
• Conducted Defect triage meeting and resolved defects
• Prepared Test Phase Summary Report for this project

Confidential

Programming Languages/Tools: Datastage, PL/SQL, Oracle-SQL

Responsibilities:

• Provided Estimations, End to End project test design
• Prepared System Test Plan, Test Outline documents
• Performed back-end testing involving SQL Server and Oracle databases.
• Provided Test Plan Walkthrough to the Project team
• Conducted Defect triage meeting and resolved defects
• Performed analysis of the requirements and provided test points to user stories.
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Performed analysis of requirements and identifying the potential issues/concerns before testing starts
• Keeps track of all issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified.
• Reviewed deliverables from Offshore team
• Prepared Test Phase Summary Report for this projects

Confidential

Programming Languages/Tools: Data stage, PL/SQL, Oracle-SQL, Informatica

Onsite QA Analyst

Responsibilities:

• Responsible for requirements study
• Prepared Test Scenarios document
• Performed data validation for all requirements and verified the execution from offshore.
• Prepared System Test Plan, Test Outline documents
• Provided Test Plan Walkthrough to the Project team
• Conducted defect triage meeting and resolved defects
• Performed analysis of the requirements and provided test points to user stories.
• Interacted with customers, gathered and clarified the requirements and has shared the same with offshore team
• Keeps track of all issues identified, raising necessary defects and set up meeting with project team if any potential critical issues are identified.
• Reviewed deliverables from Offshore team
• Prepared Test Phase Summary Report for this projects

Confidential

Programming Languages/Tools: Data stage, PL/SQL, Oracle-SQL, Informatica, SQL server, T-SQL

Responsibilities:

• Allocated tasks to team mates and tracked progression of tasks
• Tracked the progression of Project.
• Performed Requirements Study
• Prepared test plan and test cases
• Performed peer review of test cases
• Performed execution of test cases
• Performed Regression Testing
• Validated Defect Retesting
• Performed Data Validation
• Prepared Execution Summary Report

Confidential

Programming Languages/Tools: Data stage, PL/SQL, Oracle-SQL, SSIS, SQL server, T-SQL

Responsibilities:

• Allocated tasks to team mates and tracked progression of tasks
• Tracked the progression of Project
• Performed Requirements Study
• Prepared test plan and test cases
• Performed peer review of test cases
• Performed execution of test cases
• Performed Regression Testing
• Validated Defect Retesting
• Performed Data Validation
• Prepared Execution Summary Report

Confidential

Programming Languages/Tools: SSIS, SSAS, PL/SQL, Oracle-SQL, SSRS, SQL server, T-SQL

Offshore ETL Tester

Responsibilities:

• Performed Requirements Study
• Performed validation of all test scenarios and test data
• Prepared test plan
• Designed test scenarios and test cases
• Performed execution of test cases
• Performed retesting of defects
• Prepared Execution Summary Report