Informatica PowerCenter Reviews

Filter by:Reset all filters
industry
Filter Unavailable
Company Size
Filter Unavailable
Job Level
Filter Unavailable
rating
Filter Unavailable
Real User
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 06 2016

What is most valuable?

* Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. * SQL override allows users to write simple to complex queries inside mapping for... more»

How has it helped my organization?

Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the... more»

What needs improvement?

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. This would avoid re-import of objects. Auto refresh will... more»
Real User
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
Jun 06 2018

What do you think of Informatica PowerCenter?

Primary Use Case We use it for data integration. It's a great tool. • Improvements to My Organization It reduces a lot of legacy coding. • Valuable Features It works with any multi-database, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use. • Room for Improvement It has everything we want. We were looking for a feature but they have already it in Informatica 10. We are using Informatica 9.6.1 but they added the feature we were thinking about in 10.1. • Stability Issues The stability is great. • Scalability Issues Scalability, durability, everything. It is the leader in the market. • Customer Service and Technical Support We are using technical support every year, it's part of like maintenance we get from...
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools.
283,782 professionals have used our research since 2012.
Consultant
Technology Architect at Broadridge Financial Solutions
Jun 25 2017

What is most valuable?

We are using it to source data from Sybase database and flat files so as to load to the target Greenplum Database. The facility to do parallel load on Greenplum using gpload feature is valuable for us. Also, the ability to scale through... more»

How has it helped my organization?

We used Informatica PowerCenter for a re-platforming project where the earlier application was using an in-house Java-based ETL, that suffered in terms of the performance and scalability issues. With Informatica PowerCenter, we were able to... more»

What needs improvement?

In our implementation, for the initial conversion, 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... more»
Real User
DW Admin at a hospitality company with 1,001-5,000 employees
Jun 06 2017

What do you think of Informatica PowerCenter?

Valuable Features Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory. • Improvements to My Organization Like any other ETL tool, it collects business information for centralized reporting and analytics. • Room for Improvement 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. • Use of Solution Our company has used it since 2002, I started using it in 2009. • Stability Issues The integration service itself is very stable. The applications suffer from minor stability problems. • Scalability Issues The product scales very well, beyond our needs. • Customer Service and Technical Support The technical...
Consultant
Integration developer at a tech services company with 10,001+ employees
Jan 24 2018

What do you think of Informatica PowerCenter?

Improvements to My Organization We are trying to implement both Finance and Operations modernization with the help of Informatica. This tool is mainly used in data ingestion, where we bring different sources into a Hadoop environment. • Valuable Features Big Data connectivity, Data Integration solutions, and Data Quality solutions.  Easy to code and understand solutions in Informatica. • Use of Solution More than five years. • Stability Issues Yes, we had stability issues, mostly with JVM size. • Scalability Issues Yes, there can be scalability issues. Huge amounts of data ingestion will impact performance. • Customer Service and Technical Support I rate tech support seven out of 10. • Initial Setup Straightforward. • Other Solutions Considered There...
See 2 more reviews

Articles

User Assessments By Topic About Informatica PowerCenter

Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools.
283,782 professionals have used our research since 2012.

Informatica PowerCenter Questions

Informatica PowerCenter Projects By Members

Informatica PowerCenter Consultants

What is Informatica PowerCenter?

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

Also known as
PowerCenter
Informatica PowerCenter customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

BUYER'S GUIDE
Not sure which Data Integration Tools solution is right for you?

Download our free Data Integration Tools Report and find out what your peers are saying about Informatica, Microsoft, Oracle, and more!

Sign Up with Email