ETL test engineer at expleo in IN-MH-Mumbai
- Company: expleo
- Location: IN-MH-Mumbai
- Posted: Sep 21, 2026
- Type: Permanent
- Experience: 5+ years
Overview
Engineer 3+ Years of experience as ETL Test Engineer 4+ Years of experience as ETL Test Engineer for B.Sc. / BCA /B.Com./BB A Create comprehensive test plans for each upcoming release. Design test strategy documents outlining the
Job description
- Engineer
- 3+ Years of
- experience
- as ETL Test
- Engineer
- 4+ Years of
- experience
- as ETL Test
- Engineer for
- B.Sc. / BCA
- /B.Com./BB
- A
Responsibilities
- Create 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-totarget data validations.
- Establish the testing harness and select
- required automation tools.
- Data Architecture & SQL Development
- Review data models to understand relational
- database structures.
- Write complex SQL scripts to validate sourceto-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 Migration
- Validate 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 of
- similar work
- experience after
- passing 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.
- Engineer
- 3+ Years of
- experience
- as ETL Test
- Engineer
- 4+ Years of
- experience
- as ETL Test
- Engineer for
- B.Sc. / BCA
- /B.Com./BB
- A
- Test Strategy & Planning
- Create 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-totarget data validations.
- Establish the testing harness and select
- required automation tools.
- Data Architecture & SQL Development
- Review data models to understand relational
- database structures.
- Write complex SQL scripts to validate sourceto-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 Migration
- Validate 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 of
- similar work
- experience after
- passing 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.
Requirements
- B.E./B. TECH in any stream/ MCA/ M.Sc. (IT)
- Bachelors degree
- Essential skills
- Engineer
- 3+ Years of
- experience
- as ETL Test
- Engineer
- 4+ Years of
- experience
- as ETL Test
- Engineer for
- B.Sc. / BCA
- /B.Com./BB
- A
- Test Strategy & Planning
- Create 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-totarget data validations.
- Establish the testing harness and select
- required automation tools.
- Data Architecture & SQL Development
- Review data models to understand relational
- database structures.
- Write complex SQL scripts to validate sourceto-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 Migration
- Validate 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 of
- similar work
- experience after
- passing 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.
Skills
Required
- ETL testing
- SQL scripting
- Test strategy and planning
- Data validation
- Automation tools
- DB2 and Cloudera data platforms
- Bug tracking