Overview

Engagement Overview

AMP Capital began modernizing its data ecosystem to better support a digital-first investment environment. With data distributed across structured and unstructured repositories, the organization sought a secure and scalable cloud data warehouse that could consolidate information, simplify operations, and support faster access to insights.

As part of this initiative, a Snowflake-based data platform was introduced to bring together data from multiple sources while embedding governance and automation into core workflows. Ongoing application support and quality engineering were aligned with this modernization program to help ensure stability, performance, and continuous improvement.

Our Client

BFSI Australia
AMP Capital operates across real estate, infrastructure, equities, and fixed-income investments. The firm manages capital on behalf of institutional and retail investors worldwide, with a strong focus on long-term value creation through active asset management. Its portfolio spans multiple geographies and sectors, supporting diverse investment strategies and risk profiles.
Idanim

Business Objective

With global operations and a diversified asset portfolio, the organization defined a roadmap to modernize its legacy data environment and strengthen its ability to use data for investment and operational decision-making.
The data modernization program focused on strengthening AMP Capital’s data foundation and operational efficiency. 

01

Modernize legacy data management systems and transition to a cloud-based infrastructure

02

Consolidate data distributed across Oracle, DB2, and unstructured repositories into a unified platform

03

Support both real-time and batch data ingestion for improved availability and usability

04

Embed security, governance, and compliance controls for sensitive investment data

05

Reduce infrastructure management costs while achieving scalable, on-demand elasticity

Business solution

A Snowflake-based data warehouse was introduced as part of the broader cloud modernization effort.

  • Real-time ingestion was enabled using Snowpipe and Qlik
  • Data transformations were implemented using DBT within Snowflake to support SQL-driven processing
  • Governance controls included role-based access management and dynamic data masking
  • Security and compliance were supported through encryption and AWS PrivateLink
  • Disaster recovery was addressed using Snowflake’s native backup and recovery features
  • Infrastructure provisioning and schema management were automated using Terraform and Liquibase

Business impact

The modernized data platform supported improvements in performance, cost efficiency, and operational visibility.

20% improvement in system performance with separated compute and storage layers

30% faster decision-making with real-time dashboards and business reporting

40% reduction in infrastructure management costs after moving away from on-prem systems

50% reduction in storage costs through elastic, usage-based capacity management

100% uptime ensured through proactive 24x7 monitoring and support