ETL Developer

Salary: £28,000 - 49,000 per year

Requirements:

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

Responsibilities:

• Analyze complex business requirements and translate them into scalable, end-to-end technical ETL designs and robust data workflows
• Design, develop, test, and deploy parallel and server jobs using IBM DataStage Designer, utilizing advanced stages such as Lookup, Join, Merge, Transformer, and Aggregator
• Build and manage complex job sequences, execution loops, custom error-handling mechanisms, and standard job routines
• Troubleshoot production bottlenecks and optimize long-running ETL processes, memory allocations, partition strategies, and SQL queries
• Create data mappings, target schema structures, and validate complex data logic across databases such as Oracle, Teradata, SQL Server, and DB2
• Write advanced Unix/Linux shell scripts for automated file handling, pre/post-job processing, and parameter configuration
• Oversee enterprise job schedulers such as Control-M, Autosys, or Tivoli to manage dependencies and production runtime
• Partner with Data Architects, Business Analysts, and QA teams to maintain data quality standards
• Provide guidance and code reviews for junior team members

Technologies:

• ETL
• IBM
• Linux
• Oracle
• SQL
• Snowflake
• Unix

More:

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, we lead the implementation of complex ETL/ELT architectures, optimize 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.

last updated 38 week of 2026