Intact Canada

The Challenges

Intact Canada sought to modernize its data infrastructure by moving from an on-premises SQL Server environment to a cloud-native Snowflake warehouse. At the same time, they needed to upgrade their legacy ETL platform (Informatica PowerCenter) to Informatica Intelligent Cloud Services (IICS) to unlock scalable, cloud-integrated data processing.

The stakes were high: the new system needed to support high data volume, improved processing speed, stronger security, and future readiness, with minimal disruption to business intelligence workflows.

Business Impact

  • 45% reduction in ETL runtime post-migration.
  • 2.5× faster data loads in Snowflake compared to SQL Server.
  • Zero business downtime during phased migration.
  • 40% cost savings on infrastructure and maintenance within 6 months.
  • 100% compliance with data security standards across all migrated pipelines.

Our Solution

We executed a full-stack modernization initiative, combining cloud-native storage, advanced ETL refactoring, and enterprise-grade security to future-proof Intact’s data ecosystem.

Cloud Migration

 Migrated over 35 TB of critical structured data from SQL Server to Snowflake,optimizing for columnar storage, query caching, and multi-cluster concurrency.

ETL Modernization

Re-engineered 200+ ETL workflows from PowerCenter to IICS, reducing processing time by 45% through performance tuning and cloud resource optimization.

Security by Design

 Implemented field-level encryption, role-based access controls, and data masking,ensuring compliance with Canadian data privacy laws and ISO 27001 standards.

Performance Optimization

Achieved 2.5× faster data loading and enabled near-real-time analytics by leveraging Snowflake’s virtual warehouse scaling and IICS’s elastic scheduling.

Scalability for Growth

Designed the system to scale horizontally for seasonal spikes in data volume without sacrificing latency or user access.

Client Feedback

  • List Item #1
  • List Item #1
  • List Item #1
  • List Item #1
  • List Item #1

“Yotta Data’s cloud migration and ETL refactoring helped us unlock real-time analytics and serious cost efficiency. Their team treated our data like their own, secure, accurate, and always aligned with business goals.”

Director, Enterprise Data Systems, Intact Canada

Technologies Used

Snowflake
Informatica IICS
SQL Server
AWS S3 + Lambda
Python + SnowSQL scripting