Data Warehouse ETL Developer (Oracle/Ab Initio/DataStage)

Quick Facts

• Role: Data Warehouse ETL Developer (Oracle/Ab Initio/DataStage)

• Focus: ETL maintenance and development, Oracle optimization, monitoring, and production incident handling

Description

You will maintain and develop ETL processes to keep the data warehouse stable. Work centers on Oracle 19c, Ab Initio and IBM InfoSphere DataStage, plus monitoring of the production environment. You will also implement changes to the data model.

Responsibilities

• Maintain and modify ETL processes

• Optimize the Oracle database and SQL/PL/SQL queries

• Monitor data loads to the data warehouse

• Diagnose and resolve incidents in production and test environments

• Implement changes in the data model

Requirements

• Practical domain knowledge of data structures and business processes in the banking sector (required)

• Very good knowledge of Oracle Database (version 19c)

• Advanced ability to write and optimize SQL queries and PL/SQL scripts

• Availability for an on-call schedule (8-hour morning/afternoon shifts)

• Willingness to work from the Wrocław office at least once per month