Informatica SME

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.