About this role
About the Role ETL Developer in Mexico to design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage, and to optimize data integration for enterprise data warehouses. You will work with Teradata, PySpark, and data quality processes to ensure accurate data delivery for stakeholders. What You'll Do
- Design, develop, test, and deploy ETL workflows using Ab Initio, Informatica PowerCenter, or IBM DataStage
- Develop and optimize SQL queries, stored procedures, and database objects
- Build and maintain data integration processes for large-scale enterprise data warehouses
- Work extensively with Teradata for data extraction, transformation, and loading
- Develop and maintain PySpark applications for big data processing
- Analyze source-to-target mappings and implement data transformation logic
- Perform data validation, reconciliation, and quality checks
- Troubleshoot ETL failures, performance bottlenecks, and data issues
- Collaborate with business analysts, data architects, and stakeholders
- Follow ETL development best practices, coding standards, and documentation
- Participate in code reviews, testing, deployment, and production support
- Monitor ETL processes and ensure timely data loads What We're Looking For
- Bachelor's degree in Computer Science, Information Technology, Engineering, or related field
- 5+ years of experience in ETL/Data Engineering development
- Strong analytical, problem-solving, and troubleshooting skills
- Excellent communication and collaboration abilities
- Strong experience with at least one ETL tool: Ab Initio (Preferred), Informatica PowerCenter, IBM DataStage
- 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 Nice to Have
- Ab Initio experience (Preferred)
- Teradata expertise
- PySpark proficiency and distributed processing concepts