Informatica PowerCenter Primary Use Case

Ricardo Pedro
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
We are implementing our master data management integration solution. The idea is to have the data cleaned, and have a catalog set up so that we have a library we can consult to see what type of data is being used. At the same time, have a tool to provide a three hundred and sixty-degree view of our customer data. We will also have a unique repository and a data link that we're setting up in Azure. We will be moving all of our storage to the cloud so that we have a single repository, and this data will be accessible by our tools such as Tableau, for integration with our reporting. Currently, we are in a hybrid-cloud environment, but our intention is to be cloud-based using Azure. View full review »
MohamedKhamis
Data Scientist at IME
ETL ; Extract Transform Load from data base to data warehouse based on specific business rules. View full review »
reviewer1293765
Data Architecture/Management at a consultancy with 10,001+ employees
This product is primarily used with an Oracle product called OBI EE, Oracle Business Intelligence. It is used for integration and data visualization. View full review »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: October 2020.
442,986 professionals have used our research since 2012.
AmanyEldaly
Data Engineer at a tech services company with 51-200 employees
Our primary uses of the solution are for data integration and to build a warehouse model. View full review »
Kirill Slivchikov
Owner at 7Spring Consult
Our primary use case for this solution is at a Russian bank. The goal was to integrate DWH with a banking core system that used Pervasive SQL 2000 DB. The bank as our client in the field of Data Warehousing asked us to extract data from their core banking system and build a Data Mart for preparation of regulatory reports. View full review »
SeniorEtddda
Senior ETL Developer at Office of State Revenue
Our primary use case for Informatica PowerCenter is for insurance and enterprise data warehouse creation. View full review »
reviewer1407579
Associate Director at a consultancy with 1,001-5,000 employees
Our primary use case of this solution is for building data warehouses for clients with data visualization tools. We need to pull data from other sources so we use Informatica as the ETL. The solution is generally deployed on-prem but sometimes on cloud. View full review »
Kamal Bouyanzer
Project Manager at a comms service provider with 1,001-5,000 employees
We primarily use the solution for data integration. View full review »
reviewer1323657
Database Administrator and Applications Specialist at a university with 1,001-5,000 employees
Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was very difficult to connect and integrate with other new applications. We used Informatica to read from our Hospital Information System and transform the data into a relational model in order to speed up reporting and do cleansing of the data. We also used Informatica to integrate SQL Server based applications with our Oracle applications. View full review »
Chiranjeeva Reddy
ETL Reporting Analytics Consultant at Accenture
Our primary use case is to process semi-structured and structured files using business rules to create CSV files for data warehouse loading and reporting. View full review »
reviewer1215849
Senior Associate at a tech consulting company with 1,001-5,000 employees
We use this solution for ETL of a US Law Enforcement agency's data sources to a data warehouse. View full review »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: October 2020.
442,986 professionals have used our research since 2012.