About PowerCenter

PowerCenter is a cloud-based enterprise data integration platform that helps businesses with data integration life cycle. The platform enables users to manage data integration agility, enterprise scalability, operational confidence and data integration projects. 

PowerCenter’s key features include business collaboration, IT collaboration, re-usability, automation, operations, governance oversight, real-time data, prototype, profiling, validation, automated data validation testing, data transformation and connectivity to cloud applications. Additionally, the platform allows users to monitor reinforce coding and production providing support for adaptive load balancing, grid computing, pushdown optimization, partitioning and more.

PowerCe...


Read More

Supported Operating System(s):

Web browser (OS agnostic)

37 Reviews of PowerCenter

Average User Ratings

Overall

4.51 / 5 stars

Ease-of-use

4.5

Value for money

4.0

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(20)

20

4 stars

(16)

16

3 stars

(1)

1

2 stars

(0)

0

1 stars

(0)

0

Likelihood to Recommend

Not likely

Very likely

Showing 1 - 5 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

Verified Reviewer

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

Verified Reviewer

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

Verified Reviewer

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

Verified Reviewer

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.