No more typing reviews! Try our Samantha, our new voice AI agent.

ETL Solutions Transformation Manager vs Informatica PowerCenter comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jun 3, 2026

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

ETL Solutions Transformatio...
Ranking in Data Integration
53rd
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
No ranking in other categories
Informatica PowerCenter
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Visualization (13th)
 

Mindshare comparison

As of August 2026, in the Data Integration category, the mindshare of ETL Solutions Transformation Manager is 1.0%, up from 0.4% compared to the previous year. The mindshare of Informatica PowerCenter is 3.4%, down from 7.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.4%
ETL Solutions Transformation Manager1.0%
Other95.6%
Data Integration
 

Featured Reviews

Vijayraj Amin - PeerSpot reviewer
Global Growth Strategist at MAIORA
User-friendly and accessible for anyone with computer knowledge and logical thinking
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust analytics. The plan is to enhance this feature in 2024, around Q2 or Q3, which would save us from relying on external tools like Power BI for insights.
Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Has supported complex data pipeline creation but performance tuning and monitoring responsiveness need improvement
Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into. Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is among the best, even if not widely known."
"Transformation Manager is the backbone of every data pipeline these days because the solution has been on the market for 20 to 30 years, and we use it for various industries, including financial services, manufacturing, healthcare, etc."
"It is a reliable solution."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Can manage a huge quantity of data and provide reliability."
"The most valuable features are the metadata repository and the data warehouse application console."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
 

Cons

"There is room for improvement in the solution's visualization tool."
"They should build a functional architecture based on queuing."
"We get decent support. It's okay but not great."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"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."
"I would like to see an improvement in the digital adoption."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"GUI: Lack of clarity and consistency created problems for our staff."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
 

Pricing and Cost Advice

"It is an expensive solution."
"We are using an annual license for Informatica PowerCenter."
"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
"Our customers pay a licensing fee yearly."
"I am not sure about the most recent price, but I think it should be $100,000 or more."
"The price could be better. It's very expensive. On a scale from one to five, I would give Informatica PowerCenter's price a one."
"Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products. Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
908,834 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Outsourcing Company
14%
Construction Company
14%
Computer Software Company
11%
Financial Services Firm
8%
Financial Services Firm
15%
Manufacturing Company
8%
Government
7%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
 

Questions from the Community

Ask a question
Earn 20 points
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
 

Also Known As

Transformation Manager
PowerCenter
 

Overview

 

Sample Customers

Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about ETL Solutions Transformation Manager vs. Informatica PowerCenter and other solutions. Updated: August 2026.
908,834 professionals have used our research since 2012.