Data Warehouse Developer

Quick Facts

• Role: Data Warehouse Developer

• Focus: Maintenance and development of enterprise data warehouse and ETL pipelines for a banking project

• Environment: Oracle 19c, Ab Initio, IBM InfoSphere DataStage, SQL/PLSQL

Description

You will support and evolve a banking-sector data warehouse solution, including ETL processes and Oracle 19c databases in an enterprise environment. The work includes monitoring production data-loading jobs, diagnosing errors, resolving incidents and performance issues, and implementing business-driven changes. You will also ensure data consistency, quality, and performance while working with existing code.

Responsibilities

• Maintain and develop ETL processes using Ab Initio and IBM InfoSphere DataStage

• Work with Oracle 19c databases; optimize SQL queries and PL/SQL procedures

• Monitor production data warehouse loading processes and analyze logs

• Diagnose and resolve incidents and performance issues

• Implement changes based on business requirements

• Maintain data consistency, quality, and performance

• Work with existing enterprise code and systems

Requirements

• Minimum 3 years of experience in data warehouse maintenance

• Strong knowledge of Ab Initio

• Very strong SQL, PL/SQL, and Oracle 19c skills

• Experience in the banking sector and understanding of banking data and business processes

• Ability to monitor ETL processes, diagnose errors, and troubleshoot in production

• Ability to analyze and optimize SQL queries and PL/SQL procedures

• Ability to independently solve problems and work with existing enterprise code

Benefits

• Cooperation based on a B2B contract