Himalayas logo
CS

FBS Data Engineer-ETL (Informatica)

Capgemini SE is a French multinational information technology (IT) services and consulting company. It provides consulting, technology, outsourcing, and local professional services, helping companies transform and manage their business through technology.

Capgemini Technology Services

Employee count: 5000+

Mexico only

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 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. Experience with DBT is a plus.

Requirements

Key Responsibilities:

  • Design, develop, and maintain data pipelines and ETL workflows to ensure reliable data integration across platforms.
  • Enhance and optimize existing data pipelines by adding new attributes, improving performance, or increasing maintainability.
  • Build new data ingestion pipelines from a variety of structured and semi-structured sources.
  • Use Informatica to develop and manage ETL processes in alignment with business requirements.
  • Write and optimize complex SQL queries for data transformation, validation, and extraction.
  • Apply basic knowledge of 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.
  • Participate in 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.

Required Skills & Qualifications:

  • Bachelor's degree in Computer Science, Information Systems, or related field (or equivalent experience).
  • 2–4 years of hands-on experience in 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.
  • Informatica: Advanced experience with PowerCenter 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 with DBT (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:

  1. Competitive salary and performance-based bonuses
  2. Comprehensive benefits package
  3. Career development and training opportunities
  4. Flexible work arrangements (remote and/or office-based)
  5. Dynamic and inclusive work culture within a globally reknowned group
  6. Private Health Insurance
  7. Pension Plan
  8. Paid Time Off
  9. Training & Development

About the job

Apply before

Posted on

Job type

Full Time

Experience level

Entry-level

Location requirements

Hiring timezones

Mexico +/- 0 hours

About Capgemini Technology Services

Learn more about Capgemini Technology Services and their company culture.

View company profile

Through groundbreaking technology, we are revolutionizing the digital and sustainable transformation at Capgemini. As a global leader in partnering with companies to transform and manage their business, we harness the power of technology to unleash human energy for an inclusive and sustainable future. Our innovation ecosystem combines cutting-edge technology, a dynamic network of B2B start-ups, and proven methodologies and services designed to deliver tangible value. By leveraging these comprehensive resources, we empower businesses to reinvent themselves for the long term, unlocking the full potential of technology to forge a better future. We guide organizations to accelerate their dual transition towards a digital and sustainable world, creating tangible impact for both enterprises and society. With a strong heritage of over 55 years and deep industry-specific expertise, Capgemini is a trusted partner for clients worldwide, addressing the entire breadth of their business needs from strategy and design to operations. Our end-to-end services and solutions are fueled by market-leading capabilities in AI, cloud, and data, combined with an extensive partner ecosystem.

At Capgemini, we understand that innovation is not a separate endeavor but a core element of sustainable business. We collaborate closely with clients and partners, utilizing the latest technological advancements and forward-thinking strategies. To stay at the forefront, we actively explore the potential of Generative AI, assess the viability of metaverse and quantum computing solutions for industry-specific innovations, and engage with pioneering start-ups. Our approach incorporates rigorous frameworks that accelerate innovation, alongside high-intensity research and development (R&D) to validate the value of both incremental and disruptive technologies. We assist businesses in anticipating future trends, evaluating their potential impact, and responsibly capitalizing on them. Through Capgemini Ventures, we co-create and deliver value with startups, clients, and technology partners by making minority investments and building joint go-to-market strategies. This fosters new innovations, ideas, and solutions, helping our clients navigate new paths forward. We also partner with technology and industry leaders on new joint ventures and companies to creatively provide cutting-edge approaches that solve today’s most significant challenges and serve evolving customer needs. Our commitment extends to looking at our significant presence in India, with over 100,000 employees, as a source of innovation and IP generation, not just a cost-effective delivery center.

CS

Capgemini Technology Services

Company size

5000+ employees

Founded in

1967

Chief executive officer

Aiman Ezzat

Employees live in

View company profile

Similar remote jobs

Here are other jobs you might want to apply for.

View all remote jobs

140 remote jobs at Capgemini Technology Services

Explore the variety of open remote roles at Capgemini Technology Services, offering flexible work options across multiple disciplines and skill levels.

View all jobs at Capgemini Technology Services

Remote companies like Capgemini Technology Services

Find your next opportunity by exploring profiles of companies that are similar to Capgemini Technology Services. Compare culture, benefits, and job openings on Himalayas.

View all companies

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
Capgemini Technology Services hiring FBS Data Engineer-ETL (Informatica) • Remote (Work from Home) | Himalayas