Informatica PowerCenter Valuable Features
AT
reviewer1318821
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 »NM
reviewer1094502
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 »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.
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 »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 »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 »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 »GB
reviewer1734582
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 »RK
reviewer1765203
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 »GF
Gully François
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 »DL
reviewer1293765
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 »VS
Vineth Suresh
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 »SK
reviewer1491816
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 »KS
reviewer1498596
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 »MA
reviewer1245828
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 »The most valuable features are the monitoring tools and the reporting manager.
View full review »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.
VN
reviewer1640310
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 »DS
reviewer1643280
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 »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 »KG
reviewer1488372
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 »TV
reviewer1448301
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.
HA
Harisha Acharya
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.
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 »The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.
View full review »DD
reviewer1407579
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.
MG
reviewer1656495
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.