Informatica SME: Cloud Data Migration Lead (Hybrid, SC)

Consult; Manchester, Newcastle upon Tyne, Lancashire; Hybrid; GBP 75,000 - 125,000; Full time

Job summary

Consult is seeking an experienced Informatica Subject Matter Expert (SME) to support a major data transformation and cloud migration programme. You will ensure ETL pipelines are re-engineered and migrated reliably into a cloud data warehouse, providing architecture guidance and engineering-level support.

This senior role requires hands-on Informatica expertise and the ability to lead technical decisions, design migration approaches, and mentor engineering teams. SC clearance is required.

Qualifications

• Extensive experience with Informatica PowerCenter and/or IICS.
• Proven ability to lead data migration projects.
• Strong knowledge of ETL and data integration best practices.
• Experience delivering migrations to cloud data platforms or data warehouses.
• Ability to define migration approaches and create solid design artifacts.

Responsibilities

• Provide deep Informatica SME guidance across PowerCenter and IICS.
• Advise on architecture, mappings and re-platforming approaches.
• Define ETL migration approach, source-to-target mapping and data validation.
• Support migration and re-engineering of data integration pipelines to cloud.
• Ensure data integrity during migration and dual-running activities.
• Produce High-Level Designs (HLDs) and Low-Level Designs (LLDs).
• Create and maintain technical documentation and knowledge articles.
• Provide technical guidance to Informatica engineers.
• Troubleshoot complex Informatica/data integration issues.
• Coordinate knowledge transfer across the programme.

Skills

Informatica PowerCenter

Informatica IICS

ETL

Data migration

Data mapping

Data validation

Cloud data warehouse

HLD/LLD docs

Technical leadership

Troubleshooting

Communication

Job description

Consult is seeking an experienced Informatica Subject Matter Expert (SME) to support a major data transformation and cloud migration programme. You will ensure ETL pipelines are re-engineered and migrated reliably into a cloud data warehouse, providing architecture guidance and engineering-level support.

This senior role requires hands-on Informatica expertise and the ability to lead technical decisions, design migration approaches, and mentor engineering teams. SC clearance is required.