Upvanta

Projektant Programista ds. Utrzymania Hurtowni Danych (Oracle, SQL, PL/SQL, Ab Initio)

Brak informacji o wynagrodzeniu

MidHybryda·WrocławFull-time·B2B

#458209·Dodano 27 dni temu·3

Źródło: justjoin.it

Aplikuj teraz

Tech Stack / Keywords

Oracle SQLData WarehouseETL

Podsumowanie oferty

The role involves maintaining and developing ETL processes using Ab Initio and IBM InfoSphere DataStage, administering and optimizing Oracle 19c databases with SQL and PL/SQL, and monitoring data warehouse production. The position requires incident management, debugging production and test environments, and implementing new business requirements to the data model. Work is done mainly remotely with stable working hours and monthly office visits.

Wymagania

Practical experience in banking domain data structures and business processes (mandatory).
Minimum 3 years of practical experience in Data Warehouse maintenance.
Strong knowledge and advanced skills in Oracle 19c, SQL, and PL/SQL optimization.
Practical experience working with Ab Initio (mandatory).
Experience in production monitoring, troubleshooting, and diagnosing ETL process performance issues.
Willingness to work in a shift system (morning/afternoon 8-hour shifts) and attend the Wrocław office at least once a month.
Analytical approach to problem-solving and ability to work with existing code.

Nice to have:

Experience with IBM InfoSphere DataStage.
Knowledge of version control systems - git.
Experience working in Agile/Scrum methodologies.

Obowiązki

Maintain and develop ETL processes using Ab Initio and IBM InfoSphere DataStage.
Administer and optimize Oracle 19c databases, including tuning SQL queries and PL/SQL stored procedures.
Monitor daily data warehouse feeds, analyze logs, and respond immediately to errors within standard 8/5 working hours.
Diagnose, debug, and resolve production and test environment incidents.
Implement new business requirements into the existing data model, ensuring data consistency and quality.

Inne informacje

Applicant data will be processed by Upvanta sp. z o.o. for recruitment purposes in compliance with relevant data protection laws. Personal data is processed based on mandatory legal obligations and consents. Candidates have rights to access, rectify, delete, restrict processing, object, data portability, and complaint filing. Providing mandatory data is required for recruitment process continuation. Consent to process additional data can be withdrawn any time.

Upvanta

191 aktywnych ofert

Zobacz wszystkie oferty

Aplikuj teraz