We are looking for a ETL dev in Guadalajara, 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.
Skills Required
- Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
- 5+ years of experience in ETL/Data Engineering development
- Strong experience with at least one ETL tool (Informatica PowerCenter or IBM DataStage)
- Experience with Ab Initio
- Advanced SQL development and query optimization, including stored procedures
- Hands-on experience with Teradata databases
- Strong knowledge and hands-on experience with PySpark for big data processing
- Knowledge of data warehousing concepts, dimensional modeling, and ETL methodologies
- Experience with Unix/Linux shell scripting
- Experience with data validation, data quality, reconciliation, and performance tuning
- Strong analytical, problem-solving, communication, and collaboration skills
What We Do
VALCE Talent Solutions is a recruitment agency and consulting firm specializing in IT talent acquisition and nearshoring, primarily in Mexico. They design customized solutions in IT talent and process optimization to help businesses scale intelligently and profitably. Their expertise focuses on specialized industries including Information Technology, Operations Management, and Supply Chain, providing end-to-end talent offerings to attract and retain top professional profiles.
