Informatica PowerCenter Valuable Features

YT
Developer, Architect at L'Oreal

What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly.

View full review »
Mohamed Elkady - PeerSpot reviewer
Sr.Manager - Data Management & Data Governance at a tech company with 201-500 employees

To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions.

Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use.

Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle.

View full review »
PS
Analytics Insights - Manager at a consultancy with 10,001+ employees

It's the best ETL tool that one can have.

The initial setup is easy.

It's stable.

We can scale the product.

Support has been helpful in the past.

View full review »
Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,955 professionals have used our research since 2012.
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

They know what they're doing, and it's a more mature tool compared to Talend. They really think about every scenario. For example, if you want to write a data cleansing algorithm and all that is probably rules. It's just easier. There are a lot of provisions in PowerCenter. In terms of the transformation algorithms and all that, there are a lot of operations. It's great.

The solution is stable.

It's a scalable product.

View full review »
HK
Developer and Team Lead at ZIM

The most valuable feature of the solution stems from the fact that it is good for big data, meaning it is a useful tool if there is a need for integration functionalities to manage a huge amount of data. The tool has many functionalities and options. The main valuable features of the product revolve around its flexibility and ability to deal with big data. The tool's components help my company in areas where integrations are required.

View full review »
CC
Senior Oracle Database Administrator at a financial services firm with 1,001-5,000 employees

It is an excellent tool. It covers our needs. 

The solution is used mostly to handle our daily data loads in our data warehouse. We've been successful so far using it. 

It provides monitoring and we can therefore be aware of what is happening when we are handling jobs. 

The ETL and monitoring tools are the most useful for us.

The transformations we need to do, to comply with user requests, is very easy with this product.

The solution is stable.

It can scale. 

View full review »
AE
Enterprise application architect at Ministry of Health

In general, it is a great tool. 

The initial setup is not very complex. 

There are many features available. It has very rich transformation tools. You can have union integration. There are many kinds of set operators, aggregators, and plate operators. 

Graphically you can define a lot, and you can also inject variables too. If you define one transformation, you can replicate it with several sources. 

It has very good monitoring and process monitoring. 

There is an excellent scheduler. 

The integration capabilities are pretty good. 

We've found the solution to be very stable. 

It's a product that scales well.

View full review »
PB
Technical Manager at Agriitex

It has good standard features for ETL development. I mostly like the transformation simplicity, which is very good. It has common features that are very similar to all similar tools.

It is stable and reliable. 

Technical support is good.

View full review »
Katarzyna Palikowska - PeerSpot reviewer
ETL Developer at Det Norske Veritas

The solution has been issue-free overall. 

The traceability has been extremely useful. You can see all of the workflows, and you can trace the data transformation very easily. Each column in the target can be easily traceable, and you easily can see all that data transformation on the path from the source to the target.

The setup is straightforward. 

It's stable.

The solution can scale a bit. 

Technical support is helpful. 

View full review »
CR
Business Intelligence Architect at a manufacturing company with 10,001+ employees

It's very easy to use it to develop mappings and workflows.

View full review »
VS
Senior Associate at PwC Acceleration Centers

The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth. 

View full review »
Lars Borchers - PeerSpot reviewer
Senior BI Backend Developer at ALD Automotive Portugal

The reliability of the product and the way of orchestration of different services is valuable to us. It is a very old tool, so it is a classic solution. Once someone is familiar with it, they would like to use it.

View full review »
SG
Solution Design Expert at a pharma/biotech company with 10,001+ employees

The cloud version is very useful.

The features provided are great.

It is stable and reliable.

Technical support is quite helpful.

The setup is very simple. 

View full review »
AS
Associate Manager at Accenture

Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute.

It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.

View full review »
RR
Practice Head - Advanced Analytics & Cloud at a computer software company with 201-500 employees

It is very robust, scalable, and simple to use.

It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective.

View full review »
VJ
Principal Consultant at Genpact - Headstrong

I found the map links, work links, and workflows valuable. They are important features.

View full review »
MS
Assistant Manager at a insurance company with 10,001+ employees

The solution's most valuable feature is its support service. The support team efficiently resolves any technical issues.

View full review »
Ramesh SV - PeerSpot reviewer
Senior Technical Lead / Practise Architecht at TEKsystems (ex Aston Carter)

The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.

View full review »
Muhammad -Usman - PeerSpot reviewer
Data AI Architect at a comms service provider with 10,001+ employees

Informatica PowerCenter has many features compared to Talend, DataStage, and Airflow. Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application. Also, one won't face issues related to bugs when using Informatica PowerCenter.

View full review »
Mohammad Faizan Ahmad - PeerSpot reviewer
Sr. Technical Associate at Investcorp Bank BSC

PowerCenter performs well during data transformation and optimization. 

View full review »
Parwaz Khan - PeerSpot reviewer
Head of Data Analytics at Bupa Arabia

The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources.

View full review »
RemonHanna - PeerSpot reviewer
Data Engineer at a tech services company with 51-200 employees

The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.

View full review »
Dusanka Mladenovic - PeerSpot reviewer
Data Architect at a financial services firm with 5,001-10,000 employees

This is an old and reliable product. I like the visual tool for data mapping and the workflow manager.

View full review »
Henry Niessen - PeerSpot reviewer
Founder at DEN21DS

I like the completeness of the way I can build ETL workflows. It's not one feature that stands out. Rather, it's the way everything is working together.

On the matter of data lineage and data catalog and metadata, in particular, several new developments are embedded as options you could use or could buy. The modular structure is very helpful.

View full review »
ChandrasekharPetaka - PeerSpot reviewer
VP - Digital at a tech vendor with 1,001-5,000 employees

Informatica PowerCenter is a very good ETL tool. 

View full review »
Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,955 professionals have used our research since 2012.