Datastage Developer - Manchester And Remote - 4 Months+

Octopus Computer Associates; Manchester; Hybrid; GBP 70,000 - 86,000; Full time

Job summary

Octopus Computer Associates is seeking a DataStage Developer for Manchester and remote work. You will design, develop and support ETL solutions using IBM DataStage in a regulated banking environment.

You will work with analysts, data architects, and downstream consumers to deliver reliable, scalable data integration. Must be eligible for BPSS and be PAYE via umbrella; on-site 2–3 days as part of the role.

Qualifications

• Hands-on DataStage development experience (11.x preferred).
• Strong ETL/Data Warehousing concepts.
• Proficient UNIX/Shell scripting.
• SQL/PL/SQL proficiency.
• Strong data modeling and relational DB knowledge.

Responsibilities

• Design, develop, and maintain DataStage ETL jobs and sequences.
• Build end-to-end data pipelines from sources to data warehouse.
• Create ETL design docs, mappings, and technical specs.
• Perform data profiling, validation, and reconciliation.

Skills

IBM DataStage

ETL/Data Warehousing

UNIX/Shell Scripting

SQL/PL/SQL

Data Modeling

Tools

Oracle

Teradata

DB2

TWS/IWS

Job description

DataStage Developer - Manchester and remote - 4 months+/RATE: £300 per day inside IR35

One of our Blue Chip Clients is urgently looking for a DataStage Developer.

Please find some details below:

CONTRACTOR MUST BE ELIGIBLE FOR BPSS

Days on site: 2-3

MUST BE PAYE THROUGH UMBRELLA

Role Description:

Role Overview

As a DataStage Developer, you will be responsible for designing, developing, enhancing, and supporting ETL solutions using IBM DataStage. You will work closely with business analysts, data architects, and downstream consumers to deliver reliable, scalable, and high-quality data integration solutions in a regulated banking environment.

Key Responsibilities

• Design, develop, and maintain ETL jobs and sequences using IBM DataStage
• Develop end-to-end data pipelines from source systems to data warehouse/downstream platforms
• Create and maintain ETL design documents, mapping specifications, and technical documentation
• Perform data profiling, validation, and reconciliation to ensure data quality
• Optimize DataStage jobs for performance, scalability, and reliability
• Troubleshoot and resolve ETL failures, data issues, and production incidents
• Work closely with DBAs, Unix teams, schedulers (TWS/IWS), and application teams
• Support batch schedules, deployments, and controlled releases across environments
• Adhere to banking controls, SDLC, and change management processes

Mandatory Skills

• IBM DataStage (11.x preferred) - strong hands‑on development experience
• ETL/Data Warehousing concepts
• UNIX/Shell Scripting
• SQL/PL/SQL
• Strong understanding of data models and relational databases

DataStage Technical Expertise

Hands-on experience with:

• DataStage Parallel Jobs
• Lookups, Change Capture, Transformer
• Sequential File, Data Sets
• Column Generator
• Database connectors (eg, Oracle/Teradata/DB2)
• Job parameterization, shared containers, and reusable components

Good to Have

• Banking or Financial Services domain experience
• Experience with production support and on‑call rotations
• Exposure to TWS/IWS scheduling
• Experience with DataStage upgrades or migrations (eg, 8.x 11.x)
• Knowledge of data reconciliation and audit controls

Soft Skills

• Strong analytical and problem-solving skills
• Ability to work independently in a delivery environment
• Good communication skills for stakeholder and offshore/onshore collaboration
• Documentation and attention to detail (bank-grade)

UK - Senior DataStage Developer:

• Lead ETL design and review
• Mentor junior developers
• Own complex data domains and critical batch flows
• Support architectural decisions and performance tuning