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(Valuable 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

📌 Data/ETL test lead (Pune)
🏢 Zensar Technologies
📍 Pune