Data Warehouse Designer & Developer

Quick Facts

• Role: Data Warehouse Designer & Developer

• Work model: Remote (1 in-person visit per month to the client office in Wrocław)

Description

You will maintain and develop a data warehouse and ETL processes based on Ab Initio, Oracle 19c, and IBM InfoSphere DataStage. The goals are stable daily data loads, optimized ETL performance, and consistent, high-quality data. You will also monitor production/test environments, troubleshoot issues, and implement new business data requirements.

Responsibilities

• Maintain and develop data loading processes in Ab Initio and IBM InfoSphere DataStage

• Optimize SQL queries, PL/SQL procedures, and Oracle 19c table structures

• Monitor daily warehouse loads, analyze logs, and respond to errors

• Diagnose and fix incidents in production and test environments

• Implement new business requirements into the existing data model

• Ensure data consistency, quality, and availability

Requirements

• Minimum 3 years of experience supporting data warehouse systems

• Practical banking sector experience and knowledge of banking data structures and business processes

• Practical Ab Initio experience (required)

• Very good knowledge of Oracle 19c

• Advanced SQL and PL/SQL, including query and stored procedure optimization

• Experience monitoring production environments, analyzing logs, and diagnosing ETL performance problems

• Ability to independently analyze issues and modify existing code

• Willingness to deliver services in morning and afternoon hours

Benefits

• Support for professional and personal development, including career path planning

• Training, certifications, and conferences (co-financed or fully covered)

• Opportunity to change projects based on preferences (SmartChange)

• Work-life balance initiatives (integration events, sports activities, tech webinars)

• Health package: private care, sports card, insurance, and psychological support