We performed a comparison between Informatica PowerCenter and Matillion ETL based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"What I like the most is that we have to deal with less while writing the queries."
"I like the completeness of the way I can build ETL workflows."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"In the end, you have structured, proper data for use in an integrated BI solution."
"It's very easy to use it to develop mappings and workflows."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"The most valuable feature of Matillion ETL is the ETL. The solution is open-source which provides advantages, such as good performance and high efficiency. Additionally, it supports three data types which eliminates predefining the data, and we can write script models in Python."
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"Matillion ETL helps manage data movement, ingestion, and transformation through pipelines."
"It has improved the costs of managing my customer’s data."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Integrating new tools can be tricky and challenging."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"There is some room for improvement in terms of pricing."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"I am looking forward to seeing the expansion of the source range for their data loader product."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Going forward, I would like them to add custom jobs, since we still have to run these outside of Matillion."
"It can have multi-environment support. We should be able to deploy it in different environments. Its integration with SAP connection is not so nice, which should be improved. It can also support an on-prem database."
"Performance can be improved for efficiency, and it can be made faster."
"When using the SQL loader type there were not a lot of pre-processing features for the data. For example, if there is a table with twenty columns, but we only want to load ten columns. In that case, we can use a security script to select the specific columns needed. However, if we want to perform extensive pre-processing of the data, I faced some challenges with Matillion ETL. I did not encounter many challenges, but my overall experience is limited as I only have three years of experience."
"The improvement area could be possible if the tool provides better integration capabilities with other ecosystems, including governance tools or data cataloging tools, as it is currently an area where the solution is lacking."
"In the next release, we would like to have connections to more databases."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Matillion ETL is ranked 4th in Cloud Data Integration with 24 reviews. Informatica PowerCenter is rated 8.0, while Matillion ETL is rated 8.6. The top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". On the other hand, the top reviewer of Matillion ETL writes "Efficient data integration and transformation with seamless cloud-native integration". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and Tableau, whereas Matillion ETL is most compared with Snowflake, Azure Data Factory, AWS Glue, SSIS and Informatica Cloud Data Integration. See our Informatica PowerCenter vs. Matillion ETL report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.