Lead Data Engineer

Talent; Greater London; Hybrid; GBP 90,000 - 120,000; Full time

Job summary

Talent is seeking a senior Informatica Architect to lead complex migration projects. You will re-engineer ETL pipelines, design data mappings, and ensure secure data transfer to cloud warehouses. A blend of hands-on coding and technical leadership is needed to guide engineers and validate results.

Hybrid role with 1-day-a-month site presence in Manchester or Blackpool. The contract spans 12 months with potential extension based on delivery success.

Qualifications

• Expertise in Informatica PowerCenter and/or IICS across complex migration projects.
• Proven ability to design and optimize large-scale ETL pipelines.
• Experience with data validation, quality frameworks, and migration testing.

Responsibilities

• Advise on Informatica architecture, pipelines, and migration approaches.
• Define source-to-target mappings and ETL migration workflows.
• Produce HLD/LLD and knowledge-base articles for Informatica components.
• Ensure data integrity during migration and dual-running execution.
• Provide technical leadership and transfer knowledge to engineers.

Skills

Informatica Expertise

Data Integration

Data Migration & Quality

Leadership

Informatica PowerCenter

IICS (Intelligent Cloud Services)

Tools

Informatica PowerCenter

IICS

Job description

• Hybrid - 1 a month in Manchester or Blackpool
• 12 month contract very likely to extend

Role Purpose

Provides deep Informatica expertise to ensure existing ETL/data-integration pipelines are correctly re-engineered and data is migrated reliably and securely into the target cloud data warehouse across delivery phases.

Key Responsibilities

• Architecture & Strategy: Advise on Informatica architecture, pipeline mappings, and overall re-platforming/migration approaches.
• ETL & Migration Design: Define source-to-target mapping, ETL migration workflows, and rigorous data validation methods.
• Technical Documentation: Lead and support High-Level Design (HLD), Low-Level Design (LLD), and knowledge-base articles for all Informatica components.
• Assurance & Dual-Running: Assure pipeline integrity throughout the migration lifecycle and dual-running execution.
• Technical Leadership: Mentoring, upskilling, and technical guidance for core Informatica engineers.

Key Skills & Experience

• Informatica Expertise: Comprehensive subject-matter expertise in Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
• Data Integration: Proven track record in complex ETL design, data integration pipelines, and source-to-target mapping definitions.
• Data Migration & Quality: Extensive experience in enterprise-scale cloud data migrations, dual-run testing, and validation frameworks.
• Leadership: Ability to drive decisions, manage technical risk, and perform structured knowledge transfer to internal teams.