Need
- Migrate from Informatica to Pentaho (open source) within ~3 weeks
- Reduce Annual subscription costs of Informatica
- No documentation was available for the Informatica implementation and Pentaho platform
Solution
- Strategy sessions with the customer on the data transformation required and reduced the complexity of the transformations as necessary
- Migration of data replication and transformation jobs from Informatica to Pentaho
- Operated in an Agile model with Daily Review & Retrospect meeting to avoid surprises later
Outcome
- Configured all the transformations on staging environment in 2 weeks
- Supported UAT and bug-fixing plus further enhancements during the 3rd week
- Helped the client to cancel the Informatica annual subscription well on time and deliver costs savings
