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."Good product if you are trying implement data quality, data integration, and data management projects."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"The technical support is excellent."
"Has a good visual tool for data mapping."
"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."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"The solution is stable."
"We allow non-technical people to use Matillion to load data into our data warehouse for reporting. Thus, it is easy enough to use that we don't always have to get a technical person involved in setting up a data movement (ETL)."
"Matillion ETL has great Git integration that is perfect and convenient to use."
"The most valuable feature of Matillion ETL is its ease of use. If you have had some experience with other solutions, such as Snowflake, the use of this solution will be simple."
"It's highly scalable. It takes upon itself the Redshift scalability, so it's very good."
"Matillion ETL is one hundred percent stable."
"The technical support treats us well. They already have a support portal, and they are responsive, which helps."
"It takes less than five minutes to set up and delivers results. It is much quicker than traditional ETL technologies."
"The most valuable feature of Matillion ETL is its user-friendly graphical interface."
"Support could be better."
"The documentation could be improved."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"The solution must improve the integration with new services."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Its scalability can be improved. It is not scalable."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The current version is a bit more limited because it's on a virtual machine, and everything executes on that one virtual machine."
"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."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"Unlike Snowflake which automatically takes care of upgrading to the latest version and includes additional features, with Matillion ETL we need to do this ourselves."
"While the UI is good, it could be improved in its efficiency and made easier to use."
"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."
"The tool's lineage is very weak."
"It needs integration with more data sources."
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 Oracle GoldenGate, 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.