Try our new research platform with insights from 80,000+ expert users
Informatica PowerCenter Logo

Informatica PowerCenter pros and cons

Vendor: Informatica
4.0 out of 5
Badge Leader

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Informatica PowerCenter is recognized for its powerful and efficient ETL capabilities, capable of handling complex transformations and managing large volumes of data.
Its scalability and stability make it ideal for integrating data from heterogeneous sources and performing high-volume data transformations seamlessly.
The tool's ability to reduce legacy coding and simplify data integration processes is highly valued by organizations.
PowerCenter provides excellent technical support, which is an essential asset for businesses seeking reliable assistance and timely resolutions.
Its comprehensive transformation features, including partitioning and optimization, enhance performance and streamline development efforts.

CONS

Informatica PowerCenter lacks advanced analytics features, requiring organizations to invest in additional products for business intelligence needs.
The integration with cloud applications is not seamless, and users need to perform significant configuration work to connect with various cloud services.
High licensing costs make Informatica PowerCenter less competitive compared to other more affordable data integration tools.
Scalability is an issue, with performance affected by the ingestion of large data volumes.
Documentation, especially for new users and developers, is seen as inadequate and could benefit from clearer explanations and more examples.
 

Informatica PowerCenter Pros review quotes

it_user4518 - PeerSpot reviewer
Head of Databases at a retailer with 501-1,000 employees
Feb 22, 2013
PowerCenter is serving as the data integration foundation for our enterprise integration initiatives including data warehousing, data governance, data migration, SOA, and MDM.
it_user150912 - PeerSpot reviewer
Data Quality and Conversion with 1,001-5,000 employees
Sep 17, 2014
The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created.
it_user202221 - PeerSpot reviewer
Business Intelligence Analyst at a comms service provider with 10,001+ employees
Feb 25, 2016
With this product we can centralize all our ETL needs in one technology.
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.
it_user275235 - PeerSpot reviewer
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 6, 2016
Informatica is 100% value for money, and the kind of flexibility and stability it offers in dealing with heterogeneous data is amazing.
it_user677700 - PeerSpot reviewer
DW Admin at a hospitality company with 1,001-5,000 employees
Jun 4, 2017
Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory.
it_user488589 - PeerSpot reviewer
Technology Architect at Broadridge Financial Solutions
Jun 15, 2017
The ability to scale through partitions helped us to improve the performance.
it_user793938 - PeerSpot reviewer
Integration developer at a tech services company with 10,001+ employees
Dec 26, 2017
Good product if you are trying implement data quality, data integration, and data management projects.
it_user808662 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees
Jan 25, 2018
Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions.
MM
Student at Ontario Ministry of Labour
Mar 5, 2018
Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years.
VS
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
May 23, 2018
It reduces a lot of legacy coding.
 

Informatica PowerCenter Cons review quotes

it_user4518 - PeerSpot reviewer
Head of Databases at a retailer with 501-1,000 employees
Feb 22, 2013
GUI: Lack of clarity and consistency created problems for our staff.
it_user150912 - PeerSpot reviewer
Data Quality and Conversion with 1,001-5,000 employees
Sep 17, 2014
As all ETL tools in general, it does not include a good data reporting feature.
it_user202221 - PeerSpot reviewer
Business Intelligence Analyst at a comms service provider with 10,001+ employees
Feb 25, 2016
The initial setup was complex. There were many performance problems and some migrations took a long time to be implemented.
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2026.
884,873 professionals have used our research since 2012.
it_user275235 - PeerSpot reviewer
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 6, 2016
There are three areas where they can make a significant improvement: Live feeds, where if a database object changes then object definitions should automatically get refreshed as well.
it_user677700 - PeerSpot reviewer
DW Admin at a hospitality company with 1,001-5,000 employees
Jun 4, 2017
The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application.
it_user488589 - PeerSpot reviewer
Technology Architect at Broadridge Financial Solutions
Jun 15, 2017
We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions.
it_user793938 - PeerSpot reviewer
Integration developer at a tech services company with 10,001+ employees
Dec 26, 2017
There can be scalability issues. Huge amounts of data ingestion will impact performance.
it_user808662 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees
Jan 25, 2018
While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs.
MM
Student at Ontario Ministry of Labour
Mar 5, 2018
Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design.
VS
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
May 23, 2018
The initial setup is not straightforward. You need expertise to do it.