DWH Developer & Data Analyst & Data Engineer

Kandidát je zkušený vývojář a konzultant DWH/ETL s více než 20 lety zkušeností. V současné době pracuje pro amerického klienta v oblasti zdravotnictví. Mají aplikaci, která dokáže sledovat zdravotní stav klienta pomocí databází. Podle něj není příliš zatížená. Vyvíjí ETL pomocí Oracle a Python Pandas. Hovoří plynně anglicky, protože žil ve Spojených arabských emirátech. Pracoval tam na různých vládních projektech.

Všimněte si peripetií: Výpovědní lhůta: 1 měsíc

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.