Data/ETL test lead

Fa Etvl Saasfaprod1

Pune District

On-site

INR 2,400,000 - 4,200,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Fa Etvl Saasfaprod1 is seeking an experienced ETL/Data Warehouse tester in Pune to lead data testing activities, validate data integrity, and ensure robust test coverage across STM mappings and data migrations.

The role requires 8+ years in ETL/ DW testing, strong SQL skills, and familiarity with enterprise ETL tools. BE/MCA is preferred; collaboration with developers and data engineers is essential for early defect resolution and CI/CD integration.

Qualifications

  • 8+ years in ETL/Data Warehouse testing and backend data validation.
  • Experience in Agile/Scrum lifecycle.
  • Advanced SQL across relational databases (SQL Server, Oracle, PostgreSQL) or cloud platforms.
  • Familiarity with enterprise ETL tools (Informatica, SSIS, Talend, AWS Glue) or cloud data processing frameworks.
  • Strong analytical, communication, and problem-solving skills to bridge gaps with stakeholders.
  • Scripting: Basic to intermediate Python or Java for test automation.
  • BE/MCA degree preferred.

Responsibilities

  • Lead a team of data/ETL testers.
  • Test strategy & planning.
  • Test reporting & governance.
  • Participate in Sprint Planning to analyze stories, define acceptance criteria, and estimate testing efforts.
  • Attend Daily Stand-ups to report testing progress and dependencies.
  • Track, manage, and log defects throughout the lifecycle in tools like ServiceNow, Jira, or Azure DevOps.
  • Cutover and production migration validation (Good to have).

Skills

ETL testing
SQL
Agile/Scrum
Data Warehouse
Backend data validation
Communication
Problem-solving

Education

BE/MCA

Tools

Informatica
SSIS
Talend
AWS Glue

Job description

Key Responsibilities :

Agile Scrum Ceremonies & Collaboration:
Participate actively in Sprint Planning to analyze user stories, define acceptance criteria, and estimate testing efforts (story points).
Attend Daily Stand-ups to report testing progress, blockages, and data dependencies.
Engage in Backlog Grooming and Sprint Retrospectives to continuously improve team processes and Data Migration / ETL testing workflows.
Proactively collaborate with developers and data engineers for early testing and rapid defect resolution.

Track, manage, and log defects throughout the defect lifecycle using tools like Service Now, Jira or Azure DevOps.

ETL & Data Validation Testing:
Review Source-to-Target Mapping (STM) documents and business rules to design robust test scenarios.
Write and execute complex SQL queries for data verification, counts, and reconciliation between source systems, staging areas, and data warehouses/marts.
Validate data transformations, aggregations, filtering logic, and boundary conditions.
Perform data integrity, data truncation, NULL-value handling, and duplicate checks.

Automation (Good to have)

Build, maintain, and execute automated ETL test scripts using frameworks like Pytest, Python, or Java.
Integrate testing routines within CI/CD pipelines (Jenkins, Azure DevOps, or GitHub Actions).

Required Qualifications & Skills:

Experience: 8+ years of hands-on experience in ETL/Data Warehouse testing and backend data validation.
Agile Knowledge: Proven experience working in an Agile/Scrum software development lifecycle.
Database & SQL: Advanced SQL querying skills across relational databases (SQL Server, Oracle, PostgreSQL) or cloud platforms (GCP, Snowflake, Databricks, AWS/Azure).
ETL Tools: Familiarity with enterprise ETL tools (Informatica, SSIS, Talend, or AWS Glue) or cloud data processing frameworks.
Soft Skills: Strong analytical, communication, and problem-solving abilities to bridge technical gaps with business stakeholders.

Good to have:

Scripting: Basic to intermediate programming skills in Python or Java for test automation

Key Responsibilities :

Lead a team of data/ETL testers

Test strategy & planning

Test reporting & governance

Participate actively in Sprint Planning to analyze user stories, define acceptance criteria, and estimate testing efforts (story points).
Attend Daily Stand-ups to report testing progress, blockages, and data dependencies.
Engage in Backlog Grooming and Sprint Retrospectives to continuously improve team processes and Data Migration / ETL testing workflows.
Proactively collaborate with developers and data engineers for early testing and rapid defect resolution.

Track, manage, and log defects throughout the defect lifecycle using tools like Service Now, Jira or Azure DevOps.

ETL & Data Validation Testing:
Review Source-to-Target Mapping (STM) documents and business rules to design robust test scenarios.
Write and execute complex SQL queries for data verification, counts, and reconciliation between source systems, staging areas, and data warehouses/marts.
Validate data transformations, aggregations, filtering logic, and boundary conditions.
Perform data integrity, data truncation, NULL-value handling, and duplicate checks.

Cutover and production migration validation

Automation (Good to have)

Build, maintain, and execute automated ETL test scripts using frameworks like Pytest, Python, or Java.
Integrate testing routines within CI/CD pipelines (Jenkins, Azure DevOps, or GitHub Actions).

Required Qualifications & Skills:

Experience: 8+ years of hands-on experience in ETL/Data Warehouse testing and backend data validation.
Agile Knowledge: Proven experience working in an Agile/Scrum software development lifecycle.
Database & SQL: Advanced SQL querying skills across relational databases (SQL Server, Oracle, PostgreSQL) or cloud platforms (GCP, Snowflake, Databricks, AWS/Azure).
ETL Tools: Familiarity with enterprise ETL tools (Informatica, SSIS, Talend, or AWS Glue) or cloud data processing frameworks.
Soft Skills: Strong analytical, communication, and problem-solving abilities to bridge technical gaps with business stakeholders.

Good to have:

Scripting: Basic to intermediate programming skills in Python or Java for test automation

BE/MCA

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Automation Test Lead - ETL, DW Automation
Senior Automation Test Lead - ETL, DW Automation

HCL Technologies Limited • India

On-site
INR 1,200,000 - 1,800,000
ETL Test Specialist | enGen Global | Chennai
ETL Test Specialist | enGen Global | Chennai

enGen Global • Chennai District

On-site
INR 900,000 - 1,400,000
ETL Test Lead
ETL Test Lead

Data Semantics • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Senior ETL QA / ETL Testing
Senior ETL QA / ETL Testing

Vivantify • India

Remote
INR 2,800,000 - 4,000,000
Etl Testing Engineer
Etl Testing Engineer

Infosys • Chennai District, Bengaluru, Hyderabad

On-site
INR 900,000 - 1,500,000
ETL Testing with Bigquery
ETL Testing with Bigquery

enGen Global • Hyderabad, Chennai

On-site
INR 1,200,000 - 1,600,000
ETL Tester
ETL Tester

People Centro India • Ernakulam

Hybrid
INR 1,339,000 - 1,786,000
Senior Data Tester
Senior Data Tester

Team Geek Solutions • Hyderabad

Hybrid
INR 1,500,000 - 2,100,000
Etl Tester
Etl Tester

Infosys • Hyderabad, Pune District, Bengaluru

On-site
INR 600,000 - 1,100,000
Etl Tester
Etl Tester

Capgemini • Hyderabad, Pune District, Chennai District

On-site
INR 800,000 - 1,400,000