loading

Business Impact

  • 30TB

    Of data migrated to Google Cloud

  • Faster access to real-time querying

  • Improved actionable insights

Customer Key Facts

  • Location : North America
  • Industry : Insurance

Problem Context

The customer, a leading 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

Technologies Used

Google's BigQuery
Cloud Data Fusion
Cloud Storage
Cloud Composer
Cloud Dataproc

Building 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
  • Improved actionable insights through flexible consumption of EDW data on Google Cloud

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk