Informatica SME

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

Location: Manchester, Newcastle or Blackpool

Working Pattern: Hybrid, 3 days per week onsite

Contract: Contract

Candidate Rate: Up to £675 per day

Hours: 40 hours per week, Monday to Friday

Security Clearance: SC required

Role Overview

We are looking for an experienced Informatica Subject Matter Expert (SME) to support a major data transformation and cloud migration programme. The successful candidate will provide deep Informatica expertise, ensuring ETL and data integration pipelines are successfully re-en­engineered and data is migrated reliably into a cloud data warehouse. This is a senior technical position requiring strong hands-on Informatica knowledge alongside the ability to advise on architecture, define migration approaches and provide technical guidance to engineering teams.

Key Responsibilities

• Provide deep subject matter expertise across Informatica PowerCenter and IICS.
• Advise on Informatica architecture, mappings and re-platforming approaches.
• Define the approach for ETL migration, source-to-target mapping and data validation.
• Support the migration and re-en­engineering of existing data integration pipelines into a cloud data environment.
• Ensure pipeline and data integrity throughout migration and dual-running activities.
• Support the production of High-Level Designs (HLDs) and Low-Level Designs (LLDs) for Informatica components.
• Produce and maintain technical documentation and knowledge articles.
• Provide technical guidance and support to Informatica engineers.
• Troubleshoot complex Informatica and data integration issues.
• Support effective knowledge transfer across the programme.

Essential Skills & Experience

• Strong subject matter expertise in Informatica PowerCenter and/or IICS.
• Extensive experience with ETL and data integration.
• Proven experience delivering complex data migration projects.
• Strong knowledge of source-to-target mapping.
• Experience with data validation and reconciliation.
• Experience migrating or re-platforming legacy ETL/data integration solutions.
• Experience supporting migrations into cloud data platforms or data warehouses.
• Experience contributing to HLD and LLD documentation.
• Ability to provide technical leadership and guidance to Informatica engineers.
• Strong troubleshooting and problem-solving skills.
• Excellent communication and knowledge-transfer capabilities.

Desirable Experience

• Experience migrating legacy Informatica environments to modern cloud platforms.
• Experience with large-scale data transformation programmes.
• Previous government or public-sector experience.
• Experience working across Discovery, Alpha and Beta delivery phases.
• Experience operating within secure or highly regulated environments.

Location & Working Arrangements

This is a hybrid position requiring 3 days per week onsite at one of the following locations:

• Manchester
• Newcastle
• Blackpool

Remote working is available for the remainder of the week.

The standard working pattern is 8 hours per day, Monday to Friday.

Security Clearance

SC (Security Check) Clearance Is Required.