OpeningsFirst
How it worksPricingLog in
OpeningsFirst › Jobs in India › Jobs in Pune

Data/ETL test lead

Zensar · zensar.com
PuneLead / Manager8+ yrs
Apply on Zensar’s site
Posted 12 days ago. 110 more QA / Test Engineer jobs in Pune went up on company career pages this week. See the newer ones

Share this job on LinkedIn · X

Straight from the company’s own careers site.

The job in short

ETL test leadership.

PythonJavaSQLAzureDevOpsScrumWarehouse

Details

Found
12 d ago · posted 2026-10-26
Location
Pune, Maharashtra

Full 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

QA / Test Engineer jobs in Pune · QA / Test Engineer jobs in India · All Zensar jobs · Senior QA / Test Engineer jobs in Pune · Senior QA / Test Engineer jobs in India · Senior and manager-level jobs in Pune · Senior roles at Zensar

Get jobs like this every morning

Jobs in India · Jobs in the US · Who’s hiring in India · Who’s hiring in the US · How OpeningsFirst works · Free jobs widget · Leadership jobs in India · Leadership jobs in the US · Senior jobs in India · Senior jobs in the US · Fresher jobs in India · Entry-level jobs in the US · Remote jobs in the US · Jobs paying $150k+ · Leadership hiring this week · Guides
OpeningsFirst · Use with AI · Terms · Privacy · Refunds · Contact · Follow us on LinkedIn · X