Z
Data/ETL Test lead
Z
- 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
Key Skills
Data Migration Validation
Test Strategy and Leadership
