Informatica integration ETL Tool
What do you like best?
easy to use
no need to write complex code for data integration
Easy To manage data pipelines
option to transform data through scripting(SQL, Python)
Connectors are available to connect with the verity of data sources.
Online material and documentation available to start a journey with Informatica Integration tool
can be easily hosted on on-premise and cloud platform like Azure
What do you dislike?
Pricing is high for the small level organization.
No GDPR and governance support feature available
implementing data lineage is tough
Take more time when it comes to the large cloud replication
Recommendations to others considering the product:
Best tool to use. No need to write and maintain lengthy codes.
What problems are you solving with the product? What benefits have you realized?
We need to get data from different sources like Salesforce SFDC, Cloud applications, and Oracle DB.
Data is in the form of web API(XML/JSON), flat files, RDBMS tables, etc. we have to get that data and transform and store into our data lake.