Ab Initio ETL Architect — Scalable Data Flows

Lite Thinking company; Ciudad de México; On-site; MXN 600,000 - 900,000; Full time

Job summary

Lite Thinking company invites an experienced ETL Engineer to design, develop, implement, and optimize data integration using Ab Initio GDE in Mexico City. You will manage batch and real-time processes, work with large volumes of data, and translate functional and technical requirements into scalable ETL solutions aligned with business needs.

The ideal candidate has strong SQL skills, Unix/Linux knowledge, shell scripting, and hands-on experience with Oracle, Teradata, or SQL Server.

Qualifications

• ETL development using Ab Initio GDE.
• Translate functional and technical requirements into data integration solutions.
• Experience with batch and real-time processing.
• Knowledge of Unix/Linux and shell scripting.
• Advanced SQL skills with Oracle/Teradata/SQL Server.
• Data modeling experience.

Responsibilities

• Design and develop ETL processes using Ab Initio GDE.
• Build and maintain graphs, flows, and data integration components.
• Analyze requirements from business and IT.
• Translate needs into scalable technical solutions.
• Manage, schedule, and monitor batch and real-time jobs.
• Optimize ETL processes for performance and efficiency.
• Develop and maintain Unix/Linux shell scripts.
• Create and optimize SQL queries for databases.
• Work with large data volumes ensuring integrity.
• Document developments, tests, and procedures.
• Collaborate with business, data, infrastructure, and technology teams.

Skills

Analytical thinking

Problem solving

Requirements interpretation

Quality focus

Performance optimization

Attention to detail

Team collaboration

Effective communication

Organizational skills

Adaptability

Education

Bachelor's degree in Systems Engineering / Software Engineering / Computer Science / Data Science or related fields

Degree in related field

Tools

Ab Initio GDE

Unix/Linux

Shell scripting

SQL

Oracle

Teradata

SQL Server

ETL architecture

Data modeling

Job description

Lite Thinking company invites an experienced ETL Engineer to design, develop, implement, and optimize data integration using Ab Initio GDE in Mexico City. You will manage batch and real-time processes, work with large volumes of data, and translate functional and technical requirements into scalable ETL solutions aligned with business needs.

The ideal candidate has strong SQL skills, Unix/Linux knowledge, shell scripting, and hands-on experience with Oracle, Teradata, or SQL Server.