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;).
They proudly serve more than 10 million U. S. households with more than 19 million individual policies across all 50 states through the efforts of over 48,000 exclusive and independent agents and nearly 18,500 employees.
Finally, our client is part of one the largest Insurance Groups in the world.
Job Summary:We are looking for a skilledData Engineerto 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.
Experience with DBT is a plus.RequirementsKey Responsibilities:Design, develop, and maintaindata pipelines and ETL workflowsto ensure reliable data integration across platforms.
Enhance and optimizeexisting data pipelinesby adding new attributes, improving performance, or increasing maintainability.
Buildnew data ingestion pipelinesfrom a variety of structured and semi-structured sources.
UseInformaticato develop and manage ETL processes in alignment with business requirements.
Write and optimize complexSQL queriesfor data transformation, validation, and extraction.
Apply basic knowledge ofdimensional data modelingto support reporting and data warehousing needs.
Collaborate with data analysts, data scientists,



and business teams to understand data needs and deliver clean, structured datasets.
Participate incode reviews, documentation, and testingto ensure quality and accuracy in data delivery.
Work in agile or project-based environments to deliver on sprint goals and project timelines.Required Skills & Qualifications:Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
2–4 years of hands-on experience indata 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:Advancedexperience with Power Center or Informatica Cloud for data integration tasks.
Dimensional Data Modeling:Basic understanding of star and snowflake schema designs.
Excellent problem-solving and communication skills with an ability to collaborate across teams.
"Nice to Have"
Skills:Experience withDBT (Data Build Tool)for modular and scalable transformation logic.
Exposure to cloud data platforms (AWS, GCP, Azure).
Benefits
This position comes with competitive compensation and benefits package:
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) (Nuevo León)
🏢 Capgemini
📍 Nuevo León