At a Glance
- Tasks: Design and develop ETL pipelines, migrating SAS workflows to Informatica.
- Company: Global recruitment specialist with a focus on innovative data solutions.
- Benefits: Remote work flexibility, competitive salary, and opportunities for professional growth.
- Other info: Exciting role with potential for career advancement in a supportive environment.
- Why this job: Join a dynamic team and make an impact in data integration and transformation.
- Qualifications: Experience with Informatica, Oracle, and UNIX Shell Scripting required.
The predicted salary is between 60000 - 80000 £ per year.
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 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
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
- 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
If you are interested in this position and would like to learn more, please send through your CV and we will get in touch with you as soon as possible. Please note, candidates are often short‑listed within 48 hours.
Senior Data Engineer (Informatica) employer: eTeam
As a Global Recruitment specialist, we pride ourselves on fostering a collaborative and innovative work culture in Manchester, where our Service Designers can thrive. With a focus on employee growth, we offer opportunities for professional development and the chance to work on impactful projects across diverse regions. Our commitment to work-life balance, with a flexible onsite schedule, ensures that our team members can excel both personally and professionally.
