Hybrid Informatica ETL Engineer

Capgemini; Glasgow; Hybrid; GBP 50,000 - 75,000; Full time

Job summary

Capgemini is seeking an Informatica ETL Developer in the United Kingdom to design, develop, test and maintain ETL processes using Informatica PowerCenter and IICS. The role involves integrating data from multiple sources, transforming data to meet business requirements, and loading into data warehouses or data lakes.

Hybrid work is expected across offices, client sites and home, with no 100% remote option. You will design and support ETL workflows, analyze mappings, extract data from diverse

Qualifications

• Experience designing, developing, testing and maintaining ETL workflows, mappings and components.
• Strong data integration skills across source-to-target mappings and data pipelines.

Responsibilities

• Design, develop and support ETL workflows, mappings, sessions and reusable components.
• Analyze source-to-target mappings and implement data integration solutions.
• Extract data from databases, APIs, flat files and cloud applications.
• Transform, cleanse, validate and enrich data.
• Optimize ETL performance and troubleshoot failures.
• Develop and maintain SQL queries, stored procedures and objects.
• Collaborate with analysts, architects and stakeholders to gather requirements.

Skills

ETL development

Python

Data quality

Data warehousing concepts

Release management

Leadership / problem solving

Tools

Informatica PowerCenter

IICS

Job description

Capgemini is seeking an Informatica ETL Developer in the United Kingdom to design, develop, test and maintain ETL processes using Informatica PowerCenter and IICS. The role involves integrating data from multiple sources, transforming data to meet business requirements, and loading into data warehouses or data lakes.

Hybrid work is expected across offices, client sites and home, with no 100% remote option. You will design and support ETL workflows, analyze mappings, extract data from diverse