ETL Developer

RED Global; Manchester; Hybrid; GBP 60,000 - 75,000; Full time

Benefits offered by this job

Hybrid work model

On-site 2–3 days/week

Job summary

RED Global is looking for an experienced DataStage Engineer in Manchester to design, develop, enhance and support enterprise ETL and data integration solutions in a regulated banking environment. You will deliver reliable, scalable data pipelines using IBM DataStage and collaborate with BI, architecture, DBAs and infrastructure teams.

The role is hybrid with 2–3 days on-site, until 31/12/2026. You will lead ETL design reviews, contribute to technical decisions, and mentor juniors while ensuring

Qualifications

• Strong hands-on commercial experience with IBM DataStage and DataStage 11.x.
• Proficient in designing and building end-to-end ETL pipelines.
• Experience with UNIX / Shell scripting and relational databases.

Responsibilities

• Design, develop, enhance, and maintain ETL jobs and sequences using IBM DataStage.
• Develop end-to-end data pipelines from source systems into data warehouses and downstream platforms.
• Build and maintain robust, reusable, and scalable DataStage components.
• Produce ETL design documents, source-to-target mappings, and technical documentation.
• Perform data profiling, validation, and reconciliation to maintain high data quality.
• Optimise DataStage jobs for performance, scalability, and reliability.
• Troubleshoot ETL failures, data issues, and production incidents.

Skills

IBM DataStage

DataStage 11.x

UNIX / Shell scripting

ETL design

Data Warehousing

Oracle

Teradata

DB2

Lookups

Change Capture

Sequential Files

Shared containers

Reusable DataStage components

Tools

Oracle

Teradata

DB2

Job description

We are seeking an experienced IBM DataStage Engineer to design, develop, enhance, and support enterprise ETL and data integration solutions within a regulated banking environment. You will be responsible for delivering reliable, scalable, and high-quality data pipelines using IBM DataStage, working closely with Business Analysts, Data Architects, DBAs, infrastructure teams, and downstream data consumers.

Contract Information

• Job title: DataStage Engineer
• Location: Manchester
• Work model: Hybrid – 2/3 days on-site
• Contract length: Until 31/12/2026
• Contract type: Inside IR35

Key Responsibilities

• Design, develop, enhance, and maintain ETL jobs and sequences using IBM DataStage.
• Develop end-to-end data pipelines from source systems into data warehouses and downstream platforms.
• Build and maintain robust, reusable, and scalable DataStage components.
• Produce ETL design documents, source-to-target mappings, and technical documentation.
• Perform data profiling, validation, and reconciliation to maintain high levels of data quality.
• Optimise DataStage jobs for performance, scalability, and reliability.
• Troubleshoot and resolve ETL failures, data issues, and production incidents.
• Support critical batch processes and production data flows.
• Work closely with DBAs, UNIX teams, schedulers, application teams, and wider data teams.
• Support deployments and controlled releases across development, test, and production environments.
• Lead ETL design reviews and contribute to technical and architectural decisions.
• Mentor junior developers where required.
• Ensure solutions adhere to banking controls, SDLC standards, and change management processes.
• Strong hands-on commercial experience with IBM DataStage, ideally DataStage 11.x.
• Strong understanding of ETL and Data Warehousing principles.
• Experience with UNIX / Shell scripting.
• Strong understanding of relational databases and data modelling.
• Experience working with:

• Lookups
• Change Capture
• Sequential Files
• Data Sets
• Column Generator
• Job parameterisation
• Shared containers
• Reusable DataStage components

• Experience connecting DataStage to databases such as Oracle, Teradata and/or DB2.
• Strong ETL troubleshooting and performance-tuning experience.
• Experience working within enterprise-scale data environments.