Data Migration From Informatica On-Premise to Informatica Cloud

About Client

A popular tribal casino from Connecticut, US with 364,000 square feet (33,800 square meters) of gambling space. It is home to 2 luxury hotel towers totalling 1,600 rooms, a world-class spa, the 125,000 square-foot Earth Expo Centre, a championship golf course, more than 80 shops, restaurants, and bars as well as three award-winning entertainment venues.


  • Informatica Intelligent Cloud Services (IICS) offer their integration platform as a service (iPaaS), a hybrid integration platform, to integrate and provide data and application services which can be deployed only on the cloud.
  • Since the cloud provider takes care of the software, hardware and networks in the cloud, there is a need to migrate our workload from Informatica PowerCenter (PwC) on-premise to Informatica Intelligent Cloud Services (IICS). Moreover, Informatica has stopped its support/service for PwC recently.


  • Support for Informatica On-premise server has been stopped by Informatica


  • 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

  • We checked each workflow to resolve the issue/ errors in each object
  • Run the workflow and do the functionality testing
  • Validate the data against sources (Application DB, third party sources etc.
  • User Acceptance Testing (UAT) of all the tables part of above work flows
  • The development source had no data at all, making it hard to test the ETL objects
  • For this we came up with a solution of testing the objects on Production Informatica Intelligent Cloud Services.
  • The ETL objects once developed, integrated and integration testing completed were migrated to prod Informatica Intelligent Cloud Services(IICS) with only source changed to production.
  • The target though was still set to development. By doing this, the production source data was now being written to the development target.
  • As PowerCenter(PwC) was still being run for reading production data and writing to prod target, we tested the data on development target against production target to complete the data Quality Analysis.
  • Once a workflow was signed off on Informatica Intelligent Cloud Services after the testing, the PowerCenter workflow was disabled on schedule and Informatica Intelligent Cloud Services was added to the schedule to replace it


20 Weeks
Data migration from Informatica on Premise (PwC) to Cloud (IICS) for all the properties was completed in just 20 weeks which enhanced the digital footprint
02 Weeks
Additional support was extended for 2 weeks

Recent Case Studies

Get in Touch