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

ETL Solutions Transformation Manager vs Informatica PowerCenter comparison

Why PeerSpot?
 

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
55th
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 November 2026, in the Data Integration category, the mindshare of ETL Solutions Transformation Manager is 1.0%, up from 0.7% compared to the previous year. The mindshare of Informatica PowerCenter is 3.7%, down from 5.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Mindshare Distribution
ProductMindshare (%)
Informatica PowerCenter3.7%
ETL Solutions Transformation Manager1.0%
Other95.3%
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.
Hemanthreddy Vakiti - PeerSpot reviewer
Data Engineer at a tech vendor with 10,001+ employees
Streamlined daily sales workflows have reduced team size and enabled earlier, accurate reporting
One of the best features I appreciate about Informatica PowerCenter is that anyone with minimal knowledge of ETL can easily use it. It has four different interfaces: Monitor, Repository, Designer, and Workflow Manager. With our use case, we can easily go to that particular interface and use it. Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload. Informatica PowerCenter has positively impacted my organization because, as I mentioned previously, the development team has been reduced to half since we moved to it due to its easy interface and the reusability of Mapplets. It has also saved us a lot of time; for example, it has saved nearly one hour per day on monitoring and workflow tasks. Saving one hour a day is key because it has led us to report the data to business users one hour earlier than the usual time. If there are any anomalies or defects in the data, we can easily rectify them within that hour, which reduces the chance of errors in the data. Regarding cost, the number of people working on the project has been reduced to half, thus significantly decreasing costs for our organization since we moved to Informatica PowerCenter.

Quotes from Members

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

Pros

"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."
"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."
"It is among the best, even if not widely known."
"It is very robust, scalable, and simple to use, and it is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The product's initial setup phase is very easy."
"Informatica PowerCenter is a very stable product."
"What I like the most is that we have to deal with less while writing the queries."
"The number of docs has been reduced drastically, which is very good."
 

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."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"Its scalability can be improved. It is not scalable."
"I would like to see an improvement in the digital adoption. It would be nice if they could be cheaper, because the training is very expensive as they do everything online."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"It is very difficult to learn."
"I would like to see an improvement in the digital adoption."
 

Pricing and Cost Advice

"It is an expensive solution."
"We are satisfied with the pricing."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"A basic setup can be from $100,000 and up annually."
"We are using an annual license for Informatica PowerCenter."
"Cost could be improved."
"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."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"I consider this to be an expensive product."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
920,769 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
Comms Service Provider
12%
Construction Company
12%
Outsourcing Company
11%
Financial Services Firm
8%
Financial Services Firm
16%
Manufacturing Company
8%
Outsourcing Company
8%
Construction 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: October 2026.
920,769 professionals have used our research since 2012.