Informatica PowerCenter Data Engineer (SC Cleared)

THE WORK

This is a SAS to Informatica migration inside an enterprise data warehouse.

You will be analysing existing SAS jobs, redesigning the ETL logic where it needs it, and rebuilding it properly in Informatica without losing data integrity or business outcomes along the way.

Alongside that, building and supporting enterprise-grade ETL workflows, and developing Oracle solutions — SQL, stored procedures and data models built to perform at scale.

ESSENTIAL

• Informatica PowerCenter, hands-on this year.
• Version 10.6 preferred
• Oracle — SQL, stored procedures, data modelling
• UNIX shell scripting
• SC clearance
• Current experience is the firm requirement.
• The client sifts on hands-on PowerCenter use during 2026 — 10.6 is preferred but not decisive.
• SAS experience is not essential but it helps considerably, since the migration work runs through the whole engagement.

ADVANTAGEOUS

• AWS and Spark — Amazon EMR, S3, Lambda.
• Strong PySpark, Python and SQL for large-scale batch processing
• Data engineering at scale in government or similarly complex domains, including performance tuning and data quality management
• CI/CD and DevOps — pipelines and IaC such as Terraform, automated testing, release governance
• Version control and collaboration — Git and GitLab, code review, branching strategies, trunk and PR workflows
• APIs and integration — building and consuming data services to move and expose data safely
• Agile working with Jira and Confluence, clear stakeholder communication and concise technical documentation
• Data warehousing and modelling — Redshift, dimensional modelling, dbt
• Basic Power BI familiarity, to partner with BI developers and validate end-to-end data flows
• AWS ecosystem depth — Athena, Redshift, EC2, CloudWatch, IAM — and event-driven patterns

CERTIFICATIONS

• The client has listed AWS Certified Cloud Practitioner (or higher) and Azure AI Fundamentals as mandatory.

THE DETAILS

• Rate: £500 per day, inside IR35
• Location: 95% home working. Approximately 5% on site at the Leeds Digital Hub
• Contract: Initial 6 months
• Start: Immediate
• Clearance: Active SC is required