ETL test engineer

Overview

Engineer3+ Years of experience as ETL TestEngineer4+ Years of experience as ETL TestEngineer for B.Sc. / BCA /B.Com./BBA Test Strategy & PlanningCreate comprehensive test plans for each upcoming release.Design test strategy documents outlining the scope and timelines.Draft target test scenarios based on business requirement documents.Map business rules to specific source-to target data validations.Establish the testing harness and select required automation tools.Data Architecture & SQL DevelopmentReview data models to understand relational database structures.Write complex SQL scripts to validate source to-target mapping.Build database views to simplify complex data verification tasks.Develop custom stored procedures and functions for automated checks.Review database triggers to ensure integrity constraints remain intact.Optimize slow-running test queries to speed up execution windows.ETL Validation & Platform MigrationValidate source data quality before extraction processes begin.Verify data transformation logic against specified business rules.Confirm successful data loading into the target tables.Execute DB2 versus Cloudera data platform comparison reports.Audit comparison reports for data completeness and consistency.Test Execution & Defect Management.Execute manual and automated test scripts within strict timelines.Log identified data discrepancies in the bug tracking system.Troubleshoot complex query errors and performance bottlenecks.Retest resolved defects to confirm successful code fixes.Should have passed B.E./B. TECH in any stream/ MCA/ M.Sc. (IT) Plus 3(Three) Years of experience as ETL Test Engineer OR B.Sc. / BCA /B.Com./BBA/+ 4 years ofsimilar work experience afterpassing the degree from any recognized College/University duly approved by AICTE.AND Should have passed/ Should clear ITSQB Foundation Level within three months of joining or its equivalent.

Responsibilities

• Engineer3+ Years of experience as ETL TestEngineer4+ Years of experience as ETL TestEngineer for B.Sc. / BCA /B.Com./BBA Test Strategy & PlanningCreate comprehensive test plans for each upcoming release.Design test strategy documents outlining the scope and timelines.Draft target test scenarios based on business requirement documents.Map business rules to specific source-to target data validations.Establish the testing harness and select required automation tools.Data Architecture & SQL DevelopmentReview data models to understand relational database structures.Write complex SQL scripts to validate source to-target mapping.Build database views to simplify complex data verification tasks.Develop custom stored procedures and functions for automated checks.Review database triggers to ensure integrity constraints remain intact.Optimize slow-running test queries to speed up execution windows.ETL Validation & Platform MigrationValidate source data quality before extraction processes begin.Verify data transformation logic against specified business rules.Confirm successful data loading into the target tables.Execute DB2 versus Cloudera data platform comparison reports.Audit comparison reports for data completeness and consistency.Test Execution & Defect Management.Execute manual and automated test scripts within strict timelines.Log identified data discrepancies in the bug tracking system.Troubleshoot complex query errors and performance bottlenecks.Retest resolved defects to confirm successful code fixes.Should have passed B.E./B. TECH in any stream/ MCA/ M.Sc. (IT) Plus 3(Three) Years of experience as ETL Test Engineer OR B.Sc. / BCA /B.Com./BBA/+ 4 years ofsimilar work experience afterpassing the degree from any recognized College/University duly approved by AICTE.AND Should have passed/ Should clear ITSQB Foundation Level within three months of joining or its equivalent.

Qualifications

• B.E./B. TECH in any stream/ MCA/ M.Sc. (IT)
• Bachelors degree

Essential skills

• Engineer3+ Years of experience as ETL TestEngineer4+ Years of experience as ETL TestEngineer for B.Sc. / BCA /B.Com./BBA Test Strategy & PlanningCreate comprehensive test plans for each upcoming release.Design test strategy documents outlining the scope and timelines.Draft target test scenarios based on business requirement documents.Map business rules to specific source-to target data validations.Establish the testing harness and select required automation tools.Data Architecture & SQL DevelopmentReview data models to understand relational database structures.Write complex SQL scripts to validate source to-target mapping.Build database views to simplify complex data verification tasks.Develop custom stored procedures and functions for automated checks.Review database triggers to ensure integrity constraints remain intact.Optimize slow-running test queries to speed up execution windows.ETL Validation & Platform MigrationValidate source data quality before extraction processes begin.Verify data transformation logic against specified business rules.Confirm successful data loading into the target tables.Execute DB2 versus Cloudera data platform comparison reports.Audit comparison reports for data completeness and consistency.Test Execution & Defect Management.Execute manual and automated test scripts within strict timelines.Log identified data discrepancies in the bug tracking system.Troubleshoot complex query errors and performance bottlenecks.Retest resolved defects to confirm successful code fixes.Should have passed B.E./B. TECH in any stream/ MCA/ M.Sc. (IT) Plus 3(Three) Years of experience as ETL Test Engineer OR B.Sc. / BCA /B.Com./BBA/+ 4 years ofsimilar work experience afterpassing the degree from any recognized College/University duly approved by AICTE.AND Should have passed/ Should clear ITSQB Foundation Level within three months of joining or its equivalent.

Experience

• upto 5 Yrs