Ziraat Bank,
Data Warehouse Migration Project

Ziraat Bank worked with GTech to migrate its data warehouse to Oracle Exadata, modernizing its ETL processes and closing a critical support gap left by its previous vendor.

The project:

• Migrating from the existing data warehouse system to Oracle Exadata.
• Running the performance testing needed to improve data transfer processes and complete them on the scheduled timeline.
• Improving ETL processes and their business dependencies.
• Making disk usage more efficient.
• Ensuring the monitorability of code developed as database packages.
• Migrating ETL transactions, previously available as database packages on the old data warehouse, to ODI 12c.

Achievements:

• The DWH migration project was completed smoothly and quickly with GTech Consulting Services.
• The system support gap caused by the old data warehouse vendor ending its services in Turkey was resolved.
• Efficiency increased as ETL transactions were completed on the scheduled timeline.
• Data transformation processes were brought into a central, manageable, and sustainable structure by monitoring data from a single platform with ODI.