Data Engineer

Talent International

Nottingham, UK

4 days ago

Apply on www.totaljobs.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Working hours

Regular working hours

Job source

www.totaljobs.com

Tech stack

Agile Methodology Amazon Web Services Amazon S3 Confluence JIRA Automation of Tests Batch Processing Big Data Continuous Integration Data Integration Data Integrity Extract Transform Load (ETL)

+19 more

Data Warehousing DevOps Dimensional Modeling Python (Programming Language) Unix Shell Oracle Databases Power BI SAS (Software) SQL Stored Procedures SQL Databases Freeform SQL Enterprise Software Applications Informatica Powercenter Gitlab Git Pyspark Infrastructure Automation Frameworks Terraform Data Pipelines

Job description

We are seeking an experienced Senior Data Engineer for a 6-month contract to drive critical data warehouse modernization for a major UK government department. You will lead the migration of legacy SAS processes to Informatica PowerCenter, optimize Oracle database solutions, and ensure high-performance, robust data integration across enterprise systems., * Informatica ETL Engineering: Design, build, enhance, and maintain enterprise-grade ETL solutions and workflows using Informatica PowerCenter within a data warehouse environment.

Legacy SAS Migration: Analyze existing legacy SAS jobs, redesign ETL logic, and deliver robust Informatica-based solutions while ensuring strict data integrity and uninterrupted business outcomes.
Oracle Database Optimization: Create and fine-tune complex SQL queries, stored procedures, and data models to maximize performance, scalability, and data quality standards.

Requirements

Informatica PowerCenter: Deep hands-on experience in building enterprise ETL solutions (v10.6 preferred).
Oracle Database Expertise: Strong proficiency in SQL, stored procedures, and data warehousing techniques.
UNIX Shell Scripting: Hands-on experience writing and maintaining scripts for operational automation.
SAS Knowledge: Practical understanding of SAS script logic to effectively analyze and migrate legacy processes., * AWS and Big Data: Hands-on experience with AWS (S3, EMR, Lambda, Redshift, Athena) and PySpark/Python for large-scale batch processing.
CI/CD and DevOps: Experience with Git/GitLab workflows, automated testing, and Infrastructure as Code (e.g., Terraform).
Data Modeling and BI: Exposure to dimensional modeling, dbt, and basic familiarity with Power BI for validating end-to-end data pipelines.
Public Sector Context: Prior experience delivering scalable data engineering solutions in complex government or highly regulated environments using Agile (Jira/Confluence) methodologies.