Senior Data Engineer (Informatica)

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

• 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 Confident

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

Public Sector Resourcing (PSR) is a government let framework, managed by AMS on behalf of Crown Commercial Services (CCS) for the provision of Contingent Labour across the UK. As one of the leading total workforce solutions organisations, at AMS we are no stranger to helping clients around the world, including 120+ blue-chip companies, create workforces that are fluid, resilient, diverse, and differentiated.

PSR is committed to connecting the right person with the right role, helping candidates find meaningful projects that align with their skills and career goals. Our PSR customers, ranging from central government to agencies and public bodies, have an incredible range of assignments and assignment durations with roles at all clearance levels and across all skill sectors to include Tech and Digital, Commercial and Procurement, Project Management, Engineering, Nuclear, Finance, HR and Marketing and Communications. Candidates could find themselves working on the most cutting-edge projects, with the latest technologies, and some of the largest programmes of work throughout the country.

The Public Sector Resourcing (PSR) framework is underpinned by our commitments to Social Value.

During our tenure working with the UK Government to deliver talent solutions, Social Value has become an increasingly important topic amongst our customers and across the UK. After a number of economic changes in recent years, of which our communities and society as a whole have felt the huge impact, the delivery of Social Value has never been more significant.

At PSR, we want to make sure we provide an inclusive and accessible experience for all of our candidates.

PSR - Talent Attraction

Candidate Wellbeing

At PSR, we want to make sure we provide an inclusive and accessible experience for all of our candidates. We have a selection of resources available to support you throughout the recruitment journey and once you’re in assignment with PSR., Your wellbeing is our priority. If you work with PSR, you’ll get access to leading wellbeing app Unmind, which provides you with preventative measures to encourage positive wellbeing., At PSR, we understand that mental health is just as important as physical health. That’s why we’ve launched the PSR Mental Health First Aider Programme.

We’ve trained a cohort of Mental Health First Aiders who are equipped with the skills to identify and address mental health challenges, ensuring that our employees and contractors have access to the help they need.

By prioritising mental well-being, we’re not only supporting our people and contractors but also ensuring we deliver the best service to our customers across the UK public sector.