ETL Test Lead

Infosys Limited

Monterrey

On-site

MXN 900,000 - 1,300,000

Full time

22 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Infosys Limited in Mexico is seeking an ETL QA Lead with 8-10 years of hands-on experience in ETL testing, data validation, SQL, and data warehouse testing. The role involves leading the overall ETL testing strategy, validating data flows, driving data quality, and mentoring the QA team to ensure reliable data delivery across pipelines.

The candidate will collaborate with Data Engineers, Developers, BAs, and PMs to manage testing activities, risk, and release readiness, while maintaining high

Qualifications

  • 8-10 years of ETL QA/testing experience.
  • Hands-on ETL testing, data validation, and data warehouse testing.
  • Strong SQL skills including complex queries and data reconciliation.
  • Experience leading ETL/Data QA teams and testing initiatives.
  • Understanding of ETL processes, data pipelines, and data integration architecture.

Responsibilities

  • Lead ETL testing strategy, planning, estimation, execution, and release validation.
  • Define and review ETL test scenarios, test data, and SQL validation approaches.
  • Oversee source-to-target validation, data quality, and reconciliation.
  • Mentor QA team members and ensure adherence to testing standards.
  • Collaborate with Data Engineers, Developers, BAs, and PMs to ensure data integrity and release readiness.

Skills

ETL Testing
Data Validation
SQL
Data Warehouse Testing
Lead Testing
SDLC/STLC
Agile/Scrum
Mentoring
Stakeholder Management

Tools

SQL Server
Oracle
PostgreSQL
Snowflake
Informatica
Talend
SSIS
Azure Data Factory

Job description

Process|Testing processes|Test Automation Process

Domain

Delivery

Interest Group

Infy Mexico

Company

Requisition ID

155841BR

Job Description – ETL QA Lead

Job Title: Quality Engineering Lead
Location: Mexico
Experience: 8-10 Year
Role Summary
We are seeking an ETL QA Lead with strong hands‑on experience in ETL testing, data validation, SQL, and data warehouse testing. The candidate will be responsible for leading the overall ETL testing strategy and execution, validating source‑to‑target data flows and transformation rules, driving data quality and reconciliation, mentoring QA team members, managing quality risks, and ensuring accurate and reliable data delivery across ETL pipelines and data platforms.
Key Responsibilities

  • Analyze Business Requirements Documents (BRD), User Stories, Source-to-Target Mapping documents, and data transformation specifications.
  • Lead ETL testing strategy, planning, estimation, execution, and release validation activities.
  • Define and review ETL test scenarios, test cases, test data, and SQL validation approaches based on business and technical requirements.
  • Lead source-to-target validation and reconciliation, ensuring data completeness, accuracy, consistency, and integrity.
  • Validate complex data extraction, transformation, business rules, calculations, aggregations, joins, filters, and loading processes.
  • Develop and review complex SQL queries for backend validation, reconciliation, and data quality verification.
  • Ensure appropriate validation of full, incremental, delta, and historical data loads, including SCD validation.
  • Lead testing of ETL workflows, batch jobs, scheduled jobs, dependencies, and end-to-end data pipelines.
  • Review test execution results, reconciliation reports, defects, and data quality findings and drive issues to closure.
  • Guide and mentor QA team members, review testing deliverables, and ensure adherence to testing standards and best practices.
  • Identify quality risks, dependencies, test coverage gaps, and data issues and define appropriate mitigation plans.
  • Represent QA in requirement reviews, sprint/release planning, defect triage, release-readiness, and stakeholder discussions.
  • Collaborate with Data Engineers, Developers, Business Analysts, Data Architects, Product Owners, DevOps teams, and Project Managers.
  • Provide stakeholders with test execution status, data quality metrics, defect trends, risks, and release-readiness updates.
