DWH Developer & Data Analyst & Data Engineer

Kandidát je skúsený vývojár a konzultant DWH/ETL s viac ako 20-ročnou praxou. V súčasnosti pracuje pre amerického klienta v oblasti zdravotníctva. Majú aplikáciu, ktorá dokáže sledovať zdravotný stav klienta pomocou databáz. Podľa neho nie je veľmi zaťažená. Vyvíja ETL pomocou Oracle a Python Pandas. Hovorí plynule anglicky, keďže žil v Spojených arabských emirátoch. Pracoval tam na rôznych vládnych projektoch.

Upozorňuje na peripetie: 1 mesiac.

05/2022 - ETL developer: Responsible for defining project scope, targets, metrics, and timeframe for an external client in the US healthcare insurance industry. Designed ETL procedures using Python Pandas and PySpark to extract data from Oracle database for analytics purposes.

03/2019 - 08/2021 - Data analytics team lead: Supported a major application and database upgrade for a governmental project in the UAE. Created a proof of concept for data ingestion from RDBMS database to Hive tables, including initial load and delta loads.

11/2018 - 03/2019 - Senior Oracle consultant: Worked on a credit scoring engine project for a major Croatian bank. Assessed current architecture and proposed new approaches. Utilized Oracle DB and PL/SQL for the project.

01/2016 - 10/2017 - Data architect: Worked on information system architecture, gathering sources information, writing documentation, and designing new data models. Designed data flow, wrote requirements, and developed data generator and anonymization app for big data testing system.

12/2011 - 12/2015 - ETL/Data Warehouse developer and on-site consultant: Developed ETL processes for UAE Government project, handling large databases with millions of new records daily. Conducted SQL and PL/SQL tuning and managed data patches. Ensured compliance with different departments.

3/2011 - 12/2011 - Oracle Database developer: Managed remote production databases and designed solutions for automated database maintenance and data archival. Used Oracle db 11.2, Toad, EM, SQL, PL/SQL, rman, .NET, shell, and Jira.

2/2010 - 2/2011 - Oracle consultant: Led a core banking database migration project for Erste bank group members. Mentored developers and ensured compliance with reporting and security requirements.