loading
Menu
Let's Talk
  • 30TB

    Of data migrated to Google Cloud

  • Enabled faster access to real-time querying

  • Improved actionable insights through flexible consumption of EDW data on Google Cloud

Customer Key Facts

  • Size : 6,000+ employees
  • Location : Chicago, Illinois
  • Industry : Insurance

Problem Context

The client, a P&C insurer company, had an on-prem data warehouse hosted on Oracle Exadata which had evolved into a complex and voluminous system to own and maintain; making it difficult to connect and visualize datasets natively from the existing enterprise data warehouse (EDW). The client wanted to facilitate flexible consumption of their EDW data on Google Cloud Platform (GCP).

Challenges

 

  • Automation of Data Fusion pipelines
  • Implementing CICD for Data Fusion
Google BigQuery
Cloud Data Fusion
Cloud Storage
Cloud Composer
Cloud Dataproc

Built A Processing Pipeline To Ingest, Process And Load Raw Data From Claims System Onto GCP

Solution

Quantiphi migrated 150 terabytes of Claims, Premiums, Policies and Financial transactions data from Oracle Exadata to Google’s BigQuery and built a financial transaction model, a production-ready claim center data warehouse on Google Cloud, and an enterprise-grade DLP solution to manage its RED data.

Quantiphi also created a scalable data architecture and data processing pipelines that will ingest, process and load the raw data from the Claims system onto GCP.

Result

  • Cloud enablement
  • Scalable architecture on Google Cloud Platform
  • Enabled data warehouse for analytics and machine learning

Looking for similar project?

Let's Talk

Let’s get your Data + AI transformation started!

Let's Talk