Data Integration Engineer (Datastage)

RedCat Solutions; Greater London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading financial services organization based in London seeks a skilled Data Integration Engineer to develop and maintain ETL pipelines using IBM DataStage. The ideal candidate will possess strong SQL and data modelling skills, along with a background in banking and regulatory reporting. This 6-month contract role offers a rate of £700/day and involves close collaboration with stakeholders to ensure data quality and compliance.

Qualifications

• Extensive experience in IBM DataStage development.
• Proficient in SQL, PL/SQL with significant Oracle and SQL Server knowledge.
• Strong background in data modelling including data marts.

Responsibilities

• Develop and maintain ETL pipelines using DataStage.
• Build and optimize SQL-based data transformations.
• Design and support data models for regulatory and business reporting.
• Ensure data quality, governance, and compliance.
• Collaborate with technical and business stakeholders.

Skills

IBM DataStage development

SQL/PL/SQL

Oracle

SQL Server

data modelling

banking experience

regulatory reporting

analytical skills

Tools

DataStage

Databricks

Kafka

MQ

IIB

Job description

Data Integration Engineer (DataStage)

Location: London
Contract: 6 months initial
Rate: £700/day (Inside IR35, via umbrella)

A leading financial services organisation is looking for a Data Integration Engineer with strong, hands‑on IBM DataStage experience to support regulatory and reporting data platforms within a banking environment.

This is a delivery‑focused role requiring deep ETL, SQL, and data modelling expertise, with exposure to banking and regulatory reporting.

Key Skills & Experience Required

• Strong hands‑on IBM DataStage development experience (essential)
• Advanced SQL/PL/SQL
• Solid experience with Oracle and SQL Server
• Proven data modelling experience, including data marts
• Background in banking or financial services (corporate banking preferred)
• Experience supporting regulatory reporting data environments
• Strong analytical and problem-solving skills

Desirable

• ECB onboarding/AQR reporting exposure
• Experience with Databricks
• Exposure to Middleware technologies (Kafka, MQ, IIB)

The Role

• Develop and maintain ETL pipelines using DataStage
• Build and optimise SQL-based data transformations
• Design and support data models for regulatory and business reporting
• Ensure data quality, governance, and compliance
• Work closely with technical and business stakeholders

Additional Information

• Inside IR35
• £700/day via umbrella
• London-based role
• 6-month initial contract with potential extension