Senior ETL/DWH Developer (Ab Initio / DataStage / Oracle)

Quick Facts

• Role: Senior ETL / DWH Developer

• Focus: Data warehouse maintenance and development, data exchange processes

• Tools: Ab Initio or IBM InfoSphere DataStage; Oracle 19c (SQL/PL/SQL)

Description

You will independently manage ETL/DWH changes from analysis through deployment for banking projects, including maintaining and developing data warehouse processes and data exchange.

The work includes building and tuning ETL jobs in Ab Initio or IBM InfoSphere DataStage, optimizing SQL and PL/SQL in Oracle 19c, and supervising daily data loads. You will also diagnose and fix ETL failures in production and test environments and implement new business data requirements while ensuring high data quality.

Responsibilities

• Lead changes end-to-end: from analysis to implementation

• Maintain, modify, and develop ETL processes in Ab Initio or IBM InfoSphere DataStage

• Write, optimize, and tune SQL queries and PL/SQL procedures in Oracle 19c

• Oversee daily data loads into the data warehouse

• Analyze logs, diagnose, and resolve ETL incidents in production and test environments

• Implement new business requirements in the data model and maintain high data quality

• Provide subject-matter support to less experienced team members

Requirements

• Minimum 4 years of experience as an ETL/DWH developer

• Practical knowledge of Ab Initio or IBM InfoSphere DataStage

• Very good knowledge of Oracle, SQL, and PL/SQL including query optimization

• Experience with monitoring production environments and resolving ETL process problems

• Banking or financial sector experience, including familiarity with banking data structures

• Willingness to be on-call during daytime (morning or afternoon) when required

Benefits

• Stable, long-term collaboration

• Ongoing team support at every stage of the project