Informatica PowerCenter Primary Use Case

YT
Developer, Architect at L'Oreal

We have several uses cases for Informatica PowerCenter. We ingest data from different sources, for example, from API or other databases. We also apply data transformations in almost all cases via Informatica PowerCenter, to aggregate the data. We also check the integrity of the data and improve the data quality by applying some rules. We specify and identify all the rules and the methodology to apply the rules. We also participate in rule setting, and also check the test cycles for businesses.

View full review »
Lars Borchers - PeerSpot reviewer
Senior BI Backend Developer at ALD Automotive Portugal

We use the product for everything that's possible in data integration. We have a data warehouse, and we load each stage. We use the product for data exchange and API services. We also use it to load data into cloud platforms and generate Customer Letters.

View full review »
AS
Associate Manager at Accenture

Our company uses Informatica PowerCenter as an ETL tool for data warehouse purposes.

View full review »
Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,319 professionals have used our research since 2012.
MS
Assistant Manager at a insurance company with 10,001+ employees

We use the solution to extract and transform data from various sources into databases. Further, it helps us optimize data using Tableau dashboard to make business decisions.

View full review »
Katarzyna Palikowska - PeerSpot reviewer
ETL Developer at Det Norske Veritas

We are using the on-premises version and are working towards moving into the cloud. I design ETL workflows.

View full review »
PB
Technical Manager at Agriitex

I'm using it in my company, in the sense that some of our clients use it as their tool for their day-to-day development.

View full review »
HK
Developer and Team Lead at ZIM

I use Informatica PowerCenter as the main integration tool in our organization.

View full review »
VS
Senior Associate at PwC Acceleration Centers

Informatica PowerCenter is a data extraction and data loading tool. We extract data from some sources and we load data to different source systems.

View full review »
Ramesh SV - PeerSpot reviewer
Senior Technical Lead / Practise Architecht at TEKsystems (ex Aston Carter)

I am using Informatica PowerCenter as a data integration tool, and for standardization and validations.

View full review »
DC
Director at Lolatech

My experience is in the semiconductor industry with our customers using the Azure supply chain. We have built-in the AIS system, IBM and Db2. We transfer data from SQL Server to MongoDB and transfer the data to Db2.

Security is very important, the solution is deployed to the private cloud. We assigned five people to build the project.

Informatica PowerCenter is built into the technology supply system. I use the solution to transfer the MS data system to the supply chain system.

View full review »
Muhammad -Usman - PeerSpot reviewer
Data AI Architect at a comms service provider with 10,001+ employees

Informatica PowerCenter is purely an ETL tool used for data integration.

View full review »
RR
Practice Head - Advanced Analytics & Cloud at a computer software company with 201-500 employees

Informatica PowerCenter is an ETL data integration platform.

It's all part of the data warehouse's extract, transform, and load process. Data is extracted from all source systems, transformed, and loaded into a data warehouse.

View full review »
CC
Senior Oracle Database Administrator at a financial services firm with 1,001-5,000 employees

We use the solution primarily as an ETL.

View full review »
GF
Computer system engineer at Groupe Casino

I'm working for a casino, and we use this solution in our company to replicate different databases, such as from Oracle to Teradata. Most of the time, it is used for replication, but sometimes, it is also used for doing some calculations, additions, or unions for ETL.

It is currently deployed on-premises, but we will be moving to a cloud solution by the end of the year. We are currently doing a proof of concept and evaluating a cloud solution from Informatica.

View full review »
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

We primarily use the solution for the ETL.

View full review »
GB
Director at a financial services firm with 10,001+ employees

We are generally using it for ETL systems. 

View full review »
SG
Solution Design Expert at a pharma/biotech company with 10,001+ employees

Our company has requirements to move from legacy systems to new cloud systems. This helps migrate the data. We have complex logic and integrations on some of the systems, and Informatica makes migrations possible.

View full review »
Hari Kathireshan - PeerSpot reviewer
Sr PHP Developer at GE

I use this solution for everything from real-time processing to complex, high-volume batch workflows. 

View full review »
RajeevKumar9 - PeerSpot reviewer
Software Test Automation Engineer at Atradius

Informatica PowerCenter is a data integration tool. We use it as an extract, load, transform tool and we can transfer data from production to test or to any other environment.

We have several use cases. For example,  we use it to create data warehouse applications, which are used for analytics and to help generate business value.

Another use case is to modify a test environment such that it is compliant with GDPR regulations. We can use it to transfer production data to a test environment for the purpose of facilitating our testing. Another use case is that if we are working on a data warehouse application, it can be used to extract data from different sources to load into the target environment.

View full review »
MA
CIO at a tech services company with 1,001-5,000 employees

One of my use cases is integrating personnel data from multiple systems.

View full review »
AE
Enterprise application architect at Ministry of Health

The product is primarily used for building the data warehouse as an ETL tool for our hospital.

View full review »
SB
Project Manager at a tech services company with 10,001+ employees

We are a solution provider and this is one of the products that we implement for our clients.

View full review »
Sunil_Shah - PeerSpot reviewer
Senior software developer at a tech services company with 1,001-5,000 employees

We use Informatica PowerCenter primarily for its processes. We derive dashboards, functionalities and graphs with the information it provides. We create reports, generate excels, and data scientists use the information to generate reports in Tableau, Power BI or other tools.

View full review »
AT
Technology Director at a computer software company with 1,001-5,000 employees

We receive the data files from insurance carriers. We load the data, do some processing, and then make the data available to their internal systems. We apply some business transformations and data validations and share the data in the healthcare domain and EDI B2B exchange.

