ETL Tester Analyst

Hace 20 horas

Lagos de Moreno, México Infosys Limited Jornada completa EUR 360,000 - EUR 720,000/año
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, a