Description Our client is one of the United States' largest insurers, providing a wide range of insurance and financial services products with gross written premiums well over US$25 Billion (P&C;). Finally, our client is part of one the largest Insurance Groups in the world. We are looking for a skilled Data Engineer to design, build, and maintain data pipelines that support analytics and business intelligence initiatives.

This role involves both enhancing existing pipelines and developing new ones to integrate data from diverse internal and external sources. The ideal candidate will have advanced SQL and Informatica skills, experience in ETL development, and a foundational understanding of dimensional data modeling. data pipelines and ETL workflows to ensure reliable data integration across platforms. existing data pipelines by adding new attributes, improving performance, or increasing maintainability. new data ingestion pipelines Informatica to develop and manage ETL processes in alignment with business requirements. SQL queries for data transformation, validation, and extraction. dimensional data modeling to support reporting and data warehousing needs.

Collaborate with data analysts, data scientists, and business teams to understand data needs and deliver clean, structured datasets.



code reviews, documentation, and testing to ensure quality and accuracy in data delivery. Work in agile or project-based environments to deliver on sprint goals and project timelines. Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience). data engineering or ETL development using (MUST) Previous experience using Informatica (Cloud Software) (MUST) SQL: Advanced-level proficiency in writing, optimizing, and troubleshooting queries.

ETL Tools: Intermediate experience building and managing pipelines using ETL platforms. At least 3 years using Informatica: experience with PowerCenter or Informatica Cloud for data integration tasks.

Dimensional Data Modeling: Basic understanding of star and snowflake schema designs. DBT (Data Build Tool) Exposure to cloud data platforms (AWS, GCP, Azure). Competitive salary and performance-based bonuses Comprehensive benefits package Career development and training opportunities Adaptable work arrangements (remote and/or office-based) Dynamic and inclusive work culture within a globally reknowned group Private Health Insurance Pension Plan Paid Time Off Training & Development

📌 FBS Data Engineer-ETL (Informatica) (Cuautitlán Izcalli)
🏢 Capgemini
📍 Cuautitlán Izcalli