At a Glance
- Tasks: Design and develop ETL pipelines, migrating SAS workflows to Informatica.
- Company: Join a leading tech firm focused on data innovation.
- Benefits: Remote work flexibility, competitive pay, and career advancement opportunities.
- Other info: Opportunity for growth in a dynamic and supportive environment.
- Why this job: Make an impact in data engineering while working with cutting-edge technologies.
- Qualifications: Experience with Informatica, Oracle, and UNIX Shell Scripting required.
The predicted salary is between 60000 - 80000 £ per year.
Clearance required: 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.
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 ...
