DataStage Developer

Role Title: DataStage Engineer

Location: Manchester/2-3 days a week onsite

Duration: 31/12/2026

Role Description:

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