PGK Data Platform
DWH + Data Lake + Delta Lake — 8+ consumer products, Oracle TCO $19.8M → $0, vendor selection across 6 tool classes
CTO / Technical Director
2 года · 8 чел
- SAP BW
- Oracle
- Vertica
- Hadoop/Cloudera
- Apache Kafka
- AirFlow
Архитектура платформы данных: источники → Kafka/NiFi/Airflow → LDW → потребители
Expand the deep-dive ↓
What doesn't work
Company data fragmented across 5+ stores: SAP BW, Oracle IBD, Vertica, Cognos TM1, dozens of product databases. Product teams spent weeks searching for data. Oracle DBs deployed on unlicensed hypervisors — audit penalty $19.8M (833 unlicensed CPU cores). No unified business glossary or data catalog.
Architectural approach
Corporate data platform in 4 stages: DWH → Data Lake → Delta Lake → Data Gateway. Vendor selection across 6 tool classes (DWH, ETL, Data Catalog, Business Glossary, MDM, Data Quality). Unified data catalog with business glossary. MDM/RDM for master data. Migration from Oracle to license-compliant stack.
CTO / Technical Director
Initiated and led the Oracle migration. Personally conducted vendor selection across 6 tool classes (DWH, ETL, Data Catalog, Business Glossary, MDM, Data Quality). Designed the 4-stage migration architecture. Identified the $19.8M licensing risk (833 unlicensed CPU cores) and developed the remediation plan.