Item: Informatica PowerCenter
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

We used Informatica PowerCenter as an ETL to to feed data into Teradata Data Warehouse that houses all data marts of our company.
Mainly used to process semi-structured and unstructured data like web and mobile logs. It has been well tested against large volume of data and it stood up to the expectations.

Pros and Cons

Informatica Powercenter is an innovative software that works with ETL-type data integration. Connectivity to almost all the database systems.
Great documentation and customer support.
It has a various solution to address data quality issues. data masking, data virtualization. It has various supporting tools or MDM, IDQ, Analyst, BigData which can be used to analyze data and correct it.

It doesn't have much scheduling options and the tool is not very much capable if we schedule more jobs.
Debugging the workflows and mappings are very hard with Informatica PowerCenter.
Lookup transformation on large tables consumes more Memory and CPU.

Return on Investment

Flexible and stability when transforming large amount of data.
Better and robust integration with cloud data warehouse.
We recognized the large project scope and had all stakeholders involved when on-boarding this solution. We had data transformation diagram ready before the implementation work which saved us a tons of potential rework.

Alternatives Considered

Talend Data Integration

Informatica PowerCenter is highly flexible and scalable for different types of data and it has any inbuilt function to transform our data into the meta data structure. Some of the tool sets such as TDM, is good in some ways but need EBF more than often when running into any issue.

Key Insights

Do you think Informatica PowerCenter delivers good value for the price?

Yes

Are you happy with Informatica PowerCenter's feature set?

Yes

Did Informatica PowerCenter live up to sales and marketing promises?

Yes

Did implementation of Informatica PowerCenter go as expected?

Yes

Would you buy Informatica PowerCenter again?

Yes

Other Software Used

MySQL, Oracle Database, Talend Data Integration

Likelihood to Recommend

Informatica Powercenter is the centerpiece of our overall enterprise data warehouse strategy. It's a critical enablement to ensure we can feed in multiple data stream and transform them into digestible data within our data warehouse. With its flexible capabilities and API availability, we were able to feed in industry standard data format as well as home grown data structure. Overall, we are very pleased with their capability and contribution to our data warehouse strategy.

Old yet powerful ETL Tool

Overall Satisfaction with Informatica PowerCenter