Informatica PowerCenter Valuable Features

Ricardo Pedro
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated BI solution. View full review »
MohamedKhamis
Data Scientist at IME
There are two valuable features. The first is the main typical functionality that the PowerCenter gives, that is the ETL. The ETL is able to extract transform load from/to a variety of sources, like Oracle, Microsoft's SQL Server, and Big Data. The second is the capabilities of the GUI interface; drag and drop solution. It's a powerful tool and might be the first ETL tool based on Gartner to extract, transform, and load data operations. View full review »
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 »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
454,950 professionals have used our research since 2012.
AmanyEldaly
Data Engineer at a tech services company with 51-200 employees
The solution is a very helpful product for data integration. The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter. There are multiple transformations for service consumers to publish and use web services as well,In addition to the ability to implement ETL and ELT n a very easy way and finally, you have structured data for use in an integrated business intelligence solution. View full review »
Innodirec67
Director of Innovation & Development Department at a tech services company with 51-200 employees
The solution has the best user interface and it's the most user-friendly of all data integration tools. View full review »
Kirill Slivchikov
Owner at 7Spring Consult
The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of the Amount field (each amount in PSQL 2000 is stored in three different fields). These tasks were solved by using PSQL 2000 Java SDK library imported to Informatica PowerCenter Java Transformation. View full review »
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 »
SeniorEtddda
Senior ETL Developer at Office of State Revenue
The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand. View full review »
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. View full review »
Hassan Emam
Regional Manager at a tech services company with 201-500 employees
The stability of the solution is one of its best features. The user interface is also very good. View full review »
SureshSwaminathan
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 »
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. View full review »
Kamal Bouyanzer
Project Manager at a comms service provider with 1,001-5,000 employees
The performance and design of Informatica have been very valuable. I find the performance faster than, Oracle Data Integrator or DataStage. View full review »
reviewer1323657
Database Administrator and Applications Specialist at a university with 1,001-5,000 employees
Chiranjeeva Reddy
ETL Reporting Analytics Consultant at Accenture
The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files. View full review »
reviewer1215849
Senior Associate at a tech consulting company with 1,001-5,000 employees
The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed. View full review »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
454,950 professionals have used our research since 2012.