ETL test engineer
Expleo Group · Mumbai · onsite · Posted 33d ago
Undisclosed5–10 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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-tou0002target 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 sourceu0002to-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-tou0002target 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 sourceu0002to-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-tou0002target 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 sourceu0002to-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
- 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-tou0002target 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 sourceu0002to-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
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Skills
data qualityDB2AuditingStored ProceduresWindowsdata architecturetest executionTest scriptsTest strategySQL
About Expleo Group
Expleo Group
IT Services & Consulting
4.7k+
employees
1966
60 years old
Chennai, Tamil Nadu
India
₹7.4L PA avg
Avg at Expleo Group
About
Expleo is a trusted partner for end-to-end, integrated engineering, quality services and management consulting for digital transformation.
Industries
IT Services & Consulting
Employee ratings
0 reviews
3.5/ 5
Employees rate it well for
Work-Life Balance36Company Culture35
Find them on