User Reviews Overview

Feature Ratings

Ease-of-use

4.5 / 5

Value for Money

4.0 / 5

Customer Support

4.0 / 5

Functionality

4.5 / 5

Ratings Breakdown

5 stars

(20)

20

4 stars

(16)

16

3 stars

(1)

1

2 stars

(0)

0

1 stars

(0)

0

  • Pros

  • "Great support and knowledge base. Easy to learn"

  • "This tool has so many functionalities and options to use for data flow and transformations"

  • "It can connect to almost all types for sources and targets, it has so many built in transformations which can be readily used to meet the business needs."

  • 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. "

  • "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."

  • "I guess the GUI can be improved as it is less user friendly or you can say boring."

Browse PowerCenter Reviews

Filter by:

Sort by:
 

Showing -49 - -13 of 37 results

October 2018

Abhisha from North Carolina State University

Verified Reviewer

Company Size: 1 employee

Industry: Higher Education

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

3.0

Functionality

4.0

October 2018

Good ETL tool

I was using Informatica PowerCenter as an ETL to to feed data into Teradata datawarehouse that houses customer information for an insurance company.

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.

July 2019

Manali from Amazon

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

3.0

Customer support

4.0

Functionality

3.0

July 2019

Good but require to inbuilt multiple function

It's good but yeah not too good

Pros

1. Drag and drop services 2. Easily maintain 3. Run multiple batch jobs 4. Define methods with logistics

Cons

1. Can't schedule in workflow 2. Job running status logs are too long 3. Doesn't have parallel off functionality 4. Can't be sync with repository automatically

October 2016

Anandh from Limited Brands

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

3.0

Value for money

3.0

Customer support

3.0

Functionality

4.0

October 2016

Informatica Power Center

Product Met expectations. Could have better customer support and timely resolution of user queries.

March 2018

Sri Ramani from ATT

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

March 2018

Ease to use

Ease to work

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.

June 2017

Sriram from Techmahindra

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

June 2017

Awesome Tool

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.

June 2019

natasha from TCS

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

June 2019

Informatica for every ETL demand

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.

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.

October 2016

Sarathy from SFDC

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

October 2016

Informatica Powercenter

I have using Informatics Powercenter for ETL and data integration needs for the past 12 years and its one of the best tool available in the market.

Pros

It can connect to almost all types for sources and targets, it has so many built in transformations which can be readily used to meet the business needs.

Cons

Its performance when dealing with huge volume of data is not that great when compared to Ab-initio. Also, its very expensive.

October 2019

Saurabh from Cognizant

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

3.0

Customer support

4.0

Functionality

3.0

October 2019

Informatica

I like ease of working with this software but would prefer Informatica to focus more on Data Science

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

October 2019

krystal from Solutions Architect

Company Size: 5,001-10,000 employees

Industry: Health, Wellness and Fitness

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

October 2019

Great Product for All Medium to Large Companies

I have been using it 15 plus years to development, installation administration - all aspects

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

October 2018

Aniket from NTT DATA Services

Verified Reviewer

Company Size: 10,000+ employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

October 2018

Informatica PowerCenter ETL Tool

I have used Informatica PowerCenter data masking module for masking Production data in the TEST and DEVELOPMENT environments. It has worked out pretty well.

Pros

Informatica PowerCenter is a user friendly tool.

Cons

The price of Informatica PowerCenter tool is a bit high

May 2019

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

May 2019

One of the best ETL ( Extract, Transform, Load) Tools

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.

December 2018

Anonymous

Verified Reviewer

Company Size: 1,001-5,000 employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

5.0

Functionality

4.0

December 2018

Informatica - Performance with ease

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.

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.

July 2018

Sagar from Tarkett

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

July 2018

Strong ETL Tool for your data warehousing need

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.

November 2016

Daniel from Freelance

Company Size: 1 employee

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

2.0

Customer support

5.0

Functionality

4.0

November 2016

A complete integration platform with a high focus on ETL/ELT processes

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.

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.

June 2019

Raviteja from Holland America Group

Company Size: 10,000+ employees

Industry: Leisure, Travel & Tourism

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Functionality

5.0

June 2019

Used to be the best ETL tool, has to catchup alot with new Cloud services

So far the best ETL tool I have used.

Pros

This tool has so many functionalities and options to use for data flow and transformations

Cons

Didn't meet my expectations when tried to use it along with other Cloud AWS services

November 2018

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

November 2018

Informatica Power center

Overall as a data analyst. Informatica is the one of the best etl tool to be used nowadays.

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.

October 2016

Lakshmi from Salesforce

Company Size: 10,000+ employees

Industry: Computer Software

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

5.0

October 2016

Informatica Powercenter Experience

I am working on Informatica Power Center since 2000 as I have a good amount of expertise with this tool.

Pros

Ease of Use

Cons

