ETL Platform Refresh

Client is a global leader in motion and control technologies. The firm has a broad array of products and services that include aerospace, climate control, electromechanical, filtration, fluid and gas handling, hydraulics, pneumatics, process control, and sealing and shielding.
Business Need
  • Client had to expedite ETL platform upgrade since software OEM was terminating product support. Specifically, we were asked to upgrade the Informatica from version 9.6.1 to 10.1.1.
  • Upgrade had to be done in an emergency mode ensuring minimal disruption to existing business operations.
Our Solution
  • Upgraded the Informatica PowerCenter to 10.1.1 from 9.6.1.
  • Upgraded the repository from 9.6.1 to 10.1.1.
  • Configure security for users and user groups. Created the users and groups and added the users to respective groups.
  • Automated backups for repository and domain. Automated job failure alerts and server down alerts.
  • Resolved Informatica environment issues.
Business Benefit
  • 24/7 availability of ETL applications.
  • Improved decision-making capabilities due to reliable and responsive environment.
  • Improved data transformation and loading performance – observed 60% reduction in daily load times using upgraded version.