Verified User in Financial Services
IF
Verified User in Financial Services
Mid-Market (51-1000 emp.)
"PowerCenter"
4.5/5
What do you like best about Informatica PowerCenter?

Easy to understand modules and interfaces Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

I don't have a dislike, but occasionally, there are clunky processes. Review collected by and hosted on G2.com.

Leah S.
LS
Leah S.
Data Engineer
Enterprise (> 1000 emp.)
"Secure and accurate data migration and integration"
4.5/5
What do you like best about Informatica PowerCenter?

Informatica Powercenter is an innovative software that works with ETL-type data integration, this powerful tool facilitates data migration and the integration of different databases such as SQL Server and Oracle, all this under one interface intuitive and simple to implement, its support system is very efficient and solves errors that occur in a matter of minutes. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

The implementation costs are high and it is probably difficult to acquire for smaller companies, it would be good if the prices are adapted to the needs of the users, besides to when I want to get more functions I have to pay more money which seems to me a negative aspect, I can also say that I dislike it when it slows down, this happens mostly when I try to process a large amount of data. Review collected by and hosted on G2.com.

Verified User in Banking
UB
Verified User in Banking
Mid-Market (51-1000 emp.)
"Superfast and easy to use drag and drop faciliated tool."
4/5
What do you like best about Informatica PowerCenter?

Very easy to learn and fast tool for processing large amount of different types of data. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Sometimes it gets difficult to identify the errors using error log but that clearly depends upon our experience with the tool as well. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care
UH
Verified User in Hospital & Health Care
Enterprise (> 1000 emp.)
"Best ETL tool"
5/5
What do you like best about Informatica PowerCenter?

Integration with Informatica Data quality Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Requires heavy local storage space to store powercenter apps Review collected by and hosted on G2.com.

Verified User in Telecommunications
CT
Verified User in Telecommunications
Enterprise (> 1000 emp.)
"Informatica pc review"
4/5
What do you like best about Informatica PowerCenter?

Ease of transformation understanding and use. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Could be more simple....as it is abit complex for new users. Review collected by and hosted on G2.com.

Verified User in Retail
UR
Verified User in Retail
Enterprise (> 1000 emp.)
"powerful ETL tool"
4.5/5
What do you like best about Informatica PowerCenter?

I am new to ETL development. Learned on Informatica Powercenter. Great resources on transformations. Able to visualize data flows nicely. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

I find it a bit tedious to move between ifnormatica designer, informatica worklow manager and informatica monitor. As well as set up target tables, I would like to have built directly in designer rather than create a table and then link as target source. Review collected by and hosted on G2.com.

DS
Daniel S.
E
Small-Business (50 or fewer emp.)
"Strong Industry choice"
4/5
What do you like best about Informatica PowerCenter?

Widespread documentation. Industry choice. Customer support Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

The user interface feels old. There is no "undo" functionality for the designer Review collected by and hosted on G2.com.

Verified User in Banking
UB
Verified User in Banking
Enterprise (> 1000 emp.)
"Awsome ETL Tool"
4.5/5
What do you like best about Informatica PowerCenter?

I really loved the Extracting, transforming and loading data to and from different databases. Large amount of data can be processed without any hassle. The User Interface is quiet easy and simple to use. It also provides variety of transformation options to manipulate the data. It also supports processing of real-time data. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

It is hard to handle BLOB and CLOB data types. Also, deployment is bit complex. Memory utilization of this tool could be improved to some extent. Review collected by and hosted on G2.com.

Verified User in Banking
UB
Verified User in Banking
Enterprise (> 1000 emp.)
"One short ETL tool for any data warehousing project"
5/5
What do you like best about Informatica PowerCenter?

Informatica Powercenter is widely used as an ETL tool in various big and medium size projects. It can connect to various types of sources like Databases, Flat File, CSV, Excel, XML etc. It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, bigdata which can be used to analyze data and correct it. This is also one of the popular tool for Data Migration project. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Maintenance and version upgrade of tool takes lot of effort. Also, this is not available with a Cloud service provider as SAAS service. Review collected by and hosted on G2.com.

Soumyadip R.
SR
Soumyadip R.
Campus Ambassador
Enterprise (> 1000 emp.)
"Powerful tool for data processing"
5/5
What do you like best about Informatica PowerCenter?

The tool is very user friendly. The best thing is when you work on it and try to save a mapping or something you can easily check whether the process is correct up to that step or not and according to that you can proceed further. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

The visualization might be improved, I mean the interface of that software. They can work on the visualization part to make it more user friendly. One more aspect I want to include that when I work on it sometimes data might be lost for some time due to synchronization issues which may be resolved. Review collected by and hosted on G2.com.