ETL Lead

Description

Job Summary: We are seeking a Senior Data Engineer – ETL Lead to lead process elicitation, impact analysis, and ETL solution design for Teradata and Oracle, working under Agile methodologies. Key Highlights: 1. Leads ETL processes and data modeling 2. Strong experience with Teradata and Oracle 3. Works under Agile frameworks (Scrum/Kanban) IDS Comercial is a 100% Mexican IT company with 40 years of experience and presence in Mexico, Latin America, and the USA. Over 1,500 consultants work across numerous projects in financial, commercial, manufacturing, telecommunications, services, government, and other sectors. We are accredited at CMMI Level 5 (Capability Maturity Model Integration), the quality model established by the Software Engineering Institute (SEI). Certified by ISO under standard ISO/IEC 27001:2013. We hold the Socially Responsible Enterprise (ESR) distinction. · WE’RE LOOKING FOR YOU!! · Senior Data Engineer – ETL Lead · Technical skill with at least 3 years of experience: Technical Discovery: Conduct process elicitation and data flow mapping in core systems (CIL, GIW, JK). Impact Analysis: Identify information consumers and critical dependencies for operations. Deep Data Dive: Analyze Teradata structures (1,000+ tables) to filter exclusively client data assets. Stakeholder Engagement: Lead technical sessions with teams to extract knowledge and document business rules. Solution Design: Propose equivalent architecture for ETL and data modeling processes without resorting to application cloning. Sizing: Estimate timelines, resources, and costs for implementation/deployment phase. ETL & Data Integration Databases: Strong experience with Teradata (analysis of complex models) and Oracle. Data Ecosystem: Proficiency with Informatica, Kafka, and file-based integration flows. Architecture: Knowledge of data warehouse design and enterprise data integration layers. Methodologies: Experience working under Agile frameworks (Scrum/Kanban) and mastery of SDLC (Systems Development Life Cycle). Certifications (Desirable): Certifications in ETL tools (Talend/Ab Initio) or Data Management certifications (CDMP) or Teradata Vantage. Governance: Knowledge of data governance frameworks. · Hybrid Work Mode: Los Alpes, Álvaro Obregón, CDMX · We Offer: Statutory Benefits Enhanced Benefits Beyond Statutory Requirements 100% Payroll Processing · We are an inclusive company, free from any form of discrimination, where opportunities are available to those who demonstrate attitude and talent. We do not require medical certificates confirming non-pregnancy or Human Immunodeficiency Virus (HIV) status as prerequisites for joining our large workforce family or accessing equal growth opportunities.-Requirements- Minimum Education: Higher Education – Bachelor’s Degree 5 years of experience Keywords: leader, head, manager, director, chief, lead, leadership, supervisor