Informatica PowerCenter Reviews

74 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-17 of 17)

Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • In large implementation projects, the biggest contribution of Informatica has been to standardize the way things are done, get everyone across the organization on the same page in terms of what to expect, how long will the data processing takes, what data quality is to be expected, etc.
  • In projects with hundreds of data pipelines, Informatica makes it easy to define data pipelines that can be auto-configured instead of building one for each table. This greatly reduces the development effort and enables flexibility in massive data migration projects.
  • Informatica provides connectors to a multitude of database systems. It's connectors with Redshift, SAP/HANA have gone a notch beyond in order to tailor the data as per the needs of target systems and makes use of their strengths.
  • A negative impact has been that departments across the boards are highly dependent on the Informatica setup to deliver their data. Given the usually large scope of projects, the lead time for delivery of a solution can be significant causing losses, monetary or otherwise.
Read this authenticated review
Gurcan Orhan | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • It works seamlessly with other Informatica products (i.e. Metadata Management, Data Quality).
  • Since data is read and written through the network, when you cannot perform E-LT you'll need more hardware.
  • Good for a multi-user development environment.
Read Gurcan Orhan's full review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Overall, though it can be quite expensive, we’ve gained a lot of positives in both ROI and customer satisfaction with this tool. With the current set-up in a very large company, we can manage the implementation with a single admin and 2 DBA’s, supporting 50+ power users.
  • Any time you can free up trapped data and get it into a functional container for downstream tools, it is a win. PowerCenter lets us do this and a lot more.
  • I think they should give up on the cloud version and stick to PowerCenter as their main offering. The features are just not there on the cloud, and PowerCenter is very robust.
  • I do not care for their customer service. Their first response is always that it's not their fault, so they cannot help. Lots of opportunities to improve there.
Read this authenticated review
Jody Gitchel | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • PowerCenter has been instrumental in being the center of all data movement within the organization.
  • It has also provided a foundation for which re-usability and scalability are the focus.
  • Finding talent with experience and expertise in PowerCenter is far more likely due to its presence and market share.
Read Jody Gitchel's full review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Positive - Easy to maintain processes built in Informatica Power Center.
  • Positive - Rapidly build and deploy ETL data mappings.
  • Positive - Develop the overall workflow process to run all ETL processes for the project.
  • Negative - Informatica Power Center can be a bit expensive, so your application needs to warrant the enterprise support.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Positive - Made managing data pipelining much easier, cheaper, and faster.
  • Because Informatica helps automate ETL workflows, it makes the developer's task much easier by reducing the amount of manual work required.
  • Negative - No support on MacOS means that the business needs to use VMs to work on Informatica. This can be very counter-productive.
Read this authenticated review
Luoming Hou | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Informatica tool set investment overall meets my company's business needs since it ensures our daily business data movements and integrations smoothly.
  • But the maintenance cost and license per CPU model may be a little expensive for small companies.
Read Luoming Hou's full review
Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • The data pipeline automation capability of Informatica means that few resources are needed to pre-process the data that ultimately resides in a Data Warehouse. Once a workflow is implemented, manual intervention is not needed.
  • PowerCenter did require more resources and time for installation and configuration than was expected/planned for.
  • The lack of or minimal support of unstructured data means that newer sources of dynamic/changing data cannot be easily processed/transformed through PowerCenter workflows.
Read this authenticated review
Anonymous | TrustRadius Reviewer
April 06, 2017

Good ETL Platform

Score 8 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Low coding
  • High performance
  • Cross teams for different purpose
Read this authenticated review
Robert Goodman | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Informatica allows us to achieve complex data integration among our systems and into our data warehouse environment. Without this tool in place, hours of manual manipulation would occur to integrate this data and extract it into the appropriate DW solution.
Read Robert Goodman's full review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • In my role at my company I do not have any insight into the ROI we get out of PowerCenter. I do know however that we recently reuped our contract with the company and installed the more recent version of the product (9.6.1) so I would assume that means we get a fairly good return for our money. And it is used extensively as a component of some of our biggest servicing applications, so that would be a nod in its favor as well.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Return on Investment

  • Has been a very powerful tool with respect to EDW loads.
  • Has been a very good tool with integrating data from legacy systems with newer application.
  • Has been good with providing compliance extracts and encrypting the data.
Read this authenticated review

Feature Scorecard Summary

Connect to traditional data sources (15)
9.5
Connecto to Big Data and NoSQL (11)
8.3
Simple transformations (15)
8.7
Complex transformations (15)
8.6
Data model creation (12)
7.4
Metadata management (13)
8.9
Business rules and workflow (15)
8.4
Collaboration (13)
8.7
Testing and debugging (14)
7.8
Integration with data quality tools (12)
8.1
Integration with MDM tools (10)
8.1

About Informatica PowerCenter

Informatica PowerCenter is a metadata driven data integration technology designed to form the foundation for data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.
Categories:  Data Integration

Informatica PowerCenter Technical Details

Operating Systems: Unspecified
Mobile Application:No