Best Software for 2025 is now live!
Show rating breakdown
Save to My Lists
Claimed
Claimed

Top Rated Informatica PowerCenter Alternatives

Informatica PowerCenter Reviews & Product Details

Informatica PowerCenter Overview

What is Informatica PowerCenter?

Informatica PowerCenter® helps you unleash the value of your data. It offers a unique end-to-end data integration platform, with a broad set of capabilities to integrate raw, fragmented data from disparate sources, transforming it into complete, high-quality, business-ready information. As your environment grows and matures, PowerCenter scales to meet your expanding business needs, data volumes, and complexity, while providing insights to IT and the business

Informatica PowerCenter Details
Show LessShow More
Product Description

Informatica PowerCenter is an ETL tool that is used to enterprise extract, transform, and load the data from the sources. We can build enterprise data warehouses with the help of the Informatica PowerCenter. The Informatica PowerCenter produces the Informatica Crop.


Seller Details
Year Founded
1993
HQ Location
Redwood City, CA
Twitter
@Informatica
102,081 Twitter followers
LinkedIn® Page
www.linkedin.com
5,576 employees on LinkedIn®
Ownership
NYSE: INFA
Phone
650-385-5000
Total Revenue (USD mm)
$1,300
Description

Organizations around the world rely on Informatica to realize their information potential and drive top business imperatives. Worldwide, over 5,000 enterprises depend on Informatica to fully leverage their information assets from devices to mobile to social to big data residing on-premise, in the Cloud and across social networks.


Peggy O.
PO
Overview Provided by:
Vice President, Industry Analyst Relations at Informatica

Recent Informatica PowerCenter Reviews