Its version varies based on the customer, but when it comes to the cloud, we have the latest version. We have been using Informatica Intelligent Cloud Services (IICS) for two years. We have used IICS for two purposes. One is for data integration, and the other one is for application integration.

View full review »
VJ
Principal Consultant at Genpact - Headstrong

I am using Informatica PowerCenter to upskill and learn to use new tools.

View full review »
Mohamed Elkady - PeerSpot reviewer
Sr.Manager - Data Management & Data Governance at a tech company with 201-500 employees

Informatica PowerCenter is used for data integration.

View full review »
Parwaz Khan - PeerSpot reviewer
Head of Data Analytics at Bupa Arabia

Informatica PowerCenter is a data integration tool.

View full review »
CR
Business Intelligence Architect at a manufacturing company with 10,001+ employees

We use this solution for regular ETL access. All our warehouses are built through Informatica. We also use Informatica to build data marts.

View full review »
PS
Analytics Insights - Manager at a consultancy with 10,001+ employees

The solution is basically used for anything and everything that we process, for example, from the SQL Server, from other application sources like Oracle, from Flatfiles, or loading into these kinds of sources. We use it for pretty much everything.

View full review »
FN
Principal Associate at Data Meaning, Inc.

In the company I work for, we provide a lot of solutions. I've been working with a lot of clients. The last client I worked with was a big hotel company, and we used this solution for integration.

View full review »
RS
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 »
VN
Technical Lead at a financial services firm with 5,001-10,000 employees

We are using Informatica PowerCenter for our data warehouse to generate reports from heterogeneous data sources from XML, JSON, or CSV databases. We then do some transformations to generate XML ISO standards to send to regulators in Europe and UK.

View full review »
RM
Head of Business Integration and Architecture at Jakala

This solution is really the backbone of what we do. Informatica PowerCenter is one of the most used platforms for data governance in the banking and insurance industry. It's quite expensive so it's not used much outside the industry, but it's very reliable and strong in everything connected to data management and data governance strategy. For our industry, that is crucial. We are customers of Informatica and I'm the head of big data and solution architecture. 

View full review »
RP
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 »
MM
Student at Ontario Ministry of Labour

Our primary use is to implement our data warehouse, including moving data between FTP, flat file and relational databases, and Domain/Integrated Service designs.

View full review »
IB
Service Delivery Manager & Data Governance Consultant at Master Works

Our primary use case is to collect data from different sources and to build it for the house or data hub, or to fill already built-in appliances like Cloudera and Teradata. 

View full review »
Muharrem Iseri - PeerSpot reviewer
Managing Partner at a tech services company with 11-50 employees

Our primary use cases of PowerCenter are database regulatory reporting cases. Both sides are suitable for us to net trace metadata and it's easy to develop or hedge, after production as well. It's also easy to understand the steps or ETL. 

I'm working with the latest update, and it's deployed on-prem. 

View full review »
VS
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees

We use it for data integration. It's a great tool.

View full review »
NM
Principal Consultant at a tech services company with 501-1,000 employees

Informatica PowerCenter is being used for data warehouse development, using ETL and ELT, e.g. Informatica PowerCenter for ETL and Informatica Cloud Data Integration for integration between systems, e.g. with their downstream systems.

View full review »
Dusanka Mladenovic - PeerSpot reviewer
Data Architect at a financial services firm with 5,001-10,000 employees

We use this solution for ETL and data transformation and we are customers of Informatica. 

View full review »
DS
Resource Manager at a computer software company with 1,001-5,000 employees

We use the solution for businesses that wish to analyze their raw data. The solution allows us to do data cleansing and to transform the raw data into useful, insightful information.

View full review »
KG
Associate Manager at a consultancy with 501-1,000 employees

We are using Informatica PowerCenter to process the data of the files in the landing zone. These files contain a huge amount of data, and Informatica PowerCenter is the source for us to push the data to Azure Synapse. We are using its latest version.

View full review »
Kirill Slivchikov - PeerSpot reviewer
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 »
MG
Lead BI&A Consultant at a computer software company with 10,001+ employees

We use this solution for ETL processes.

View full review »
DL
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 »
it_user808662 - PeerSpot reviewer
Works at a tech services company with 10,001+ employees

Data Integration: Integrates heterogeneous source platforms data into the unified data warehouse.

View full review »
it_user1119516 - PeerSpot reviewer
Project Manager at a comms service provider with 1,001-5,000 employees

We primarily use the solution for data integration.

View full review »
AR
Senior Technical Lead at Speridian Technologies

I have worked with Informatica PowerCenter in different companies for different projects.

We use Informatica PowerCenter for ETL. We need it for our data integration project.

View full review »
SS
Senior Software Engineer at Depository Trust & Clearing Corporation

We use it for ETL. We have multiple systems, we extract the data, and create a report from it. 

View full review »
RemonHanna - PeerSpot reviewer
Data Engineer at a tech services company with 51-200 employees

We are using Informatica PowerCenter for data integration in a health insurance company.

View full review »
SK
Senior Architect at a computer software company with 10,001+ employees

We use Informatica PowerCenter to extract the data from legacy products and load it into new applications. We're using it for this purpose only. Apart from that, we use the Data Quality tool for data quality issues. We use this solution to extract and load.

View full review »
MK
Data Scientist at IME

ETL ; Extract Transform Load from data base to data warehouse based on specific business rules.

View full review »
DD
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 »
RS
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 »
AE
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 »
it_user1080720 - PeerSpot reviewer
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 »
SC
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 »
Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
767,319 professionals have used our research since 2012.