DataStage Developer

DataStage Developer

Posted 4 days ago by eTeam

Negotiable
Undetermined
Undetermined
Manchester Area, United Kingdom

Summary: The DataStage Developer role involves designing, developing, enhancing, and supporting ETL solutions using IBM DataStage within a regulated banking environment. The position requires collaboration with business analysts and data architects to ensure high-quality data integration solutions. The developer will also be responsible for optimizing performance and troubleshooting ETL issues. This role is based in Manchester and requires a strong technical background in ETL and data warehousing concepts.

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

Key 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
  • Banking or Financial Services domain experience (good to have)
  • Experience with production support and on-call rotations (good to have)
  • Exposure to TWS/IWS scheduling (good to have)
  • Experience with DataStage upgrades or migrations (eg, 8.x - 11.x) (good to have)
  • Knowledge of data reconciliation and audit controls (good to have)
  • 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)

Salary (Rate): undetermined

City: Manchester

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Other

Detailed Description From Employer:

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