Lakshmi Harika V.
LV
Lakshmi Harika V.Enterprise (> 1000 emp.)
5.0 out of 5
"Informatica PowerCenter Review"
Informatica PowerCenter is a widely recognized data integration tool, known for its robustness and scalability in managing ETL (Extract, Transform,...
Verified User
U
Verified UserEnterprise (> 1000 emp.)
4.5 out of 5
"Onestop ETL Tool, A Classic"
Informatica powercenter has been a classic , it has been in the industry for around 30 years and still is very relavant to the point , provide ever...
Kritika .
K
Kritika .Enterprise (> 1000 emp.)
4.0 out of 5
"ETL Informatica"
Ease of Use, Great Documention explaining exact feature, Great support. easy to Implemnet buisness logic via transformation offered.
Security Badge
This seller hasn't added their security information yet. Let them know that you'd like them to add it.
0 people requested security information

Informatica PowerCenter Media

Informatica PowerCenter Demo - Informatica PowerCenter
Informatica PowerCenter
Informatica PowerCenter Demo - Informatica PowerCenter
Informatica PowerCenter
Informatica PowerCenter Demo - Informatica PowerCenter
Informatica PowerCenter
Answer a few questions to help the Informatica PowerCenter community
Have you used Informatica PowerCenter before?
Yes

85 Informatica PowerCenter Reviews

4.4 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Popular Mentions
The next elements are radio elements and sort the displayed results by the item selected and will update the results displayed.
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
The next elements are filters and will change the displayed results once they are selected.
85 Informatica PowerCenter Reviews
4.4 out of 5
85 Informatica PowerCenter Reviews
4.4 out of 5

Informatica PowerCenter Pros and Cons

How are these determined?Information
Pros and Cons are compiled from review feedback and grouped into themes to provide an easy-to-understand summary of user reviews.
Pros
Cons

Overall Review Sentiment for Informatica PowerCenterQuestion

Time to Implement
<1 day
>12 months
Return on Investment
<6 months
48+ months
Ease of Setup
0 (Difficult)
10 (Easy)
Log In
Want to see more insights from verified reviewers?
Log in to view review sentiment.
G2 reviews are authentic and verified.
Lakshmi Harika V.
LV
Associate
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about Informatica PowerCenter?

Informatica PowerCenter is a widely recognized data integration tool, known for its robustness and scalability in managing ETL (Extract, Transform, Load) processes. Supports a broad range of data sources, including relational databases, flat files, cloud services, and big data platforms. Supports complex transformations with an intuitive, drag-and-drop interface. User friendly and easy to use. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Non-technical users or newcomers to ETL processes may struggle to use the tool effectively without extensive training.his can be a barrier for small to medium-sized businesses with limited budgets. Users may need to supplement PowerCenter with additional tools for modern data engineering needs. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

PowerCenter automates and manages complex ETL workflows with a drag-and-drop interface and pre-built transformations. PowerCenter includes robust data validation, cleansing, and deduplication capabilities. PowerCenter supports real-time data processing through integration with message queues and APIs. Review collected by and hosted on G2.com.

Shyam K.
SK
Senior Systems Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
What do you like best about Informatica PowerCenter?

1.Data integration

2.Creating Mapping in power center designer

3.Create workflows in workflow manager

4.Monitor the workflow in power center monitor.

Informatica is a toll that provides an environment which allows loading of data into centralized location.

It allows the extraction of data from multiple sources, transform of data according to business requirements and load the data into file and relational target. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Required more technical and tool knowledge to implement.

As the tool is not open source, required cash for getting licence.

Debugging might be difficult.

The tool has a steep learning curve and it may take some time for users to become proficient in its use. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

Informatica can reduce the loading constraints issue from source to Target mapping.

Informatica support the features of lookup creating sequence doing validation before loading to the target system which will ease of handling the checkpoint using the tool.

So need to handle separate in db. Review collected by and hosted on G2.com.

Siva Ganesh V.
SV
Associate Trainee
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic Review from User Profile
What do you like best about Informatica PowerCenter?

Scalability,Connectivity,Transformation Capabilities,Workflow Management,Metadata Repository,Performance Optimization Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Complexity,Cost,Resource Intensive,Steep Learning Curve,Dependency on IT,Vendor Lock-in Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

Informatica PowerCenter solves data management challenges by integrating disparate data sources, improving data quality, simplifying integration processes, enabling real-time data integration, ensuring scalability and performance, and facilitating compliance and governance. By addressing these issues, PowerCenter helps organizations streamline data processes, enhance data quality, and derive valuable insights, ultimately leading to better decision-making and improved operational efficiency. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services
UI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about Informatica PowerCenter?

Informatica powercenter has been a classic , it has been in the industry for around 30 years and still is very relavant to the point , provide every possible connector and provides best mapping tools. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

the UI looks very old and sometimes it is very difficult to handle big big mappings as it needs lot of experience Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

it will help you to connect to all your internal/external datsources, transform the data and load to the required destination and helps to clean the data which is needed for data analytics and better decision making. Review collected by and hosted on G2.com.

Kritika .
K
Data Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best about Informatica PowerCenter?

Ease of Use, Great Documention explaining exact feature, Great support.

easy to Implemnet buisness logic via transformation offered. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Debugger need to be enchanced further, Tools becomes slow if you are working across mutiple repository. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

ETL solutions, it provides mutiple connector ODBC and JDBC to connect across mutiple DB and Integrate data across different platforms. Review collected by and hosted on G2.com.

Vaibhav P.
VP
Software Engineer
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about Informatica PowerCenter?

It is a great ETL tool that can ingest data from multiple sources, perform transformations, and then load it to target systems with drag-and-drop options. Different tools are available for monitoring and repository management and workflow designing. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Sometimes it stops responding, and the user interface is not that modern. It isn't easy to work using a touchpad for dragging and dropping, and we need a mouse to work efficiently. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

We are using Informatica PowerCenter to ingest the data from different source systems, which include APIs, flat files and Oracle database. Then we apply various transformations to it and then load the data to an Oracle database. Review collected by and hosted on G2.com.

Chandan T.
CT
Software Engineer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
(Original )Information
What do you like best about Informatica PowerCenter?

It has got a good number of features to make your life easy. You can just drag and drop the components available and create a data pipeline without having to write code manually. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

It could have been made a lot more simpler and other informatica tools such as DSM would have been an inbuilt feature rather than having a different product itself. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

You could use this tools to store your data which is spread accross to a central databases using this tool. Mapping can be created easily to accomodate the several datatypes to make it a single column of certain dataype etc. Review collected by and hosted on G2.com.

PK
Information Technology and Services
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: Organic
(Original )Information
What do you like best about Informatica PowerCenter?

The product is simple and easy to use. It has four different interfaces to create and run workflows. Supports data integration and transformation for multiple relation/non-relational sources. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Very slow. Pricing seems to be very high. Switching between different interfaces becomes a headache. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

I have used Informatica PowerCenter as an ETL tool. Loaded and transformed data from different sources into an Oracle data warehouse. Also, I've used this to extract the data from flat files and other DBs. Review collected by and hosted on G2.com.

RB
Data Engieer
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
What do you like best about Informatica PowerCenter?

User Interface is the best I like about Informatica PowerCenter., any new user can learn this tool in no time along with that the logs are very informative which helps in debugging any issues. Developers find the tool very easy to use with all the tools in their arsenal to transform data with minimum learning curve. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

There are times when the performance of informatica powercenter might not be best when compared to the underlined database., but I have observed in such cases the developers push the entire logic to a database for performance optimization. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

My team can transform data with all the inbuilt transformations available in the tool as per business needs to create an optimized data warehouse which helps our reporting team to create reports with ease. We can create world-class data warehouse with minimum effort using informatica powercenter. Review collected by and hosted on G2.com.

P K.
PK
Business Analyst
Information Technology and Services
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about Informatica PowerCenter?

Data Quality iw maintained throughout the process of ingestion and integration Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

It doesn't have much scheduling options and the toll is not anle to handle much jobs Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

It helps in entire ETL Process with fratures like data integration , ingestion and data delivery Review collected by and hosted on G2.com.