ETL/DWH Mid-Level Developer (Ab Initio, DataStage, Oracle)

Quick Facts

• Role: Mid-level ETL/DWH Developer
• Key technologies: Ab Initio or IBM InfoSphere DataStage, Oracle (SQL/PLSQL)
• Industry: Banking
• On-call: Day shifts only (no nights, no weekends)

Description

You will work on maintaining and developing enterprise data warehouses and data exchange processes for banking clients, with long-term, stable collaboration. The role focuses on building ETL processes in Ab Initio or IBM InfoSphere DataStage, writing and optimizing Oracle SQL/PLSQL, and ensuring reliable daily data loads. You will also analyze logs, troubleshoot issues in production and test, and implement new business requirements in the data model while ensuring data quality.

Responsibilities

• Maintain, modify, and build ETL processes in Ab Initio or IBM InfoSphere DataStage
• Create and optimize SQL and PL/SQL code in Oracle 19c
• Oversee daily data warehouse loads
• Analyze logs, respond to errors, and resolve issues in production and test environments
• Implement new business requirements in the data model and ensure data quality
• Participate in day-shift on-call as required (morning or afternoon; no nights and no weekends)

Requirements

• Minimum 2 years of experience as an ETL/DWH developer
• Practical experience with Ab Initio or DataStage
• Very good knowledge of Oracle database, SQL, and PL/SQL with query optimization
• Experience monitoring production environments and troubleshooting ETL processes
• Banking/financial domain experience, including knowledge of industry-specific data structures

Benefits

• Long-term cooperation with stable systems for major banks in Poland
• Full project support throughout the engagement