Too many tools

December 2018

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Functionality

5.0

December 2018

Market leader in ETL

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.

December 2018

Darpan from CITIUSTECH INC

Company Size: 1,001-5,000 employees

Industry: Information Technology and Services

Time Used: Less than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Functionality

4.0

December 2018

User friendly tool for ETL developer

PowerCenter is an great tool for ETL if it involves multiple kind of data sources / targets.

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.

December 2016

Scott from Rapid Recovery

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support

5.0

Functionality

4.0

December 2016

Powerful ETL Tool with Steep Learning Curve

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.

May 2019

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

3.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

May 2019

Best tool in Market

Pros

It's level details about the issue and various tool for each activities

Cons

We require a better system configuration to support the software there is no lighter version of it

September 2019

Srinivas from Proofpoint

Company Size: 1,001-5,000 employees

Industry: Information Technology and Services

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Functionality

5.0

September 2019

PowerCenter

Pros

Excellent for ETL (extract, transform, load) use cases.

Cons

User Interface tool is a large process. There are atleast few tools which have to opened to finish an ETL job

May 2019

Michael from Ironside Group

Company Size: 51-200 employees

Industry: Information Services

Time Used: Less than 12 months

Review Source: Capterra


Ease-of-use

2.0

Value for money

2.0

Functionality

5.0

May 2019

Great ETL Tool - Better if you're Informatica savvy

Powercenter is a great standalone application but the way the entire informatica suite is divided into multiple licenses, this is a system you need to understand and be okay with

Pros

Very flexible tool - have yet to find something I couldn't accomplish with it SQL input capability

Cons

Packaged solution, so you're better off buying the other Informatica tools with it - this can make it a rather expensive solution

November 2018

Anonymous

Verified Reviewer

Company Size: 1,001-5,000 employees

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

3.0

Functionality

4.0

November 2018

Power Center Brazilian. Experience

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.

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.

July 2019

Dan from Sharp

Company Size: 10,000+ employees

Industry: Hospital & Health Care

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Value for money

3.0

Customer support

5.0

Functionality

5.0

July 2019

Great tool but expensive

Pros

It helps with our ETL process, and allows us to successfully build and schedule complicated workflows.

Cons

The price. This software does a lot of great things, but we pay way too much for this service yearly.

April 2018

Anonymous

Verified Reviewer

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

April 2018

Excellent ETL tool with support for Data Integration with multiple systems.

Pros

1) Stable ETL tool with excellent Monitoring and Workflow Logging Capabilities 2) Excellent support and Forums to clarify any queries.

Cons

1) Licensing cost is high as compared to other ETL tools 2) Need to enhance support for Big Data Components

January 2019

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: More than 2 years

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

January 2019

Informatica Powercenter

Pros

I believe there is nothing better than this ETL tool great features to create mapping from different source system and easy to create lookup.

Cons

COnsumes lot of memory in case of Lookup of cache need to improve that.

October 2016

Sulabh from Meredith

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

2.0

Functionality

4.0

October 2016

Senior Developer

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

October 2016

na from informatica

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

October 2016

informatica

informatica cloud has Data Replication and Data Quality service and on top of it has also Full load and CDC incremental ;load which helps to reploicate al customers data.

October 2016

Tony from insidesales.com

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

October 2016

Awesome information for my sales team

My sales team relies heavily on the right information for an account based selling strategy. In order to deliver the right lead, we need the right information.

October 2016

Roderick from TELUS

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

4.0

Value for money

3.0

Customer support

3.0

Functionality

4.0

October 2016

Informatica cloud

informatica works so well with our ETL requirement with Salesforce. The customer support is pretty. The people are responsive and very helpful.

October 2016

H from Independent Consultant

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

3.0

Functionality

4.0

October 2016

Informatica Review

We use informatica for ETL process and the results so far have been great. Its easy to integrate across platforms and work on

October 2016

Ashish from Cap One

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

October 2016

Awsome tool to migrate and sync data

We have used informatica cloud to migrate and do co- exist betwen 2 applications. It was easy and intuituve.

October 2016

Elton from Capital One

Time Used: Free Trial

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

3.0

Functionality

4.0

October 2016

informatica review

used to one-time migrate accounts, contacts and cases, as well as co-exist sync, is very effective at two way sync

November 2018

Paul from Volendo North

Company Size: 2-10 employees

Industry: Retail

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Functionality

5.0

November 2018

Excellent integration

Pros

The integration has been seamless its been better than expected

Cons

We should have got it sooner there are no real negatives

November 2018

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

5.0

Functionality

4.0

November 2018

ETL made easy

Pros

This software is a power packed bundle of tools needed foe ETL purpose

Cons

Can be made a bit more attractive for the users

February 2018

nandini from Walmart

Time Used: Less than 6 months

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

February 2018

A very powerful tool in ETL

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.