ETL Tester Analyst

Infosys Limited

Región Centro

On-site

MXN 360,000 - 720,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 hiring a Quality Engineering Analyst specialized in ETL testing. You will validate source-to-target data flows, transformations, and data quality across ETL pipelines and data warehouses, designing detailed test scenarios and data sets.

Strong SQL skills and backend testing are essential. The role collaborates with Data Engineers, Analysts, and Project Managers to ensure reliable data delivery and timely defect resolution in agile sprint cycles.

Qualifications

  • ETL testing and data validation experience.
  • Strong SQL skills for backend data validation.
  • Experience with source-to-target data validation and reconciliation.
  • Familiarity with data warehouses and data integration concepts.
  • Knowledge of SDLC and Agile/Scrum processes.

Responsibilities

  • Analyze BRDs and data mapping to design ETL tests.
  • Design and execute ETL test scenarios and test data.
  • Validate data extraction, transformation, and loading across systems.
  • Develop SQL queries for data validation and reconciliation.
  • Verify transformation rules, calculations, and lookups.
  • Perform data quality checks: completeness, accuracy, NULLs, duplicates.
  • Test full, incremental, delta loads and historical data loads.
  • Log, track, and retest defects using Jira or Azure DevOps.
  • Prepare test execution and defect reports for stakeholders.
  • Collaborate with Data Engineers, Analysts, and Project Managers.

Skills

ETL Testing
SQL Proficiency
Data Validation
Source-to-Target Validation
Data Warehouse Concepts
Regression Testing
Analytical Skills
Communication Skills
Data Reconciliation
Agile/Scrum
End-to-End Testing

Tools

Informatica
Talend
SSIS
Azure Data Factory
Snowflake
SQL Server
Oracle
Jira

Job description

Process|Testing processes|Test Automation Process

Domain

Delivery

Interest Group

Infy Mexico

Company

Requisition ID

155837BR

Job Description – ETL Tester

Job Title: Quality Engineering Analyst
Location: Mexico
Experience: 6-7 Years
Role Summary
We are seeking an ETL Tester with strong experience in ETL testing, data validation, and SQL-based backend testing. The candidate will be responsible for validating source-to-target data flows, transformation rules, data quality, and reconciliation, preparing and executing test scenarios, identifying data defects, and ensuring accurate and reliable data delivery across ETL pipelines and data warehouse systems.

Key Responsibilities
  • Analyze Business Requirements Documents (BRD), User Stories, Source-to-Target Mapping documents, and data transformation specifications.
  • Design and execute detailed ETL test scenarios, test cases, and test data based on business and technical requirements.
  • Perform source-to-target data validation to ensure completeness, accuracy, and consistency of data.
  • Validate data extraction, transformation, and loading processes across multiple source and target systems.
  • Develop and execute complex SQL queries for backend data validation and reconciliation.
  • Validate transformation rules, business logic, calculations, aggregations, joins, filters, and lookup logic.
  • Perform data completeness, data accuracy, duplicate, NULL, referential integrity, and data quality checks.
  • Validate full loads, incremental loads, delta loads, and historical data loads.
  • Perform record count, field-level, aggregate, and source-versus-target reconciliation.
  • Test ETL workflows, batch jobs, scheduled jobs, and dependencies to ensure successful end-to-end data processing.
  • Identify, log, track, and retest data defects using Jira, Azure DevOps, or similar defect management tools.
  • Perform functional, integration, regression, system, and end-to-end testing of data pipelines.
  • Participate in requirement reviews, sprint planning, daily stand-ups, defect triage, and release activities.
  • Collaborate closely with Data Engineers, Developers, Business Analysts, Data Architects, Product Owners, and Project Managers.
  • Prepare test execution reports, defect reports, reconciliation results, and data quality metrics for stakeholders.
Job Description – ETL Tester

Job Title: Quality Engineering Analyst
Location: Mexico
Experience: 6-7 Years
Role Summary
We are seeking an ETL Tester with strong experience in ETL testing, data validation, and SQL-based backend testing. The candidate will be responsible for validating source-to-target data flows, transformation rules, data quality, and reconciliation, preparing and executing test scenarios, identifying data defects, and ensuring accurate and reliable data delivery across ETL pipelines and data warehouse systems.

