ETL Developer

Infinity Quest

Shirley, UK

3 days ago

Apply on www.adzuna.co.uk

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Compensation

£28,000.0 - £49,000.0

Working hours

Regular working hours

Job source

www.adzuna.co.uk

Tech stack

CA Workload Automation Ae Unix Code Review Databases Data Infrastructure Data Integration Extract Transform Load (ETL) Data Warehousing IBM DB2 Relational Databases IBM InfoSphere DataStage Linux

+12 more

Tivoli Management Framework Job Scheduling Microsoft SQL Server Oracle (Applications) Standard Sql Shell Script PL-SQL SQL Databases Teradata SQL Snowflake Star Schema Control M

Job description

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, 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.

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