Data/ETL test lead
At a glance
Senior Data Engineering role at Fa Etvl Saasfaprod1. Pune.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Lead data and ETL testers, setting test plans and overseeing reporting and governance
- Shape test coverage from source-to-target mappings, then use SQL to reconcile data across systems and warehouses
- Check transformations, aggregates, filters, boundaries, null handling, truncation, duplicates, and overall data integrity
- Coordinate testing through Scrum ceremonies, resolve defects with engineers, and validate cutover and production migrations
- Build automated ETL checks and connect test routines to CI/CD pipelines when needed
What you bring
- At least eight years testing ETL or data warehouses, including backend data validation
- Hands-on experience in Agile or Scrum delivery, plus advanced SQL across relational databases or cloud data platforms
- Familiarity with enterprise ETL products or cloud data-processing frameworks
- A BE or MCA qualification
Who this fits
This senior role suits someone who can lead ETL testers while staying hands-on with SQL-based validation and migration checks. You’ll work closely with developers, data engineers, and business stakeholders. The role is based in Pune, India.
From the employer
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
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.