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-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-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.