Mid-Level ETL/DWH Developer

Quick Facts

• Role: Mid-Level ETL/DWH Developer

• Focus: ETL and data warehouse maintenance/development for banking projects

• Tools: Ab Initio or IBM InfoSphere DataStage; Oracle (SQL/PLSQL)

Description

You will maintain and evolve data warehouse solutions and data exchange processes in a mature architecture for long-term bank projects in Poland. The role covers ETL pipeline development, Oracle SQL/PLSQL optimization, daily data load monitoring, and production/test incident troubleshooting. You will also implement new business requirements in the data model while ensuring high data quality.

Responsibilities

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

• Write and optimize SQL and PL/SQL queries for Oracle 19c

• Monitor daily data loads into the data warehouse

• Analyze logs, respond to errors, and diagnose/remediate incidents in production and test environments

• Implement new business requirements in the data model

• Ensure high quality of processed data

• Perform day shifts on-call (morning or afternoon), without nights and weekends

Requirements

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

• Practical knowledge of Ab Initio or IBM InfoSphere DataStage

• Very good knowledge of Oracle database, SQL, and PL/SQL with query optimization skills

• Experience monitoring production environments and troubleshooting ETL processes

• Experience in the banking/financial sector and knowledge of banking data structures

Benefits

• Stable project environment

• Ongoing support from the Ideamotive team throughout the collaboration