Senior Data Engineer (Informatica)

Senior Data Engineer (Informatica)

Posted 1 day ago by Sanderson Government and Defence

Apply
£530 Per day
Inside
Remote
London; City of London; East London; Central London; South East London; West London; Canary Wharf; South West London; North London; Greenwich; Stratford
Apply
Automation Control-M (Batch Scheduling Software) Data Analysis Data Governance Data Integration Data Quality Data Warehousing Dimensional Modeling Extract Transform Load (ETL) Informatica Job Scheduling (Batch Processing) Mapping Software Oracle Databases PL/SQL Root Cause Analysis SAS (Software) Scheduling Scripting Security Clearance SQL (Programming Language) Star Schema Unix Unix Shell Workflows

Summary: The Senior Data Engineer (Informatica) role involves leading the migration of legacy SAS-based ETL processes to Informatica PowerCentre, focusing on data integration within a complex enterprise environment. The position requires strong expertise in Informatica, Oracle, and UNIX shell scripting, with an emphasis on ensuring data quality and performance optimization. The role is primarily remote but may require occasional travel for meetings. Active SC clearance is essential for this position.

Key Responsibilities:

  • Design, develop, and maintain ETL pipelines using Informatica PowerCentre (preferably version 10.6)
  • Lead and support migration of SAS-based ETL workflows to Informatica within a Data Warehouse environment
  • Develop and optimise Oracle database objects (PL/SQL procedures, functions, queries)
  • Write and maintain UNIX shell scripts for automation, job scheduling, and data processing
  • Perform data analysis, mapping, and transformation for complex data sources
  • Ensure data quality, integrity, and performance optimisation across ETL processes
  • Collaborate with business and technical teams to translate requirements into scalable data solutions
  • Support testing, deployment, and production support activities
  • Troubleshoot ETL failures and provide root cause analysis and fixes
  • Contribute to documentation including technical design, data mappings, and process flows

Key Skills:

  • Strong hands-on experience with Informatica PowerCentre (v10.6 preferred)
  • Extensive experience working with Oracle databases (SQL & PL/SQL)
  • Proficiency in UNIX/Linux shell scripting
  • Proven experience working in Data Warehouse / ETL environments
  • Experience in data integration, transformation, and performance tuning
  • Strong understanding of ETL frameworks, data pipelines, and batch processing
  • Working knowledge of SAS (especially in ETL context)
  • Experience in migrating SAS workloads to Informatica ETLs
  • Familiarity with data modelling (dimensional modelling / star schema)
  • Exposure to scheduling tools (e.g., Control-M, Autosys)
  • Understanding of data governance and data quality frameworks

Salary (Rate): £530 per day

City: London

Country: United Kingdom

Working Arrangements: remote

IR35 Status: inside IR35

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Job Title: Senior Data Engineer (Informatica)

Max pay rate: £530 per day

Location: Remote

***Essential Clearance required: Active SC Cleared***

Location: London

Work type: this role is virtual, however there may be an infrequent ask to attend a meeting in Newcastle or Leeds.

Job Description:

Role Overview

We are seeking an experienced Senior Data Engineer with strong expertise in Informatica PowerCentre, Oracle, and UNIX shell scripting to support critical data warehouse and ETL migration initiatives.

The role will focus on migrating legacy SAS-based ETL processes to Informatica, ensuring efficient, scalable, and high-quality data integration within a complex enterprise data environment.

This aligns closely with internal requirements where Informatica PowerCentre (v10.6 preferred), Oracle, UNIX scripting, and SAS migration exposure are essential.

Must-Have Skills & Experience

Strong hands-on experience with Informatica PowerCentre (v10.6 preferred)

Extensive experience working with Oracle databases (SQL & PL/SQL)

Proficiency in UNIX/Linux shell scripting

Proven experience working in Data Warehouse / ETL environments

Experience in data integration, transformation, and performance tuning

Strong understanding of ETL frameworks, data pipelines, and batch processing

Desirable Skills

Working knowledge of SAS (especially in ETL context)

Experience in migrating SAS workloads to Informatica ETLs

Familiarity with data modelling (dimensional modelling / star schema)

Exposure to scheduling tools (e.g., Control-M, Autosys)

Understanding of data governance and data quality frameworks

Must have skills

Informatica PowerCentre (preferably version 10.6)

Oracle

UNIX shell scripting

SaS knowledge would be helpful as the work will involve migrating SaS to Informatica ETLs in the Data Warehouse space.

Reasonable Adjustments:

Respect and equality are core values to us. We are proud of the diverse and inclusive community we have built, and we welcome applications from people of all backgrounds and perspectives. Our success is driven by our people, united by the spirit of partnership to deliver the best resourcing solutions for our clients.

If you need any help or adjustments during the recruitment process for any reason, please let us know when you apply or talk to the recruiters directly so we can support you.

Apply
Similar Jobs
Loading data...