SC Cleared Senior Data Engineer (Informatica)

fortice
Charing Cross, United Kingdom
3 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
£ 140K

Job location

Remote
Charing Cross, United Kingdom

Tech stack

Data analysis
CA Workload Automation Ae
Batch Processing
Unix
Databases
Data Governance
Data Integration
ETL
Data Warehousing
Job Scheduling
Shell
Oracle
Oracle Applications
Performance Tuning
SAS (Software)
Shell Script
PL-SQL
Data Processing
Star Schema
Data Pipelines
Control M

Job description

Work type: this role is virtual, however there may be an infrequent ask to attend a meeting in Newcastle or Leeds., 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., * 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

Requirements

  • 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 (eg, 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

Apply for this position