Required Skills
  • Strong hands‑on experience in ETL Testing, Data Validation, and Data Warehouse Testing.
  • Strong expertise in SQL, including joins, subqueries, CTEs, aggregate functions, and analytical/window functions.
  • Strong experience in source-to-target validation, data reconciliation, and transformation rule validation.
  • Experience in leading ETL/Data QA teams and testing initiatives.
  • Strong understanding of ETL processes, data pipelines, data warehouses, and data integration architecture.
  • Experience with data completeness, accuracy, integrity, duplicate, NULL, referential integrity, and reconciliation testing.
  • Strong understanding of fact tables, dimension tables, primary/foreign keys, and Slowly Changing Dimensions (SCD Type 1 and Type 2).
  • Experience validating full, incremental, delta, and historical data loads.
  • Experience with databases/data platforms such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar technologies.
  • Experience with ETL/data integration technologies such as Informatica, Talend, SSIS, DataStage, Azure Data Factory, or similar tools.
  • Experience with test estimation, resource planning, defect management, risk management, and quality reporting.
  • Strong understanding of SDLC, STLC, Agile/Scrum, and defect lifecycle management.
  • Strong leadership, mentoring, stakeholder management, analytical, troubleshooting, and communication skills.
Preferred Skills
  • Experience with cloud data platforms such as Snowflake, GCP, Azure Synapse Analytics, Databricks, or AWS Redshift.
  • Experience with cloud-based ETL and data integration platforms.
  • Knowledge of Python and Unix/Linux for data validation and test automation.
  • Experience with ETL test automation and automated data reconciliation frameworks.
  • Experience testing large-volume datasets and complex data pipelines.
  • Knowledge of data quality frameworks, metadata validation, and data lineage.
  • Experience with different data formats including CSV, JSON, XML, Parquet, and flat files.
  • Knowledge of CI/CD and version control using Git, Jenkins, Azure DevOps, or GitHub Actions.
  • Experience supporting UAT, production validation, post-production reconciliation, and release readiness.
  • Ability to communicate in Spanish is preferred for Mexico client engagements.
Key Deliverables
  • ETL Test Strategy and Test Plan
  • Source-to-Target Validation Approach and Test Cases
  • SQL Validation and Reconciliation Scripts
  • ETL Test Execution and Data Quality Reports
  • Defect Reports and Traceability Matrix
  • Test Coverage, Defect, and Quality Metrics
  • Data Load and Reconciliation Reports
  • Quality Risk and Release Readiness Assessment
  • UAT/Production Validation Support
  • Test Closure Report

Additional Required Qualifications

NA

About Us

Infosys is a global leader in next-generation digital services and consulting. We enable clients in more than 50 countries to navigate their digital transformation. With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer our clients through their digital journey. We do it by enabling the enterprise with an AI-powered core that helps prioritize the execution of change. We also empower the business with agile digital at scale to deliver unprecedented levels of performance and customer delight. Our always-on learning agenda drives their continuous improvement through building and transferring digital skills, expertise, and ideas from our innovation ecosystem.

EEO

Infosys provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Tester Analyst
ETL Tester Analyst

Infosys Limited • Región Centro

On-site
MXN 360,000 - 720,000
ETL QA Lead: Data Quality & Pipeline Champion
ETL QA Lead: Data Quality & Pipeline Champion

Infosys Limited • Monterrey

On-site
MXN 900,000 - 1,300,000
Automation Lead Selenium .Net
Automation Lead Selenium .Net

Infosys Limited • Región Centro

On-site
MXN 600,000 - 850,000
Automation Lead Selenium .Net
Automation Lead Selenium .Net

Infosys • Región Centro

On-site
MXN 600,000 - 900,000
Automation Analyst .NET
Automation Analyst .NET

Infosys Limited • Santiago de Querétaro

On-site
MXN 600,000 - 900,000
Automation Analyst Selenium
Automation Analyst Selenium

Infosys Limited • Santiago de Querétaro

On-site
MXN 600,000 - 900,000
Automation Lead Playwright
Automation Lead Playwright

Infosys Limited • Estado de México

On-site
MXN 1,000,000 - 1,500,000
Automation Analyst Selenium
Automation Analyst Selenium

Infosys Limited • Monterrey

On-site
MXN 420,000 - 640,000
Performance Test Lead
Performance Test Lead

Infosys Limited • Estado de México

On-site
MXN 360,000 - 600,000
Automation Analyst Playwright
Automation Analyst Playwright

Infosys Limited • Región Centro

On-site
MXN 420,000 - 650,000