Key Responsibilities
  • Analyze Business Requirements Documents (BRD), User Stories, Source-to-Target Mapping documents, and data transformation specifications.
  • Design and execute detailed ETL test scenarios, test cases, and test data based on business and technical requirements.
  • Perform source-to-target data validation to ensure completeness, accuracy, and consistency of data.
  • Validate data extraction, transformation, and loading processes across multiple source and target systems.
  • Develop and execute complex SQL queries for backend data validation and reconciliation.
  • Validate transformation rules, business logic, calculations, aggregations, joins, filters, and lookup logic.
  • Perform data completeness, data accuracy, duplicate, NULL, referential integrity, and data quality checks.
  • Validate full loads, incremental loads, delta loads, and historical data loads.
  • Perform record count, field-level, aggregate, and source-versus-target reconciliation.
  • Test ETL workflows, batch jobs, scheduled jobs, and dependencies to ensure successful end-to-end data processing.
  • Identify, log, track, and retest data defects using Jira, Azure DevOps, or similar defect management tools.
  • Perform functional, integration, regression, system, and end-to-end testing of data pipelines.
  • Participate in requirement reviews, sprint planning, daily stand-ups, defect triage, and release activities.
  • Collaborate closely with Data Engineers, Developers, Business Analysts, Data Architects, Product Owners, and Project Managers.
  • Prepare test execution reports, defect reports, reconciliation results, and data quality metrics for stakeholders.
Required Skills
  • Strong hands-on experience in ETL Testing and Data Validation.
  • Strong knowledge of SQL, including joins, subqueries, aggregate functions.
  • Experience performing source-to-target data validation and reconciliation.
  • Strong understanding of ETL processes, data pipelines, data warehouses, and data integration concepts.
  • Experience validating transformation rules and business logic.
  • Experience performing data completeness, accuracy, integrity, duplicate, NULL, and reconciliation testing.
  • Good understanding of fact tables, dimension tables, primary/foreign keys, and data warehouse concepts.
  • Knowledge of Slowly Changing Dimensions (SCD Type 1 and Type 2) and their validation.
  • Experience validating full, incremental, and delta data loads.
  • Experience with relational databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar platforms.
  • Experience with ETL/data integration tools such as Informatica, Talend, SSIS, DataStage, Azure Data Factory, or similar tools.
  • Experience with defect management tools such as Jira.
  • Strong understanding of SDLC, STLC, Agile/Scrum, and defect lifecycle management.
  • Strong analytical, troubleshooting, problem-solving, 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 data integration tools.
  • Knowledge of Python, unix for data validation and test automation.
  • Exposure to ETL test automation and data reconciliation frameworks.
  • Experience working with large-volume datasets and complex data pipelines.
  • Knowledge of data quality frameworks, metadata validation, and data lineage.
  • Experience validating CSV, JSON, XML, Parquet, and flat-file data.
  • Exposure to API and database integration testing.
  • Knowledge of CI/CD and version control tools such as Git, Jenkins, Azure DevOps, or GitHub Actions.
  • Experience supporting UAT, production validation, and post-production data reconciliation.
  • Ability to communicate in Spanish is preferred for Mexico client engagements.
Key Deliverables
  • Test Strategy and ETL Test Plan
  • Source-to-Target Validation Test Cases
  • SQL Validation and Reconciliation Scripts
  • ETL Test Execution Reports
  • Data Quality and Reconciliation Reports
  • Defect Reports and Traceability Matrix
  • Regression Testing Results
  • Data Load Validation Reports
  • 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 Test Lead
ETL Test Lead

Infosys Limited • Monterrey

On-site
MXN 900,000 - 1,300,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 Analyst Selenium
Automation Analyst Selenium

Infosys Limited • Monterrey

On-site
MXN 420,000 - 640,000
Automation Analyst Playwright
Automation Analyst Playwright

Infosys Limited • Región Centro

On-site
MXN 420,000 - 650,000
Automation Analyst Playwright
Automation Analyst Playwright

Infosys Limited • Estado de México

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

Infosys Limited • Región Centro

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

Infosys • Santiago de Querétaro

On-site
MXN 480,000 - 880,000
Automation Analyst Selenium
Automation Analyst Selenium

Infosys • Estado de México

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