{bc}
Apply
oracle

Data/ETL test lead

Zensar
Pune, IND
Lead · 8+ years experience
Onsite
Discovered Today
awsaws-glueazuredatabricksgcpjava

Full Job Posting

Qualifications

  • BE/MCA
  • 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.
  • Scripting: Basic to intermediate programming skills in Python or Java for test automation

Responsibilities

  • 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
  • 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.
  • 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.
  • 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

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Zensar

2 Test Automation SMEs | 1 Each for (1) Mulesoft Integration (2) Salesforce

Pune, IND

Discovered Today

Smalltalk Application SME || 12 Yrs || Offshore

Pune, IND

Discovered TodayFull-time

QE Architect

Bengaluru, IND

Discovered Today

Oracle Fusion & Vertex Integration Consultant

, IND

Discovered Today

QE Architect

Bengaluru, IND

Discovered Today

QE Architect

Bengaluru, IND

Discovered Today

ESaaS - MSD -Technical- D365 CE Principal Software Engineer-Retail D365/F&O architecture

Bengaluru, IND

Discovered Today

Salesforce CPQ Developer

, IND

Discovered Today