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."The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"Good product if you are trying implement data quality, data integration, and data management projects."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"The most valuable features are the monitoring tools and the reporting manager."
"It has very good monitoring and process monitoring."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"It has good integrations with Amazon Redshift and other AWS services."
"It is an incredibly user-friendly and intuitive tool, making the learning curve quite smooth"
"The new version with the Productivity Cloud is very simple. It's easy to use, navigate, and understand."
"The product's initial setup phase was easy."
"It has improved the costs of managing my customer’s data."
"The product has a good user interface."
"The most valuable feature of Matillion ETL is the UI experience in which you can drag and drop most of the transformation."
"It is pretty user-friendly, even for people who aren't super technical."
"Its scalability can be improved. It is not scalable."
"This product is going to decommission in the next couple of years."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"There is some room for improvement in terms of pricing."
"I would like to see it be able to import data from NoSQL."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"The product must enhance its near-real-time data capture feature."
"Matillion’s on-premises capabilities don’t allow you to build something customized."
"There are certain functions that are available in other ETL tools which are still not present in Matillion ETL. It would be good to have more features."
"Ideally, I would like it to integrate with Secrets Manager as well as the AWS."
"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."
"Performance can be improved for efficiency, and it can be made faster."
"To complete the pipeline, they might want to include some connectors which would put the data into different platforms. This would be helpful."
"I found some of the more complex aspects of ETL challenging, but I grasped the concepts fairly quickly."
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.