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
