--- title: "PowerCenter Reviews, Pros and Cons - 2026 Software Advice" description: "Reviews of PowerCenter. Learn how real users rate this software's ease-of-use, functionality, overall quality and customer support. Talk to our advisors to see if PowerCenter is a good fit for you!" source_url: "https://www.softwareadvice.com/bi/powercenter-profile/reviews/" page_type: "reviews" language: "en" --- 1 million+ businesses helped. Get advice Get Free Advice [Home](https://www.softwareadvice.com/) / [Integration Software](https://www.softwareadvice.com/bi/data-integration-tools-comparison/) / [PowerCenter](https://www.softwareadvice.com/bi/powercenter-profile/) / PowerCenter Reviews Software Advice offers objective insights based on verified user reviews and independent product and market research. When our advisors match you to a software provider, we may earn a referral fee. [Overview](https://www.softwareadvice.com/bi/powercenter-profile/) Reviews # PowerCenter User Reviews ## Reviews summary - Overall rating: 4.5/5 - Total reviews: 42 ### Secondary ratings - Ease of use: 4.2/5 - Customer support: 4.1/5 - Value for money: 4.0/5 - Functionality: 4.4/5 ### Rating distribution - 5 stars: 23 reviews (55%) - 4 stars: 17 reviews (40%) - 3 stars: 1 reviews (2%) - 2 stars: 1 reviews (2%) - 1 star: 0 reviews (0%) ## PowerCenter customer reviews Showing reviews 1-25 of 42 (page 1). ### Power Center Brazilian. Experience - Overall rating: 4/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Construction - Company size: 1001-5000 employees - Product usage: Used daily for less than 6 months - Reviewed: November 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. At my company we work with maps for each transformation Mode, maps for extraction, transformation and load. It's good to learn well each one. From The ETL softwares I've worked with, Power Center is The easier tô learn. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 3/5 - Functionality: 4/5 #### Pros Transformation of data by Any kind of e trance (from csv filés, txt, from bank tables). #### Cons The Source Qualifier filters and debugger Mode. --- ### Ease to use - Overall rating: 5/5 - Reviewer: Sri Ramani B. - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: March 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Ease to work #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros It Works vwell with large structured data files PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files. PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily. PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within AT&T organization. #### Cons PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files. PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily. PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within our organization. --- ### Informatica Power Center - Overall rating: 3/5 - Reviewer: Anandh S. - Product usage: Used unspecified for unspecified - Reviewed: October 2016 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Product Met expectations. Could have better customer support and timely resolution of user queries. #### Ratings breakdown - Ease of use: 3/5 - Value for money: 3/5 - Customer support: 3/5 - Functionality: 4/5 --- ### PowerCenter in Data Integration & BI - Overall rating: 4/5 - Reviewer: Nikki H. - Verified reviewer: Yes - Industry: Government Administration - Company size: 1001-5000 employees - Product usage: Used daily for less than 2 years - Reviewed: December 2023 - Review source details: This review was submitted organically. No incentive was offered I like it. we use it for daily batch load monitoring, issue debug and etc. However, it's super hard to upgrade from Informatica PowerCenter to IICS. #### Ratings breakdown - Ease of use: 4/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros multiple tools available for development, support and troubleshoot - workflow monitor, workflow manager, workflow designer, repository manager, etc. #### Cons it's not an easy job to track back from target to source --- ### Informatica for every ETL demand - Overall rating: 5/5 - Reviewer: natasha s. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: June 2019 - Review source details: This review was submitted organically. No incentive was offered Informatica has simplified PowerCenter integration with power exchange, data quality, metadata management and data discovery tools. I highly recommend this tool for all your ETL processes. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros PowerCenter is being used across the organization for all our ETL needs weather to load data from different sources, collect data from different flat file or integrate multiple systems for reporting requirement. This is the best and easiest tool for pulling data from source systems, modifying it and load to target system. It also provide the best performance when processing huge data in batch PowerCenter supports various DBMS technologies for e.g: Oracle, Netezza. This flexible nature of it allows it to be used by multiple departments. And last but not ;least it is very easy to learn and use #### Cons There is no or less password encapsulation in this software rest everything is great. --- ### Awesome Tool - Overall rating: 5/5 - Reviewer: Sriram K. - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: June 2017 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros When joining Informatica I have to say, the whole process was a very nice and comforting transition. I was very impressed by level of care, focus and how they approached the recruitment process. The Human resources and Management team are a really great bunch of people and I believe we made the right choice together. They gave me confidence in how the company is run, they were clear and concise on how the company structure works and what the expectations are. The company progression is great, already I'm gaining more responsibility and growing and learning more about the industry, so on this I would certainly recommend Informatica as a prospect to anyone looking for an Innovative, Positive, growing and fun company to work for #### Cons Scheduler tools can manage dependencies accross many systems and environments. For instance you can configure it so that your informatica job only runs after the successful completion of some other system's windows job and/or another system's batch job. --- ### Best ETL tool - Overall rating: 5/5 - Reviewer: Siddharth R. - Verified reviewer: Yes - Industry: Financial Services - Company size: 1001-5000 employees - Product usage: Used daily for more than 2 years - Reviewed: February 2022 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Functionality: 5/5 #### Pros Easy to integrate with any DB, flat file. Core concepts are very similar to sql. Very easy to understand the flow of data from source to target. #### Cons No auto refresh functionality. Lack of a Script to automatically generate the parameter file. --- ### Informatica - Overall rating: 4/5 - Reviewer: Saurabh A. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: October 2019 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I like ease of working with this software but would prefer Informatica to focus more on Data Science #### Ratings breakdown - Ease of use: 4/5 - Value for money: 3/5 - Customer support: 4/5 - Functionality: 3/5 #### Pros Easy to Learn Multiple connectors for data transfer Handles multiple data sources IDQ and Informatica MDM were real game changer compared to other ETL tools #### Cons Not so compatible with upcoming technologies for Big Data and Data Science. Informatica cloud needs to be marketed more and made compatible like Powecenter --- ### Great Product for All Medium to Large Companies - Overall rating: 5/5 - Reviewer: krystal p. - Verified reviewer: Yes - Industry: Health, Wellness and Fitness - Company size: 5001-10000 employees - Product usage: Used daily for more than 2 years - Reviewed: October 2019 - Review source details: This review was submitted organically. No incentive was offered I have been using it 15 plus years to development, installation administration - all aspects #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros It allows you to integrate multiple datasets from different sources. #### Cons What I like the least about this software is the costs of the licensing. #### Reasons for choosing PowerCenter Ability to integrate data from multiple data sources easy, gui based transformations makes coding easy, has been a stable product on the market for years --- ### User friendly tool for ETL developer - Overall rating: 4/5 - Reviewer: Darpan P. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 1001-5000 employees - Product usage: Used monthly for less than 2 years - Reviewed: December 2018 - Review source details: This review was submitted organically. No incentive was offered PowerCenter is an great tool for ETL if it involves multiple kind of data sources / targets. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Functionality: 4/5 #### Pros One of the Important pro is that GUI interface is very easy to use and understand. I have used other ETL tool like SSIS but Informatica PowerCenter helps developing ETL is easiest way. Transformation works great and efficiently. #### Cons When compared with SSIS, informatica PowerCenter doesn't perform well when source and/or target database is SQL Server. However that is understood because SSIS and SQL Server both are native to Microsoft. Sometimes the buffer space gets filled quickly even if lookup query doesn't seem to be heavy. Just as a suggestion - It would have been great if there was a inbuilt performance tuning tool that could suggest way to improve mapping performance. --- ### Powerful ETL Tool with Steep Learning Curve - Overall rating: 4/5 - Reviewer: Scott R. - Product usage: Used unspecified for unspecified - Reviewed: December 2016 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Informatica is known to have a love/hate relationship with the majority of its users. The main reason for this is the steep learning curve of its vast amount of features. A lot of the features are very "hidden" without a knowledge both deep and wide of the software. Other than with lengthy experience, it is very hard to understand how to tackle a lot of specific problems. However, the majority of the solutions it can provide are very straight forward and can be created very quickly. There is very good customer support provided with the product but the code Informatica is built on is old and a lot of features that the community desires cannot be added. This does not necessarily take away from the functionality but more the overall quality since the product will someday be too out of date. In conclusion, it is one of the best ETL tools and is great value but its main issue is the steep learning curve that will still hit you every couple months. #### Ratings breakdown - Ease of use: 3/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 4/5 --- ### Senior Developer - Overall rating: 4/5 - Reviewer: Sulabh K. - Product usage: Used unspecified for unspecified - Reviewed: October 2016 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We have been using Informatica for over an year. This is a very powerful tool and is massive helpful in integrations but when it comes to Customer Support, this is so poor #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 2/5 - Functionality: 4/5 --- ### Informatica Review - Overall rating: 4/5 - Reviewer: H S. - Product usage: Used unspecified for unspecified - Reviewed: October 2016 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. We use informatica for ETL process and the results so far have been great. Its easy to integrate across platforms and work on #### Ratings breakdown - Ease of use: 3/5 - Functionality: 4/5 --- ### A very powerful tool in ETL - Overall rating: 5/5 - Reviewer: nandini n. - Verified reviewer: Yes - Product usage: Used monthly for less than 6 months - Reviewed: February 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros I have used Informatica to get Returns on Investment and trust me Informatica can make data so much more useful with its powerful transformations. Best ETL tool in the market. #### Cons It is a heavy software and the setup itself is ~10Gb. Requires a good configuration machine, but thankfully they also provide cloud services. --- ### Power Centre Review - Overall rating: 5/5 - Reviewer: Martha Leah N. - Verified reviewer: Yes - Industry: Oil & Energy - Company size: 10000+ employees - Product usage: Used monthly for less than 2 years - Reviewed: October 2024 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros The ETL by Informatica is beautiful. The Infortica ETL process makes the job of a DBA / DBM very easy. #### Cons Well, I cannot remember any cons. Power Center is very good. Informatica did an awesome job. --- ### One of the best ETL ( Extract, Transform, Load) Tools - Overall rating: 4/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: May 2019 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros 1. Able to process a huge record size. In the latest project, we used Informatica to load approx 5 Million records daily. There were no performance issues due to the data size. 2. . PowerCenter has very easy to use drag and drop interface which can be used in integration with other applications. 3. Good tool to manage legacy data and to make compatible with modern applications. 4. PowerCenter also has other additional features like the ability to profile data, visualize graphical data flow etc. Data validation can also be done very easily using the validation feature. #### Cons There is a huge licensing fee which is worth it as the product is one of the best ETL tools, but projects which smaller budget find it challenging to justify the cost. --- ### Informatica - Performance with ease - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 1001-5000 employees - Product usage: Used daily for more than 2 years - Reviewed: December 2018 - Review source details: This review was submitted organically. No incentive was offered I have been working on the tool since last 8+ years and the tool has never failed me. I could design almost everything i could think of in terms of data flow and transformations. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Customer support: 5/5 - Functionality: 4/5 #### Pros The ease of development, debugging, migrating and maintaining the code. Heavy duty performer and can scale to perform multi-threading. #### Cons It does not have strong ELT features or market - so cannot leverage the high computing capability. Still based out of legacy ETL process which needs to be migrated. --- ### A complete integration platform with a high focus on ETL/ELT processes - Overall rating: 4/5 - Reviewer: Daniel T. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: Self-Employed - Product usage: Used weekly for more than 2 years - Reviewed: November 2016 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. If you need to do a fast ETL/ELT process and you do not want complications, this is your application. Informatics (on-premises) is quick to deploy and you can start to develop your process really quickly. The Informatica Knowled Base is very complete and you can find in it some templates to use. In all the development process, you can see and following the data per each transformation. You can launch a part of the process, simulating the data output. The quality of the solution is fantastic and his support is great, they usually respond to a problem in hours. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 2/5 - Customer support: 5/5 - Functionality: 4/5 #### Pros Great support and knowledge base. Easy to learn #### Cons Currently the managing of EII processes (like Restful or SOAP) are not well supported by the on-premise solution. --- ### Informatica PowerCenter ETL Tool - Overall rating: 4/5 - Reviewer: Aniket Z. - Verified reviewer: Yes - Industry: Information Technology and Services - Company size: 10000+ employees - Product usage: Used daily for more than 2 years - Reviewed: October 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I have used Informatica PowerCenter data masking module for masking Production data in the TEST and DEVELOPMENT environments. It has worked out pretty well. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 4/5 #### Pros Informatica PowerCenter is a user friendly tool. #### Cons The price of Informatica PowerCenter tool is a bit high --- ### Good ETL tool - Overall rating: 5/5 - Reviewer: Abhisha B. - Verified reviewer: Yes - Industry: Higher Education - Company size: Self-Employed - Product usage: Used other for more than 2 years - Reviewed: October 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. I was using Informatica PowerCenter as an ETL to to feed data into Teradata datawarehouse that houses customer information for an insurance company. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 3/5 - Functionality: 4/5 #### Pros Informatica PowerCenter is a good ETL tool for users who wish to develop a datawarehouse but do not have much programming experience. It has a nice interface where the user can simply drag and drop to create a data flow. It is very intuitive and user friendly. #### Cons PowerCenter is a heavy software and installation is not a trivial task. It uses a lot of memory and it could crash the system if it does not have enough resources. --- ### Informatica Power center - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Computer Software - Company size: 10000+ employees - Product usage: Used daily for less than 2 years - Reviewed: November 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. Overall as a data analyst. Informatica is the one of the best etl tool to be used nowadays. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros The best thing about informatica power center is that we can use it with multiple source types. #### Cons I guess the GUI can be improved as it is less user friendly or you can say boring. --- ### bon outil complet - Overall rating: 5/5 - Reviewer: Jean B. - Verified reviewer: Yes - Industry: Marketing and Advertising - Company size: Self-Employed - Product usage: Used daily for less than 2 years - Reviewed: April 2021 - Review source details: This review was submitted organically. No incentive was offered J'utilise Informatica PowerCenter comme ETL pour fournir des données à l'entrepôt de données Teradata qui héberge les informations client de la compagnie d'assurance. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Customer support: 4/5 - Functionality: 5/5 #### Pros Pour les utilisateurs qui souhaitent développer un entrepôt de données mais qui n'ont pas beaucoup d'expérience en programmation, Informatica PowerCenter est un bon outil ETL. Il a une belle interface où les utilisateurs peuvent glisser-déposer pour créer des flux de données. C'est très intuitif et convivial. #### Cons PowerCenter est un logiciel lourd et l'installation n'est pas facile. Il utilise beaucoup de mémoire, et s'il n'y a pas assez de ressources, il peut planter le système. --- ### POWERCENTER: The old legacy to be avoided - Overall rating: 2/5 - Reviewer: Joan F. - Verified reviewer: Yes - Industry: Financial Services - Company size: 51-200 employees - Product usage: Used monthly for less than 2 years - Reviewed: April 2023 - Review source details: This review was submitted organically. No incentive was offered #### Ratings breakdown - Ease of use: 1/5 - Value for money: 1/5 - Customer support: 1/5 - Functionality: 1/5 #### Pros If you are a PowerCenter expert you can do almost any data transformation. #### Cons It is very complex and difficult to use. Super expensive and with minimal suport. --- ### Market leader in ETL - Overall rating: 5/5 - Reviewer: Verified Reviewer - Verified reviewer: Yes - Industry: Computer Software - Company size: 10000+ employees - Product usage: Used weekly for more than 2 years - Reviewed: December 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 5/5 - Value for money: 4/5 - Functionality: 5/5 #### Pros Drag and drop function is easy for the developers and users to complete development faster. Powerful out of box functions are added advantage. #### Cons Initially the licensing was a bit expensive however with competition from market helped make competitively priced. --- ### Strong ETL Tool for your data warehousing need - Overall rating: 5/5 - Reviewer: Sagar K. - Product usage: Used daily for more than 2 years - Reviewed: July 2018 - Review source details: This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you. #### Ratings breakdown - Ease of use: 4/5 - Value for money: 5/5 - Customer support: 5/5 - Functionality: 5/5 #### Pros Powercenter by Informatica is a strong ETL tool which has all the features and functionality making it the best choice for your data warehouse needs. The GUI interface makes designing a mapping super-easy. The tool contains various transformation that can be used to translate your business needs #### Cons There is no actual CONS that I have seen with tool. Have been using it for so many years and I am completely happy with it. ## More reviews [Next reviews](https://www.softwareadvice.com/bi/powercenter-profile/reviews/?page=2) --- PowerCenter Reviews, Pros and Cons - 2026 Software Advice