Data Warehouse Maintenance Developer

We are part of Hiberus, a technology company founded in Spain with a strong presence in the Polish market: 4,700+ specialists, operating in 14+ countries and delivering projects for clients worldwide. We work with technologies including AI, Data, Cloud, Software Development, BI, and Cybersecurity. When one project ends, we seek new opportunities within Hiberus, including projects in other countries. Hiberus University provides an international learning environment with real opportunities to develop skills; more than 1,000 people were trained last year.

• Minimum 3 years of hands-on experience in maintaining data warehouse systems or data repositories.
• Practical domain knowledge of data structures and business processes in the banking sector (mandatory).
• Very good knowledge of Oracle 19c and advanced SQL and PL/SQL scripting.
• Hands-on experience with Ab Initio (mandatory).
• Experience in production monitoring, troubleshooting, and diagnosing ETL performance issues.
• Willingness to work rotating 8-hour shifts (morning or afternoon).
• Strong analytical skills and ability to work with existing code.
• Availability to work from the Wrocław office at an agreed frequency.

Nice to have:

• Knowledge or commercial experience with IBM InfoSphere DataStage.
• Familiarity with Git version control.
• Experience working in Agile methodologies such as Scrum.

• Maintaining and developing ETL processes to ensure stability and implement modifications using Ab Initio and IBM InfoSphere DataStage.
• Administering and optimizing Oracle 19c databases, including tuning SQL queries, PL/SQL procedures, and table structures.
• Monitoring daily data warehouse loads, analyzing logs, and responding to errors.
• Diagnosing, debugging, and resolving production and test environment incidents.
• Implementing new business requirements within the existing data model while ensuring data consistency and quality.