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.
#J-18808-Ljbffr
Informatica SME employer: Consult
At Consult, we pride ourselves on being an exceptional employer that fosters a dynamic and inclusive work culture. Our North America team is dedicated to professional growth, offering robust training and development opportunities while working in a fast-paced, innovative environment. Join us to be part of a collaborative team that values your contributions and supports your career aspirations in the exciting MedTech sector.
