Role Title: DataStage Developer
Location: Manchester
Duration: 31/12/2026
Work setup: 2 days onsite/week
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