Senior DataStage Developer

Key Responsibilities

• Architecture \& Design: Analyze 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, utilizing 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 optimize long\-running ETL processes, memory allocations, partition strategies, and SQL queries.


• Database \& Data Modeling: Create data mappings, target schema structures, and validate complex data logic across databases like Oracle, Teradata, 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, Autosys, 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.

• 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).

Work Location: Hybrid remote in Bristol

This listing is from Indeed. View original listing ↗