Data Engineer

RH: Lessly Mujica

Location: any state of Mexico

General Description:

We are seeking a highly experienced and technically strong Informatica Lead Developer with deep expertise in Informatica PowerCenter, Snowflake, IICS, Data warehousing, SQL/PL‑SQL and Unix. This role requires a mature engineering leader who can manage the complete delivery lifecycle to run an enterprise data management ecosystem, mentor junior developers, enforce engineering discipline, and drive stability and modernization across critical data platforms. The ideal candidate will bring 12 years of experience, including 5 years on US healthcare payer domain, with a strong understanding of legacy and modern data platforms, business rules, operational dependencies, and manage cross-functional stakeholder expectations.

Technical Expertise

ETL & Data Integration:

Informatica PowerCenter, Snowflake, IICS, Workflow Manager/Monitor, Real-Time & Batch Integration

Performance tuning and optimization of ETL pipelines

Data reconciliation and Root cause diagnostics & issue prevention framework

Expertise in data modelling, query optimization, partitioning strategies, and complex SQL development

Strong understanding of Data Warehousing concepts, including the design and implementation of Fact and Dimension tables within a Snowflake schema model.

Databases: Oracle, Snowflake, DB2, MySQL

Scripting: PL/SQL, Unix shell scripting, Job automation (Preferably Automic Scheduler)

Key Responsibilities

Own end-to-end Informatica development lifecycle across all Enterprise legacy domains, including design, development, testing, deployment, and hypercare.

Review, validate, and optimize ETL code ensuring adherence to enterprise coding standards and architectural guidelines.

Collaborate proactively with onshore architects, Data Analysts, and business SMEs to translate functional requirements into robust technical designs.

Create comprehensive technical specifications, mapping documents, and revision histories for new and enhanced workflows.

Primary technical escalation point for Priority 1 & Priority 2 production incidents across the Informatica ecosystem.

Implement proactive monitoring, job health checks, and automated alerting to reduce repeat incidents.

Ensure strict SLA governance and reduce defect leakage into UAT/Prod environments through improved validation and peer-check practices.

Provide ongoing technical mentoring, code reviews, and requirement clarification sessions for offshore developers.

Conduct structured handover meetings twice daily, ensuring risk visibility, requirement clarity, and resource alignment.

Drive compliance to security policies, audit requirements, and enterprise data governance standards.

Co-develop a 12-month modernization roadmap in collaboration with business and IT partners.

Evaluate modernization opportunities across Informatica migration paths, Snowflake optimization, and cloud integration strategies.

Act as a strategic advisor to clients for data transformation and long-term architecture evolution.

What can YOU expect in a career with Capgemini?

• Working in a team environment, Consultants will focus on the analysis, design and development of technology-based solutions for Capgemini’s clients.
• You will work alongside technical, functional and industry specialists to assist with the development, implementation and integration of innovative system solutions including methods, techniques and tools.
• You will contribute to client satisfaction by providing timely and responsive value-added services and work products.
• Capgemini offers a competitive compensation and benefits package.
• Headquartered in Paris, France, Capgemini has a presence of more than 340 thousand professionals in Mexico distributed among 3 sites located in Mexico City, Monterrey and Aguascalientes. A deeply multicultural organization.
• Capgemini has developed its own way of working, the Collaborative Business ExperienceTM, and draws on Rightshore, its worldwide delivery model.

You will love this job because

• Capgemini focuses on giving each new hire a YOU-nique experience through our recruitment process and on-boarding program, as well as by helping you to build your own career and professional skills foundation.
• Capgemini provides a collaborative environment that embodies and holds the following stated values close to heart: Honesty, Boldness, Trust, Freedom, Team Spirit, Modesty, and Fun.
• Capgemini cultivates an atmosphere for development that enables YOU to be hands-on, planning for your growth, both horizontally and vertically.

“At Capgemini Mexico, we aim to attract the best talent and are committed to creating a diverse and inclusive work environment, so there is no discrimination based on race, sex, sexual orientation, gender identity or expression, or any other characteristic of a person. All applications welcome and will be considered based on merit against the job and/or experience for the position”