Informatica PowerCenter to IICS Migration for a Leading US Tribal Casino

About Client

As part of an Informatica PowerCenter to IICS migration, the client—a well-known tribal casino in Connecticut, USA—operates across 364,000 square feet (33,800 square meters) of gaming space. The property features two luxury hotel towers with 1,600 rooms, a world-class spa, a 125,000-square-foot Earth Expo Centre, a championship golf course, and more than 80 shops, restaurants, and bars. It also hosts three award-winning entertainment venues.

Background

As enterprises move toward cloud-first architectures, Informatica migration from PowerCenter (PC) to Informatica Intelligent Cloud Services (IICS) has become essential. IICS offers a cloud-native integration platform (iPaaS) where software, hardware, and network management are fully handled by the cloud provider. Additionally, Informatica has recently stopped support and service for PowerCenter, making PC to IICS migration a critical requirement for long-term scalability and compliance.

Challenge

  • Informatica officially ended support for on-premise PowerCenter servers.
  • 150 workflows consisting of 3,000+ objects needed to be migrated to IICS.
  • Despite initial automated migration using Informatica’s tool, nearly 90% of the migrated objects were not ready to run due to feature gaps between PowerCenter and IICS.

Objective

  • 150 workflows for 3000+ objects were migrated from Informatica on-premise to cloud using a migration tool provided by informatica
  • 90% of the objects were not ready to run because of the difference in feature of IICS and PwC


Our Solution

1. Detailed Workflow Assessment

Each workflow was examined individually to identify and fix feature incompatibilities, object-level errors, and transformation issues caused during the automated migration.

2. Functional Testing & Validation

  • Executed workflows and performed step-by-step functional testing.
  • Validated data against source systems including application databases and third-party data sources.
  • Conducted full User Acceptance Testing (UAT) for every table in all associated workflows.

3. Addressing the Lack of Development Data

The development environment had no data, which made testing ETL objects difficult. To overcome this:

  • Testing was shifted to the production IICS environment, where ETL objects were migrated post-integration testing.
  • Only the source was changed to production, while the target remained in development.
  • This allowed production data to flow into development targets for accurate testing without impacting production targets.
  • PowerCenter jobs continued to run in production during this phase, enabling data comparison between development targets and production outputs for data quality analysis.

4. Controlled Cutover Strategy

Once a workflow passed all validation steps in IICS:

  • The corresponding PowerCenter workflow was disabled from its schedule.
  • The IICS workflow was scheduled to replace it, ensuring a seamless transition without service disruption.

Outcome

20 Weeks

The full Informatica on-premise to cloud migration (PC to IICS migration) was completed in just 20 weeks, significantly improving the client’s digital footprint and modernizing their data integration ecosystem.

02 Weeks

An additional 2 weeks of post-migration support ensured stable operations, issue resolution, and smooth adoption for business teams.

BizAcuity
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.