Good Cloud ETL solution Tool helps in Building Complex Data Pipeline (real time and batch processing both)
May 27, 2021

Good Cloud ETL solution Tool helps in Building Complex Data Pipeline (real time and batch processing both)

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Informatica Intelligent Cloud Services

Informatica Cloud Service is used in several departments. In upcoming months we will start using it in more departments. We already had datapipeline setup using Python spark and other paid tool. But most department are migrating the data pipeline and creating good ETL model following SCD type 1,2 Load.
We are migrating most of our complex data pipeline to informatica one.

Reason to migrate is for cloud solution ETL. [The] main advantage of cloud ETL [is that] it can be more scalable and cost-effective solution: when we require more storage and more resource we can pay more, so now we can just pay for what we need.

Informatica also has wide user base so even getting the right talent is not an issue for our organization, if someone used Informatica he/she can easily start with Informatica Cloud service. In the future, the Cloud will be excellent solution for resource and cost optimization.

  • Building Data pipeline in very easy (mapping and workflow section is highly configurable and mostly with all option)
  • Easy debugging mode, you can backtrack and check which transformation has issue
  • Easy workflow trigger using shell script, python or control-M
  • Cloud base solution is future which will be very helpful for scalable solution
  • Our previous solution is pure in house development, which is based on free [solutions]. So Informatica is costly w.r.t freeware.
  • Sometimes team architecture is based on AWS so they are not going to switch on Informatica solution
  • CONS: Not Freeware solution
  • PRO: Good cost effective cloud solution
  • PRO : Informatica has huge user base
Below are my comment based on 2+ year of experience in Informatica Cloud
PROS:
1. Scalable Data Pipeline
2. Easy to use Heterogeneous Databases (Multiple type of sources in Single Mapping)
3. Multiple options to configure your mapping (I have created SCD type 1,2 and 3 on multiple projects)
4. Easy to debug your mapping, debug mode simulation is there in the product.

CONS:
1. Less Documentation of any new feature (Which I faced during my initial usage)
2. No Demo video for new data source (More use documentation need to be provided)
3. In Case of new API integration faces multiple issues every time only hit and trial works.

Do you think Informatica Intelligent Cloud Services delivers good value for the price?

Yes

Are you happy with Informatica Intelligent Cloud Services's feature set?

Yes

Did Informatica Intelligent Cloud Services live up to sales and marketing promises?

Yes

Did implementation of Informatica Intelligent Cloud Services go as expected?

Yes

Would you buy Informatica Intelligent Cloud Services again?

Yes

If your company does not have a scalable ETL solution, the current data pipeline is just data migration using my SQL or python API, you should switch to a good ETL solution - you can achieve [this with] Informatica Intelligent Cloud Services.
[Well suited] if you want to use good data warehousing concepts in your practical warehouse, no hardcore developer is required. Ease in debugging.

In the future (next 5 Years) most process will be setup on cloud base solution. Reason of cloud solution is [it's] flexible resources, pay for what you use, no in-house storage processing required, and the availability of talented people in [the job] market [who know] Informatica.

Informatica Intelligent Cloud Services Feature Ratings

Pre-built connectors
9
Connector modification
9
Support for real-time and batch integration
10
Data quality services
9
Data security features
8
Monitoring console
8

Using Informatica Intelligent Cloud Services

Datawarehosuing people and Analytics Team uses this
For support we have few people once product is developed there is only one team for monitoring
  • Complex Data Piepline
  • Easy debugging
  • GUI interface
  • Support of all kind of datasources
  • It may scale to company level, currently it is focused on Analytics Team.