PowerCenter for ETL
May 21, 2016

PowerCenter for ETL

Sadu Kurahatti | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with PowerCenter

Our firm provides consultancy to several federal government clients. Currently we are using Informatica Powercenter for aDHS - USCIS client to perform ETL on daily basis (both initial full load and incremental load) into various data marts. It helps in moving data from one source to another, mainly to a data warehouse to help generate reports.


  • Data migration from multiple sources. It handles any type of source data including RDBMS, flat files, XML, mainframe etc.
  • Implementing data migration rules is very easy and efficient and reusable.
  • Development and maintenance of code is very easy. Design, development and scheduling of full load and incremental load is very easy.
  • Provides lot of features for developers to implement any kind of business rules.


  • Not worth doing simple data migration using powercenter.
  • Licensing cost.
  • Handling Blobs and clobs data types.
  • It has a high ROI.
  • Overall very happy with the product.
  • Very useful in fulfilling business needs.
  1. Powercenter provides lots of features to implement mapping rules.
  2. Very easy to design, develop and maintain ETL code.
  3. Easily integrate with its other products like IDQ and MDM.
PowerCenter is ideal where there is a need to implement complex data migration rules and perform incremental data load. It is very efficient, easy to maintain and modify the code. It is also very efficient in connecting to data sources including XML, Flat files, spreadsheets, RDBMS, mainframe etc.

Informatica PowerCenter Feature Ratings

Connect to traditional data sources
Connecto to Big Data and NoSQL
Simple transformations
Complex transformations
Data model creation
Metadata management
Business rules and workflow
Testing and debugging
Integration with data quality tools
Integration with MDM tools

Using PowerCenter

12 - Information technology - consultancy
10 - ETL developers with Powercenter, SQL development experience
  • Data migration
  • Full Load and incremental load
  • Data warehouse development
  • Implement complex data migration/business rules
  • Clean up data
  • Standardize data
  • Data Quality
  • Data profiling
  • Address Validation
It is a good, efficient product. Lots of developers are easily available in the market to perform the work.


More Reviews of Informatica PowerCenter