Global Insurance Company modernizes their legacy Oracle / Informatica platform to Snowflake
A successful enterprise modernization that transformed Oracle and Informatica into a modern Snowflake ecosystem.
Next Pathway is an Elite Snowflake Partner, trusted by global enterprises to deliver end-to-end modernization, from deep discovery to production cutover.
Case study summary: Oracle Exadata and Informatica to Snowflake in 10 months
A leading multinational insurance provider modernized its Oracle Exadata and Informatica BDM environment to Snowflake in 10 months. Next Pathway re-architected more than 120,000 SQL objects and 20,000 ETL jobs into Snowflake, dbt and Apache Airflow, including 209 Informatica BDM mappings, 8,586 PL/SQL scripts converted to the Snowflake Task Framework and 5,355 PL/SQL scripts converted to dbt Cloud and Airflow. Next Pathway's NEXA Platform captured the logic and dependencies across Oracle and Informatica in its Enterprise Intelligence Graph, giving frontier models the context to automate translation across the estate.
Results: 1.3 PB of data and 800 billion records modernized onto Snowflake in 10 months; 8x faster data processing; near real-time streaming replacing micro-batch processing; ETL to ELT re-architecture unlocking Snowflake's parallel processing.
AI readiness: unified legacy data on a cloud-native platform built for advanced analytics, regulatory compliance and AI.
Download your free case study
Get the full story of how a global insurer modernized Oracle Exadata and Informatica to Snowflake in 10 months.
By providing information in this form, you agree to Next Pathway’s Privacy Policy
What Next Pathway's Global Insurance Provider Case Study Covers
A leading multinational insurance provider modernized Oracle Exadata and Informatica to Snowflake with Next Pathway's NEXA Platform, creating a scalable cloud-native data platform for faster analytics, regulatory compliance and AI.
Oracle Exadata and Informatica Modernization
The insurer modernized its Oracle Exadata and Informatica environment to the Snowflake AI Data Cloud in 10 months, re-architecting more than 120,000 SQL objects and 20,000 ETL jobs with automated translation.
Snowflake-Powered Cloud Data Platform
Next Pathway re-architected legacy ETL into a modern ELT architecture on Snowflake, dbt and Airflow, delivering 8x faster data processing and near real-time streaming in place of micro-batch processing.
AI-Ready Data Foundation
The cloud-native platform gives the insurer a scalable foundation for advanced analytics, regulatory compliance and AI, with unified data access for faster insights.
1 Billion+
Lines of legacy code translated
160+
Migrations and modernizations delivered
80%
Faster than manual and semi-automated approaches
Oracle Exadata and Informatica to Snowflake: frequently asked questions
Answers drawn from the global insurance provider case study.
How long did the Oracle Exadata and Informatica to Snowflake modernization take?
10 months. In that time 1.3 PB of data and 800 billion records were modernized onto Snowflake, and the insurer's legacy code and ETL were re-architected into Snowflake, dbt and Apache Airflow.
What legacy code and ETL was converted?
More than 120,000 SQL objects were converted to Snowflake-compatible SQL and more than 20,000 ETL jobs were converted to dbt and Airflow. That included 209 Informatica BDM mappings converted to dbt and Airflow, 8,586 PL/SQL scripts converted to the Snowflake Task Framework and 5,355 PL/SQL scripts converted to dbt Cloud and Airflow.
How did Next Pathway's NEXA Platform automate the translation?
Next Pathway's NEXA Platform captured the logic and dependencies across Oracle and Informatica in its Enterprise Intelligence Graph, giving frontier models the context to automate translation across the estate. Automated mapping and testing then confirmed data accuracy at scale.
What results did the insurer achieve?
Data processing became 8x faster, near real-time streaming replaced micro-batch processing, and automated translation removed manual recoding. The insurer now has unified data access that supports better customer outcomes, regulatory compliance and agile decision-making.
Why move from ETL to ELT on Snowflake?
Moving from ETL to an ELT architecture runs transformations inside Snowflake, which unlocks Snowflake's full parallel processing. Combined with pay-as-you-go cloud analytics, it gave the insurer a scalable, cloud-native foundation for advanced analytics, compliance and AI.
What Industry Analysts Say
Rob Enderle
ENDERLE GROUP
Eric Kavanagh
THE BLOOR GROUP
What a structured Snowflake modernization covers
A successful Snowflake modernization requires a clear plan across four disciplines.
Discovery and dependency mapping
Every code object, ETL pipeline and data dependency is identified and documented before modernization begins, so hidden complexity surfaces early and the program stays on schedule.
Code translation and modernization
Legacy SQL, stored procedures and ETL pipelines are converted into optimized, Snowflake-native workloads. Automated translation removes manual rework and covers the full estate.
Validation and functional parity
Every modernized workload is validated against the legacy source to confirm data accuracy and functional equivalence. Parity is proven before cutover.
Production cutover planning
Cutover needs a defined plan covering resources, rollback decisions and business sign-off. Teams that plan cutover from the start move faster and with greater confidence.
Latest Insights on Modernization
How to Capture Institutional Knowledge From Legacy Data Platforms for Modernization and AI
How to Turn a Legacy Data Estate Into a Trusted, Governed, AI-Ready Data Foundation
Cloud Migration Resources
DB2 & DataStage to Azure & Databricks
Modernizing healthcare data with Azure and Databricks for faster analytics and AI readiness.
Informatica Workflows to Snowflake
Hospitality Company Modernizes Informatica Workflows to Snowflake.
