ETL Automation Tester with Spanish

Job Role : ETL Automation Tester with Spanish

Location: Remote

Mode of hire: Full time

Mandate: Spanish Language

Job description

We are looking for a highly experienced Senior ETL Data Warehouse Tester to ensure the quality accuracy and integrity of data across complex data pipelines The candidate will be responsible for validating ETL processes performing end to end data validation and contributing to automation efforts within a largescale data ecosystem

Key Responsibilities

Design and execute ETL and Data Warehouse testing strategies across multiple layers source staging target

Validate data accuracy completeness and integrity during ETL transformations and data loads

Develop and execute complex SQL queries for data validation and reconciliation

Perform data validation testing including record counts referential integrity transformation logic validation and duplicate checks

Identify document and track defects and collaborate with development teams for resolution

Contribute to test automation frameworks using Python Pyspark

Execute various testing phases including System Integration Testing UAT and Regression Testing

Work closely with cross functional teams including Data Engineers Analysts and Business stakeholders

Required Skills

Strong experience in ETL Data Warehouse Testing

Handson experience with Ab Initio Control Center Control Centre tools

Strong proficiency in SQL Oracle databases

Unix and Shell Scripting Hive Big Data ecosystem

Experience with IDE tools IntelliJ PyCharm

Expertise in Automation using Python Pyspark

Excellent understanding of ETL workflows mappings and transformation logic

Good to Have:

Exposure to Java and Selenium based automation frameworks

Experience in test management tools eg JIRA

Knowledge of Data Lake Big Data environments

Language Requirement

Fluent in Spanish and English mandatory

Soft Skills:

Strong analytical and problem-solving skills

Excellent communication and stakeholder management

Ability to work in a fast-paced client facing environment

Mandatory Skills : ETL / Datawarehouse testing