IT Central Station is now PeerSpot: Here's why

Informatica PowerCenter Valuable Features

Technology Director at a computer software company with 1,001-5,000 employees

Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. 

Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology.

View full review »
Principal Consultant at a tech services company with 501-1,000 employees

What I like most about Informatica PowerCenter is that it enables integration and connection with multiple new systems, both structured and semi-structured. I also find its adapters for multiple source systems valuable. Its features meet industry standards. It is a proven high-performing enterprise-scale ETL solution.

View full review »
IhabBekhiet - PeerSpot reviewer
Service Delivery Manager & Data Governance Consultant at Master Works

Real time is amazing. If you have AI use cases, you can predict if it's a threat or if it's a positive or negative transaction. You can use real time with PowerExchange to write data directly to Kafka, to consume, write, or parse data using an AI algorithm to detect if the data is positive or negative and to define what use cases you want. 

View full review »
Buyer's Guide
Informatica PowerCenter
June 2022
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
607,178 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 »
Muharrem Iseri - PeerSpot reviewer
Managing Partner at Caligo

One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool. 

View full review »
Franklin Nascimento - PeerSpot reviewer
Principal Associate at Data Meaning, Inc.

It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put it into the packet in a very fast way.

So for this client, we are using the MDM (Master Data Management), and the PowerCenter will be very helpful in building data and merging all the data between the different systems they have. They have a lot of systems that contain the same information and we want to put that into a single place. This is the most valuable feature of this solution which has been of great help to us.

View full review »
RobertoMessora - PeerSpot reviewer
Head of Business Integration and Architecture at Jakala

From my point of view, the solution has two valuable features. It has the ability to manage a huge quantity of data along with a high level of reliability from a performance point of view. Secondly, it has all the tools and features within the platform to establish a real data governance strategy. That includes lineage data preparation, ETL, ELP, everything regarding monitoring and processes that are implemented in the platform. It's quite feature full in that regard.

View full review »
Director at a financial services firm with 10,001+ employees

The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.

View full review »
Software Test Automation Engineer at a insurance company with 1,001-5,000 employees

The most valuable features are that it is quick and easy to use. Anybody can master it in a short time.

The interface is very clean and clear.

This tool integrates with distributed systems.

View full review »
Computer system engineer at Groupe Casino

The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.

Its stability is high, and it is also scalable.

View full review »
Data Architecture/Management at a consultancy with 10,001+ employees

The most valuable features are the metadata repository and the data warehouse application console.

View full review »
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 »
Senior Architect at a computer software company with 10,001+ employees

I like the automated scheduling feature. Suppose we want to automate data anonymization, we have tools within PowerCenter for that. In terms of the capability of data loading features, Informatica products are better.

View full review »
Senior Consultant at a computer software company with 1,001-5,000 employees

It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle.

View full review »
CIO at a tech services company with 1,001-5,000 employees

Once you have learned Informatica, it is very easy to use.

The feedback that I have received from team members is that they found it easy to work with.

View full review »
Saravana Babu - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees

The most valuable features are the monitoring tools and the reporting manager.

View full review »
MohamedFouda - PeerSpot reviewer
Informatica Developer at a computer software company with 51-200 employees

PowerCenter is the market leader, so more organizations use it than other tools. It's a feature-rich solution, so that's why it's at the top of the market.

View full review »
Technical Lead at a financial services firm with 5,001-10,000 employees

We have found the PowerCenter and B2B data transformation most valuable. Additionally, they have many native connectors, high performance, and a lot of support documentation.

View full review »
Resource Manager at a computer software company with 1,001-5,000 employees

Informatica PowerCenter is a very strong tool which offers a host of features. We can use heterogeneous data to easily merge and derive the useful information. Also, flag files processing is very useful.

View full review »
AliRaza1 - PeerSpot reviewer
Senior Technical Lead at Speridian Technologies

It's quite suitable for our needs.

It's a complete package, which is why we use this solution.

We have not had any issues with this solution.

View full review »
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 »
Information Technology Security Analyst at a tech services company with 10,001+ employees

What I like the most is that we have to deal with less while writing the queries.

The unstructured data can now be imported into Informatica PowerCenter. This is an achievement for them.

View full review »
Senior Data Architect at a manufacturing company with 10,001+ employees

We like that it is cloud-based and the performance is good. The number of docs has been reduced drastically, which is very good.

View full review »
SureshSwaminathan - PeerSpot reviewer
Senior Software Engineer at Depository Trust & Clearing Corporation

If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.

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 »
Associate Director at a consultancy with 1,001-5,000 employees

The solution provides good performance with an easy to use interface and reasonable documentation.

View full review »
Lead BI&A Consultant at a computer software company with 10,001+ employees

It has a very good graphical interface.

It has the possibility to intervene in the automatic ETL. 

It has a lot of components. 

It has a Data Catalog that uses the Model repository.

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