Search by job, company or skills

Data/ETL Test lead

Data/ETL Test lead

Zensar Technologies Limited
8-12 Years
Not Disclosed
Early Applicant
Quick Apply
  • Posted 6 days ago
  • Be among the first 40 applicants

Job Description

ETL / Data Warehouse Test Lead

Role Summary

We are looking for an experienced ETL / Data Warehouse Test Lead to lead data testing activities, define test strategies, and ensure data accuracy, integrity, and quality across data migration and ETL processes. The role involves hands-on SQL validation, Agile collaboration, test governance, team leadership, and cutover and production migration validation.

Key Responsibilities

1. Test Leadership and Governance

  • Lead a team of data and ETL testers.
  • Define test strategies, test plans, scope, and execution timelines.
  • Manage test reporting, governance, progress tracking, and quality metrics.
  • Oversee defect tracking and resolution throughout the defect lifecycle using ServiceNow, Jira, or Azure DevOps.
  • Coordinate with developers, data engineers, and business stakeholders to ensure timely defect resolution.

2. Agile Scrum and Collaboration

  • Participate in Sprint Planning to review user stories, define acceptance criteria, and estimate testing efforts.
  • Attend Daily Stand-ups to communicate testing progress, blockers, and data dependencies.
  • Participate in Backlog Grooming and Sprint Retrospectives to improve testing processes and workflows.
  • Promote early testing and effective collaboration across development and data engineering teams.

3. ETL and Data Validation Testing

  • Review Source-to-Target Mapping (STM) documents and business rules to develop test scenarios.
  • Write and execute complex SQL queries for data verification, record counts, and reconciliation across source systems, staging environments, and data warehouses.
  • Validate data transformations, aggregations, filtering logic, and boundary conditions.
  • Perform data integrity, truncation, NULL-value, and duplicate checks.
  • Ensure accuracy and completeness of data across ETL and data migration workflows.

4. Cutover and Production Migration Validation

  • Support cutover activities and production data migration validation.
  • Verify migrated data against source systems and business requirements.
  • Identify and coordinate resolution of data discrepancies during production migration.

5. Test Automation – Good to Have

  • Build, maintain, and execute automated ETL test scripts using Python, Pytest, or Java.
  • Integrate automated testing routines into CI/CD pipelines using Jenkins, Azure DevOps, or GitHub Actions.

Required Qualifications and Skills

  • Experience: 8+ years of hands-on experience in ETL / Data Warehouse testing and backend data validation.
  • Education: BE or MCA.
  • Agile: Strong experience working in Agile/Scrum environments.
  • Database and SQL: Advanced SQL querying skills across SQL Server, Oracle, PostgreSQL, or cloud data platforms such as GCP, Snowflake, Databricks, AWS, or Azure.
  • ETL Tools: Familiarity with Informatica, SSIS, Talend, AWS Glue, or other cloud data processing frameworks.
  • Leadership: Experience leading data testing teams and managing test strategy, planning, reporting, and governance.
  • Soft Skills: Strong analytical, communication, collaboration, and problem-solving abilities.

Good to Have

  • Basic to intermediate programming skills in Python or Java.
  • Experience with ETL test automation frameworks such as Pytest.
  • Knowledge of CI/CD pipeline integration and automated testing.

More Info

Job Type:
Function:
Employment Type:

Key Skills

Data Migration Validation

Test Strategy and Leadership