We are seeking a highly experienced and analytical Senior DataStage / ETL Developer with over 8 years of hands‑on expertise in designing, developing, and managing enterprise‑grade data integration pipelines. In this role, you will lead the implementation of complex ETL/ELT architectures, optimise high‑volume data warehouses, and mentor junior developers. The ideal candidate will have deep expertise in the IBM InfoSphere DataStage Suite , strong SQL capability, and a solid understanding of modern data platforms
Key Responsibilities
Architecture & Design: Analyse complex business requirements and translate them into scalable, end‑to‑end technical ETL designs and robust data workflows.
ETL Development: Design, develop, test, and deploy parallel and server jobs using IBM DataStage Designer, utilising advanced stages (Lookup, Join, Merge, Transformer, Aggregator, etc.).
Job Management & Sequences: Build and manage complex job sequences, execution loops, custom error‑handling mechanisms, and standard job routines.
Performance Tuning: Troubleshoot production bottlenecks and optimise long‑running ETL processes, memory allocations, partition strategies, and SQL queries.
Database & Data Modelling: Create data mappings, target schema structures, and validate complex data logic across databases like Oracle, Terradata, SQL Server, and DB2.
Automation & Orchestration: Write advanced Unix/Linux shell scripts for automated file handling, pre/post‑job processing, and parameter configuration.
Operations & Scheduling: Oversee enterprise job schedulers (such as Control‑M, Auto sys, or Tivoli) to manage dependencies and production runtime.
Collaboration & Leadership: Partner with Data Architects, Business Analysts, and QA teams to maintain data quality standards. Provide guidance and code reviews for junior team members.
Required Technical Skills & Qualifications
Core Tooling: 8+ years of dedicated experience with IBM InfoSphere DataStage (v11.x preferred) including Designer, Director, Administrator, and QualityStage.
Databases & Languages: Expert‑level proficiency in SQL, PL/SQL, and working knowledge of relational database architectures (RDBMS).
Data Warehousing: In‑depth knowledge of Data Warehousing concepts, Star/Snowflake schemas, and Dimension/Fact loading methodologies.
We use essential cookies to make this site work. With your permission we would also like to use the optional cookies below. Nothing optional is set until you choose, and you can change your mind at any time from "Cookie settings" at the bottom of every page. Cookie policy.
Essential — keep the site working and secure, and remember the choice you make here. Always on.