ETL Developer

Turtle Trax S.A.; Región Centro; Presencial; MXN 784.381 - 1.132.996; Jornada completa

Descripción de la vacante

Turtle Trax S.A. is seeking an ETL Developer based in Mexico, Jalisco. The role involves designing and developing ETL workflows using tools like Ab Initio, Informatica PowerCenter, or IBM DataStage. Candidates should have expertise in SQL, data warehouses, and experience with Teradata and PySpark.

The ideal candidate will have at least 5 years in ETL/Data Engineering, and a Bachelor's degree in a relevant field. Strong collaboration skills are essential for working with business analysts and stakeholders to ensure efficient data processes.

Formación

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of experience in ETL/Data Engineering development.
• Strong analytical, problem-solving, and troubleshooting skills.

Responsabilidades

• Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage.
• Develop and optimize complex SQL queries and stored procedures.
• Build and maintain data integration processes for enterprise data warehouses.

Conocimientos

ETL tool experience

SQL development

Teradata databases

PySpark

Unix/Linux shell scripting

Data validation

Educación

Bachelor's degree in Computer Science or related field

Herramientas

Ab Initio

Informatica PowerCenter

IBM DataStage

Descripción del empleo

We are looking for an ETL developer in Mexico.

Key Responsibilities

• Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage.
• Develop and optimize complex SQL queries, stored procedures, and database objects.
• Build and maintain data integration processes for large-scale enterprise data warehouses.
• Work extensively with Teradata databases for data extraction, transformation, and loading activities.
• Develop and maintain PySpark applications for big data processing and data transformation.
• Analyze source-to-target mappings and implement data transformation logic.
• Perform data validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Troubleshoot ETL job failures, performance bottlenecks, and data issues.
• Collaborate with business analysts, data architects, and stakeholders to gather and understand requirements.
• Follow best practices for ETL development, coding standards, and documentation.
• Participate in code reviews, testing, deployment, and production support activities.
• Monitor ETL processes and ensure timely execution of data loads.

Technical Skills

• Strong experience with at least one ETL tool:
  • Ab Initio (Preferred)
  • Informatica PowerCenter
  • IBM DataStage
• Advanced SQL development and query optimization skills.
• Hands-on experience with Teradata databases.
• Strong knowledge of PySpark and distributed data processing concepts.
• Experience with data warehousing concepts, dimensional modeling, and ETL methodologies.
• Knowledge of Unix/Linux shell scripting.
• Experience with data validation, data quality, and reconciliation processes.
• Understanding of performance tuning and optimization techniques.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
• 5+ years of experience in ETL/Data Engineering development.
• Strong analytical, problem-solving, and troubleshooting skills.
• Excellent communication and collaboration abilities.