Informatica is a powerful ETL tool
Rating: 8 out of 10
IncentivizedUse Cases and Deployment Scope
We use Informatica Cloud Data Integration for a number of things. We use it to retrieve files from and SFTP and import records into our CRM. We use it to create reports that combine data from multiple systems that are otherwise not connected. We also use it to update records within our CRM based on criteria. Most of the processes are executed by automated jobs running on a schedule.
Pros
- Transform and format data
- Match and merge data
- Very flexible scheduling options for automated tasks
Cons
- There is a moderately steep learning curve
- Has some idiosyncrasies
- Can be finicky with date formats
Likelihood to Recommend
We use it a lot for importing data. We transform the incoming data to match the formatting of our CRM. We also match on existing records to avoid creating duplicates. Informatica handles all of this exceptionally well. Our users are system administrators. The tool is not well-suited for users who do not have a technical background.
Vetted Review
5 years of experience