We changed our name from IT Central Station: Here's why

Informatica PowerCenter Pros

AT
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 »
Service Delivery Manager & Data Governance Consultant at Master Works
It has helped us monetize.
View full review »
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 »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,208 professionals have used our research since 2012.
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 into the packet in a very fast way.
View full review »
Head of Business Integration and Architecture at Jakala
Can manage a huge quantity of data and provide reliability.
View full review »
GB
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 »
DL
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 »
SK
Senior Architect at a computer software company with 10,001+ employees
I like the automated scheduling feature.
View full review »
KS
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
CIO at a tech services company with 1,001-5,000 employees
Once you have learned Informatica, it is very easy to use.
View full review »

Informatica PowerCenter Cons

AT
Technology Director at a computer software company with 1,001-5,000 employees
Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers.
View full review »
Service Delivery Manager & Data Governance Consultant at Master Works
It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux.
View full review »
Managing Partner at Caligo
PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it.
View full review »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,208 professionals have used our research since 2012.
Principal Associate at Data Meaning, Inc.
It would be good to recreate the entire interface to make it easier for users to build workflows.
View full review »
Head of Business Integration and Architecture at Jakala
Requires an established data center because there is no option for software as a service.
View full review »
GB
Director at a financial services firm with 10,001+ employees
What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that.
View full review »
DL
Data Architecture/Management at a consultancy with 10,001+ employees
The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through.
View full review »
SK
Senior Architect at a computer software company with 10,001+ employees
Support could be better.
View full review »
KS
Senior Consultant at a computer software company with 1,001-5,000 employees
Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help.
View full review »
MA
CIO at a tech services company with 1,001-5,000 employees
The documentation could be improved.
View full review »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
563,208 professionals have used our research since 2012.