Senior Data Engineer (Informatica)

Great British Energy Group; Leeds; Hybrid; GBP 70,000 - 90,000; Full time

Job summary

DWP is seeking a Senior Data Engineer (Informatica) for a 12-month Inside IR35 contract, based in a hybrid arrangement across Birmingham, Blackpool, Leeds, Manchester, Newcastle or Sheffield. You will enhance legacy Informatica PowerCenter data integration, reduce technical debt and support cloud migration to keep business-critical data accessible and trusted.

The role focuses on building data pipelines with Informatica PowerCenter and SAS Enterprise Guide, enforcing data quality with consistent

Qualifications

• Experience with Informatica PowerCenter and SAS Enterprise Guide.
• Strong SQL and Oracle database knowledge; data warehousing concepts.
• Experience building ETL pipelines, data extraction, transformation, cleansing and loading.

Responsibilities

• Build and manage data pipelines using Informatica PowerCenter and SAS Enterprise Guide.
• Ensure data quality through validation, standardisation and business rules.
• Develop and maintain error handling, monitoring and logging within mappings and procedures.
• Use parameterisation to create flexible, reusable workflows.
• Follow development standards and best practices; thorough testing.
• Diagnose and fix issues by reading Informatica logs and understanding root causes.
• Monitor data loads with control tables and job-tracking.
• Develop Informatica transformations and expressions for accurate processing.
• Deploy solutions with version control and release processes.

Skills

Informatica PowerCenter

SQL

Oracle

ETL processes

Unix/Bash scripting

Data modeling

Data quality

Stakeholder communication

SC Clearance (eligible)

Tools

SAS Enterprise Guide

Job description

On behalf of DWP, we are looking for a Senior Data Engineer (Informatica) for a 12 month (Inside IR35) contract based Hybrid in Birmingham, Blackpool, Leeds, Manchester, Newcastle or Sheffield.Core PurposeWe are seeking an experienced Senior Data Engineer (Informatica) to support the enhancement and modernisation of DWP's data integration services. You will work within a legacy Informatica PowerCenter environment, helping to reduce technical debt, improve data quality, enhance existing data pipelines and support the ongoing migration of services to the cloud. You will help ensure business critical data remains accessible, performant and trusted by users across the organisation.As a Senior Data Engineer (Informatica) your main responsibilities will be to:* Build and manage data pipelines using Informatica PowerCenter and SAS Enterprise Guide, including extracting, combining, cleansing and loading data from multiple source systems into target environments.* Ensure data quality through validation, standardisation and the application of consistent business rules before data is released for use.* Develop and maintain error handling, monitoring and logging within mappings, scripts and procedures to support issue identification and resolution.* Use parameterisation techniques, including parameter files, to create flexible, reusable and maintainable workflows.* Follow development standards and best practices when building solutions.* Test thoroughly by creating and using test data to make sure mappings and processes work as expected.* Diagnose and fix issues by reading Informatica logs and understanding root causes.* Monitor data loads by building control tables and mechanisms to show whether jobs ran successfully.* Develop and maintain Informatica transformations and expressions to ensure data is processed accurately and efficiently.* Deploy solutions in line with agreed release processes, including version control, labelling and configuration management.Essential:* Strong Informatica PowerCenter experience.* Strong SQL and database knowledge, particularly Oracle and data warehouse structures (e.g. dimensional models, SCD types).* Experience building and managing ETL processes, including data extraction, transformation, cleansing and loading activities.* Scripting skills (Unix/Bash) to support data movement, cleansing and automation.* Strong problem solving and root cause analysis skills.* Ability to communicate technical issues clearly to both technical and non-technical stakeholders.* SC Clearance, or eligibility and willingness to obtain SC Clearance.Desirable:* Experience with SAS Enterprise Guide.* Experience supporting legacy and on premises data integration platforms.* Previous experience working within UK Government or other public sector organisations.PLEASE NOTE: SC Clearance is an essential requirement for this role, as a minimum you must be willing & eligible to undergo checks. Please note, due to the exceptional requirements of this position (short-term nature of this role and speed at which we require a postholder in situ) preference may be given to candidates who meet all of the essential criteria and hold active security clearance.Please be aware that this role can only be worked within the UK and not Overseas.Disability ConfidentAs a member of the Disability Confident Scheme, DWP guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.Armed Forces CovenantDWP guarantees to interviewveterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, wewill interview the best candidates from within that group. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.In applying for this role, you acknowledge the following \"this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different\".