Senior DataStage ETL Architect

Test Triangle; West of England; On-site; GBP 70,000 - 110,000; Full time

Job summary

Test Triangle in the West of England is seeking a Senior DataStage Developer to lead enterprise ETL initiatives. You will design, build, and manage complex DataStage pipelines and mentor junior developers, ensuring data quality and scalable workflows.

The ideal candidate has 8+ years of hands-on DataStage experience, strong SQL skills, and a solid grasp of modern data platforms. Proficiency with Oracle/DB2, and collaboration with data architects is highly valued.

Qualifications

• 8+ years of dedicated experience with IBM InfoSphere DataStage (v11.x preferred) including Designer, Director, Administrator, and QualityStage.
• Expert-level proficiency in SQL, PL/SQL, and working knowledge of relational database architectures (RDBMS).
• In-depth knowledge of Data Warehousing concepts, Star/Snowflake schemas, and Dimension/Fact loading methodologies.

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.

Skills

Analytical thinking

Mentoring juniors

Leadership

Tools

IBM InfoSphere DataStage

SQL

Unix/Linux shell scripting

Job description

Test Triangle in the West of England is seeking a Senior DataStage Developer to lead enterprise ETL initiatives. You will design, build, and manage complex DataStage pipelines and mentor junior developers, ensuring data quality and scalable workflows.

The ideal candidate has 8+ years of hands-on DataStage experience, strong SQL skills, and a solid grasp of modern data platforms. Proficiency with Oracle/DB2, and collaboration with data architects is highly valued.