G2 Crowd builds the world's largest business commerce platform fueled by $100M in funding 🚀

Informatica PowerCenter

4.4
(35)

Power Data Integration Tool

Work for Informatica PowerCenter?

Learning about PowerCenter?

We can help you find the solution that fits you best.

Informatica PowerCenter Reviews

Chat with a G2 Advisor
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 37 PowerCenter reviews
LinkedIn Connections
PowerCenter review by Samip H.
Samip H.
Validated Reviewer
Review Source

"I have used informatica powercenter for the last 5 months and I found out it is easy to learn."

What do you like best?

I mostly like working with the informatica designer as it is very easy to get source and targets by connecting to the server. There are variety of transformations available to clean the data and you just have to find the right one.

What do you dislike?

Sometime when I run the workflow and if there are some errors, especially those associated with date time conversion, informatica does not tell you why actually the error occurred. You have to go to the session log and google the error to find more about how to solve it.

Recommendations to others considering the product

If you are considering using a different database management system, such as moving from legacy systems or mainframe to modern RDBMS, you definitely need informatica.

What business problems are you solving with the product? What benefits have you realized?

Mostly I use informatica for data migration from DB2 to MSL Server. Since the new system queries the SQL Server, using informatica has helped us achieve that goal.

Sign in to G2 Crowd to see what your connections have to say about Informatica PowerCenter
PowerCenter review by User in Insurance
User in Insurance
Validated Reviewer
Verified Current User
Review Source

"Solid data integration tool, recommended for enterprise-level integration needs"

What do you like best?

Excellent feature-functionality Good performance Ability to handle large data sets Sizeable talent pool Expensive licencing Poor integration with external source control, testing and release management tools Limited & clumsy handling of EDI (X12) data sets.

The software features role-based tools that support iterative business collaboration and development. Data integration is governed by metadata and the highly efficient ETL engine of the software. Other important features offered by the software include rapid prototyping, instant data profiling, graphical data flows, impact analysis, automated data validation, and efficient distributed processing.

What do you dislike?

Management features of Informatica PowerCenter do not include metadata management.

Recommendations to others considering the product

Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. SQL override allows users to write simple to complex queries inside mapping for performance tuning the load process, pre and post SQL can help control the load process to get desired outputs.Error handling techniques: Informatica provide a suite of options to handle errors. From logging error in database tables to e-mail notifications with log files, to decision/assignment tasks for data control, it can handle error at every stage of workflow. Restart options for batched work-flows.Debugging, is one other feature I found extremely useful. Before running a full load, you can run a subset of data from source-target and check for values generated from logic at every transformation.Informatica provides all the functions indexed in a proper fashion in expressions editor with syntax to allow users to build logic with ease.

What business problems are you solving with the product? What benefits have you realized?

we are very satisafied with Informatica on-Premise powercenter solution. However, we experienced issues with Informatica BDM solution. Informatica did not have enough expertise in handling some of the issues. It had to go to R&D to get fixes.

What On-Premise Data Integration solution do you use?

Thanks for letting us know!
PowerCenter review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Review Source

"Best and convenient ETL tool"

What do you like best?

One of major reason for Informatica etl tool success is its capability of enabling Integration. Informatica also leverage the same integration model. Easy training and tool availability has made easy resource availability for software industry, where else other etl tools are way behind in this aspect. Informatica comes with internal scheduler unlike many other etl tools where one need to use third party scheduler.

What do you dislike?

Transaction rework costs. Cost incurred in implementing new systems.Delays In delivery data to decision maker which has lost many customers due to poor service. It allows to use Persistent cache, which gives you performance boost by saving time in building the lookup while session run but it still takes the same time like a normal lookup for using the lookup data during session runtime.

Recommendations to others considering the product

Yes, definitely go ahead to learn more and more of informatica tool. If planning to play with data, then definitely this is the platform to begin.

What business problems are you solving with the product? What benefits have you realized?

The productivity of the environment. We get more done faster and more repeatably. The Data Profiling tool now has been enhanced with really nice data visualization capabilities to make it far easier and faster to understand your data and it’s relationships. Another addition is 100 free Analyst Tool seats to all editions of PowerCenter. Informatica has been driving agile data integration development based on the idea of a development team made up of a developer and a business analyst.

PowerCenter review by Sandeep T.
Sandeep T.
Validated Reviewer
Verified Current User
Review Source

"Informatica - Power to Information!"

What do you like best?

I have used Informatica for about two years at my previous workplace. It is the best ETL Technology I have used. Some of the features that were very helpful to me

-> Access and ability to read data from multiple sources. Name the type of source and Informatica can read it.

-> The GUI is excellently simple. High on usability if I could say.

-> The expressions are many. I have used other ETL tools and I haven't found as many data manipulation expressions as in Informatica.

-> Ease of creating and using parameters.

-> Informatica PDO makes things so easier and simple to debug for errors or Data manipulations discrepancies.

What do you dislike?

There was no feature that I disliked much.

Sometimes, I would feel to write a simple statement with a aggregation and the filter is all the steps to be done in Informatica necessary. Its a simple SQL Statement.

Recommendations to others considering the product

A definite product to try for the Data Person of the company.

What business problems are you solving with the product? What benefits have you realized?

It was a full fledged project. The project was to measure the success of services. Informatica was primarily used an ETL tool to crunch the data into a database for the relevant metrics.

Some of the befits that we saw -

-> Data residing across various databases and flat files easily synched to a single application layer

-> Easier manipulation of data

-> Faster to learn and implement than SQL

-> Easier and multiple methods of transportation of packages across various environments.

PowerCenter review by Michael R.
Michael R.
Validated Reviewer
Verified Current User
Review Source

"PowerCenter as an on-premise integration and management tool"

What do you like best?

PowerCenter does what it does very well. The support structure, often bemoaned in public, actually works pretty well for me.

What do you dislike?

Price. The cost associated with just implementing the core product is very large. Charging extra for management tools (in-client source control, metdata manager, etc) is untenable for my org. Management of the tool is haphazard without them; we had to "reverse-engineer" the metadata to prevent our developers from digging and digging through endless menus just to determine whether their source definitions exist already, or not.

The built-in scheduler is quite anemic and also required us to use cludgy workarounds.

Team needs to be trained up to it. That's not unique.

Recommendations to others considering the product

Get your table structures, design, architecture, and EA ownership right first.

What business problems are you solving with the product? What benefits have you realized?

Our ETL runs faster thanks in part to better software (bulking and parallelization), but it's not clear how much performance we gained just from a brand new and better table and workflow design.

We are able to run our ETL multiple times per day to provide an integrated look into the University's admissions and registration stats.

PowerCenter review by Victor C.
Victor C.
Validated Reviewer
Review Source

"Synonymous with ETL"

What do you like best?

> Informatica power center is probably the most powerful ETL tool I have ever used

> It is potent enough to be used as a standard enterprise ETL tool

> It supports a rich functions library and a host of different tools to prepare and cleanse the data according to your need

> You can also use informatica power center to create reusable mappings called "mapplets", these mapplets are a real convenient way of using a transformation logic again and again

What do you dislike?

> When you create a mapping in powercenter you also have to use 2 other tools to create the workflow and to run or schedule it

> Informatica can be slow at times

> Unlike other smaller competitors in the market informatica does not integrate well with the native datasets of various analytical tools like tableau, spotfire, qlikview etc

Recommendations to others considering the product

> Consider using this tool if you process large amounts of data, to be specific if you have setup a data warehouse this might be an ideal tool for you

> Powercenter can solve any data related processing starting from cleansing to transforming the data and loading it to any leading RDBMS system.

> Do not use this tool if you want to process data for quick analysis using a BI tool

What business problems are you solving with the product? What benefits have you realized?

> We use Informatica as an enterprise ETL tool

> It helps us run batch data updates in the form of data migration from SAP to teradata systems

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"I have 8 Years of experience with Informatica Tool "

What do you like best?

It has lot of features to adopt the necessity of business . It is very fast and accurate. Metadata repository for the organization's ETL ecosystem.

What do you dislike?

Lack of functionality compared to other tools or things that might be improved:

Lack of a possibility to do loops within informatica workflows.

Parameter files handling. The concept of using a parameter file is ok, however it would be nice to be able to dynamically set parameters during runtime. Editing the parameter file for each run is rather painful. This would be very helpful especially for development/testing phase.

It's not possible to run a single session within a worklet. Sometimes, again especially for testing/development, it's handy to just run sessions one by one. It's ok in workflows but why it's not possible within worklets ?

Recommendations to others considering the product

It's best and fast ETL tool with Cloud computing in the market.

What business problems are you solving with the product? What benefits have you realized?

Business day to day data . Effective reporting .

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"For all your data needs - Informatica"

What do you like best?

A powerful tool which can be used to integrate/access various data sources.

Supports various data sources like Relational Sources, FlatFile, XML etc.

What do you dislike?

Have to pay very huge money to buy this software.

Need to pay additional amount if i want to get any additional plugins.

Recommendations to others considering the product

Definitely recommend this product to other customers. But considering the price, I feel it bit more expansive than other software.

What business problems are you solving with the product? What benefits have you realized?

We are using Informatica to integrate various sources.

Loading data very easily. A powerful tool used to extracts tons of data.

PowerCenter review by User in Computer Software
User in Computer Software
Validated Reviewer
Review Source

"Review on Informatica Power center"

What do you like best?

It is easy to use and probably the best ETL tool I have worked on. It is very convenient to create reusable and non reusable task depending on the user needs.

What do you dislike?

There are few bugs in the tool which can be fixed. It is slow in sometimes.

Recommendations to others considering the product

If the source data is huge then Informatica is preferable to use as it is unnecessary to purchase if your company has small data when we compare with pricing for relative ETL tools. You can get the visual pictures of metadata, data flow and throughput within no time.

What business problems are you solving with the product? What benefits have you realized?

We use it as ETL tool. It helps in cleansing the source data very easily and load into target table. To remove unnecessary data in source data so that process can be fastened.

PowerCenter review by Niranjan S.
Niranjan S.
Validated Reviewer
Review Source

"The best ETL tool ever!"

What do you like best?

Informatica PowerCenter is my go to solution for any ETL need. It is flexible, easy to understand and easy to maintain. It is easier to debug and absolutely simple to build any logic you have in mind. The security is very straight forward which avoids unnecessary confusions and saves time to concentrate on developing and testing the applications. The command line comes to rescue when you need to create a custom solution. Deployment groups and simple XML migration saves time and energy during migrations. The inbuilt version control saves lots of time when something is modified by mistake. The ETL templates for SCD saves time and avoids complexity by providing a simple method to implement complex SCDs.

What do you dislike?

Though the tools is reliable compared to other tools like ODI, frequent crashes, screen hang causes troubles. One notable issue is when you try to change the domain name in Informatica Workflow monitor-impossible to change!

Recommendations to others considering the product

Simple interface, easy to learn, use and administer.

What business problems are you solving with the product? What benefits have you realized?

Any ETL problem can be handled by Informatica, I work with a very big EBS implementation and developing a data warehouse was so easy with Informatica, Earlier we were considering Oracle's ODI but later realized the flexibility which was readily available in Informatica was missing in ODI.

PowerCenter review by Samrat M.
Samrat M.
Validated Reviewer
Verified Current User
Review Source

"Informatica Powercentre : A Leader in the Data Migration tools stack like no other."

What do you like best?

Informatica, unlike other vendors like Oracle do not believe in 'reinventing the wheel' when it comes to enhancements: old features are backward compatible and new ones are intuitive to use to the familiar user. one of the best features of Informatica and a dream come true for most Informatica Developers and Designers is its ability to visually model the business process whose data it is trying to transform. This means process models developed in industry standard BPMN can be modelled to exact specification mappings in Informatica and with its robust debugger engine, it serves as the best visual tool to visualise each and every data transformation when you need to get those data sign-offs in complex data integrations. Hence code development is more agile and prototyping is faster and more robust.

Code Migration and Version Control in Informatica are pretty robust too and the process works out of the box with its excellent code labelling and version history system with minimal configuration! Add to this the excellent error handling capabilities of its workflow monitor and you have a data migration platform that works best for you and the business.

What do you dislike?

In the Product per se, the Informatica Powercentre suite needs a stronger ETL(Extract Transform Load) orchestration tool that is as intuitive as the Oracle Datawarehouse application console(DAC). Informatica allows orchestration of workflows to a certain extent but needs to come up with more level of control on table related tasks that speed up the ETL like dropping and recreating indexes. Informatica can do these activities by calling procedures in pre and post sql actions but the tasks are not very visibly monitored on its work flow monitor.Nevertheless, the session logs on the monitor do keep a record of these tasks.

Recommendations to others considering the product

Before falling into the sales pitch of ETL tools set by Oracle or IBM(Data Stage), consider this: Informatica has been the market leader for Enterprise Data Migration for the last couple of years(more than 5 years as a Leader in this sector on the Gartner Magic Quadrant). If this statistic does not impress you, consider its ability to make robust prototypes, efficient ETL Engine, strong debugging and error handling capabilities plus a version control and code migration system that simply works out of the box and you got a winner in the Data Migration tools space that will make your investment worthwhile over the years!

What business problems are you solving with the product? What benefits have you realized?

We are using Informatica to make complex data transformations from multiple source systems using complex business process flows that reflect the convergence of CRM(Customer Relationship Management) systems and Financial systems right from when the Customer represents an opportunity for business to the point when he holds assets from our business as a result of the Customer journey.

PowerCenter review by Nelson E.
Nelson E.
Validated Reviewer
Verified Current User
Review Source

"A true ETL Tool"

What do you like best?

Easy to use even for those that are new to a new ETL tool. Ability to integrate to Cloud solutions. Easy to learn and design and troubleshot. Very reliable on a Unix environment.

What do you dislike?

It needs to incorporate more features in the Standard Edition. All Standard edition is lacking was custom built and integrated with the tool

What business problems are you solving with the product? What benefits have you realized?

Daily production report and key executive information through Informatica as a data integration tool.

Informatica is the main ETL tool to integrate into the EDW and therefore it is a critical tool

PowerCenter review by Praveen K.
Praveen K.
Validated Reviewer
Review Source

"Informtica Power center Review"

What do you like best?

Informatica is a Best ETL tool,User freindly and selef descriptive.

we have different kind of transformation which helps us to Load the data in desired format.

What do you dislike?

Informatica having so many sub tools like designer,workflow designer and monitor

Recommendations to others considering the product

It is best ET tool to work on ,tool is contains all transformation to cleans and lload the data

What business problems are you solving with the product? What benefits have you realized?

Informatica helps us to cleanse the data which are coming from different sources like flat file,database etc.

PowerCenter review by User in Non-Profit Organization Management
User in Non-Profit Organization Management
Validated Reviewer
Verified Current User
Review Source

"As good as it gets"

What do you like best?

I like the fact that Informatica is solely focused on ETL and they set the industry standard that other tools try to reach.

What do you dislike?

Not much to dislike about the product except the way some of the things are arranged and organized. This is a small price to pay for the unbeatable stability and unparalleled performance.

Recommendations to others considering the product

This is as good as it gets. The only option I would recommend is to look at the Cloud version as it offers additional functionality that the on premise version does not. Not to mention the fact that all the tools are headed to the cloud.

What business problems are you solving with the product? What benefits have you realized?

We are trying to solve enterprise ETL functionality and are realizing very consistent performance that we do not see with other products.

PowerCenter review by Jomin V.
Jomin V.
Validated Reviewer
Verified Current User
Review Source

"The Perfect Data Integration Tool"

What do you like best?

It's so easy to develop data integration mappings using Informatica Power Center. It can be used to access data from heterogeneous source file systems. So easy to maintain.

What do you dislike?

Developers are provided with very limited access.

Recommendations to others considering the product

A product that will help to save millions of development cost.

What business problems are you solving with the product? What benefits have you realized?

Currently we use Informatica Power Center to integrate data from TV Nielsen and various digital platforms like Hulu, FoxNOW & VOD. The cost of data integration has been reduced a lot because it is so easy to provide business solutions using this tool.

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Informatica power center"

What do you like best?

Tool is very user friendly and you have very flexible features.

each and every component or transformation is so deltailed that you can use it easily and help content is so detailed that eit will explain each and every step.

scheduling the jobs are very easy and you can rely on sceduling jobs.

informatica is a repository bases so each and every transaction is saved.

What do you dislike?

This run one job many components needs to be created like mapping session and worflow

Recommendations to others considering the product

Informatica power center is a best tool,you start loving it when you start using it

What business problems are you solving with the product? What benefits have you realized?

DAta transmisssion from dource system to warehouse

PowerCenter review by Consultant in Research
Consultant in Research
Validated Reviewer
Verified Current User
Review Source

"Informatica power center 9.6.1"

What do you like best?

Debugger option in PowerCenter designer and ease of using IPC and easy to generate SQL statements as you no need to worry in writing huge sequel statements with IPC you can do it easily and effectively.

What do you dislike?

There are still bugs in the tool which are to be fixed like tracing problem while running multiple workflows.

What business problems are you solving with the product? What benefits have you realized?

I usually load the flat file data that comes everyday at particular time to database Target table and transposing the given set of data using informatica normalizer transformation. IPC is an easy and convenient tool to extract transform and load the source data into target.

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Medium size Project"

What do you like best?

It is one of the best segment of the tools that worked. It is among the best in the market and is very well regarded by all professionals who know her. The best feature of the tool is in my opinion the performance. Very good with large volumes of data.

What do you dislike?

Like other tools framework for integration of large volumes of data, it has a layered architecture that is not very simple for any industry analyst begin to develop. It requires little learning time.

Recommendations to others considering the product

Deve ser considerada sempre para um projeto de integração. Líder de mercado.

What business problems are you solving with the product? What benefits have you realized?

I worked with integration between two databases to a system upgrade.

PowerCenter review by Vishal S.
Vishal S.
Validated Reviewer
Review Source

"great tool for data integration"

What do you like best?

Ease of using tool, flexibility and durability, adaptibility gives an edge compare to other Data integration tools.

What do you dislike?

I don't have anything which I dislike about the power center tool.

What business problems are you solving with the product? What benefits have you realized?

Doing data integration for the client using interfacing with multiple systems.

PowerCenter review by Kushal R.
Kushal R.
Validated Reviewer
Review Source

"Its great working with informatica things get so easy."

What do you like best?

The versatility is a big plus, you can basically work with any kind of structured data source: flat files, most of the databases.

What do you dislike?

One thing i don't like is you have to close and open the folders to see the changes reflected.

What business problems are you solving with the product? What benefits have you realized?

Informatica is great for ETL it makes working with data so much easier. There is everything available for everyone.

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Using this product since 2006 as an ETL developer/Architect "

What do you like best?

easy to use, reliable. lot of features. can be connected to any type of source (xml, flat file, mainframe, rdbms -Oracle etc).

Rapid development.

Integration with other products like IDQ.

What do you dislike?

error message documentation is not correct or enough to debug issues.

Recommendations to others considering the product

Highly recommend this product for ETL related work

What business problems are you solving with the product? What benefits have you realized?

Data migration -- Full load and incremental load with lots of transformation rules.

A new system is being developed with new data model which will be populated with three existing systems.

PowerCenter review by Naresh K.
Naresh K.
Validated Reviewer
Verified Current User
Review Source

"Informatica by far is the most user friendly and advanced ETL tool"

What do you like best?

the user interface, diversity in its products to achieve anything related to data integration etc

What do you dislike?

too many products with overlapping features

What business problems are you solving with the product? What benefits have you realized?

data integration, quality & master data management

PowerCenter review by Consultant in Oil & Energy
Consultant in Oil & Energy
Validated Reviewer
Verified Current User
Review Source

"Leader in Data Integration"

What do you like best?

Informatica offers integration with wide range of databases and enterprise application integration with a interface helping easy to support and sustain application.

What do you dislike?

Need seamless job scheduling with dependency flexibility like control or autosys scheduling

What business problems are you solving with the product? What benefits have you realized?

Integrate data from wide range of source for enterprise integration and business decision support system..

PowerCenter review by Amol G.
Amol G.
Validated Reviewer
Review Source

"Best ETL tool for data integration and master data management"

What do you like best?

Informatica Power center tool for data integration

What do you dislike?

Does not show data when it flows from different components.

What business problems are you solving with the product? What benefits have you realized?

High volume data llad

PowerCenter review by User in Marketing and Advertising
User in Marketing and Advertising
Validated Reviewer
Review Source

"One of the simplest ETL tool available in the market!"

What do you like best?

1.) Reliability and easy to learn

2.) It can integrate any type of data, data format from any data source

3.) Integrates well with oracle and teradata

What do you dislike?

1.) Custom built tools used to enhance functionality are not readily available

2.) It frequently crashes and the very often the screen gets stuck

Recommendations to others considering the product

Simple interface, worth a trying the 30 day free trial, easy for both user and administrator

What business problems are you solving with the product? What benefits have you realized?

Better performance: able to run Multiple huge scale data integration and data warehousing projects can be executed

PowerCenter review by Omprakash G.
Omprakash G.
Validated Reviewer
Review Source

"Datawarehouse ETL Developer with Informatica DI PowerCenter Certification (ICS Exam 9.x)"

What do you like best?

The complete tool architecture and client tools for the developers.

What do you dislike?

Version comparison utility and debugger can be improved.

What business problems are you solving with the product? What benefits have you realized?

Making data available for reporting from varieties of data sources into single data warehouse that further helps in taking business decisions.

PowerCenter review by Vijay Purna M.
Vijay Purna M.
Validated Reviewer
Review Source

"The best ever ETL tool - Informatica PowerCenter"

What do you like best?

Can implement anything using Informatica PowerCenter

Easy and Flexible to use.

What do you dislike?

I do not have any to mention.

I like all the features which are included in Informatica PowerCenter.

What business problems are you solving with the product? What benefits have you realized?

Solving and processing all providers in Insurance area.

PowerCenter review by Nikhil P.
Nikhil P.
Validated Reviewer
Review Source

"Informatica Power Center Review"

What do you like best?

- GUI based Power Data Integrator

- Best in class with tight integration with industry leading databases like Oracle & Teradata

- Always leading with cutting edge features like JSON webservice support, CDC, Cloud, Data Virtualization

What do you dislike?

- No unified approach to sharing best practices via Informatica portals. Each client & system integrator has own set of best practices/standards

- Custom built tools to enhance Informatica functionality by Informatica Professional Services are not readily/easily available

Recommendations to others considering the product

- Conduct a Proof Of Concept

- Budget for Informatica Professional Services resources in your project planning

What business problems are you solving with the product? What benefits have you realized?

- Multiple Large scale data integration and data warehousing projects executed using Informatica PWC

PowerCenter review by User in Insurance
User in Insurance
Validated Reviewer
Review Source

"Easy to use and way more flexible"

What do you like best?

Easy to use and flexible professional and lots of options and compatibility

What do you dislike?

sometimes its a bit complex with database drivers

What business problems are you solving with the product? What benefits have you realized?

its used to load the data ETL , it will handle large amount of data from multiple sources

PowerCenter review by Consultant
Consultant
Validated Reviewer
Review Source

"Data warehouse analyst"

What do you like best?

Dataware house is best stl tool and we have many positions to explore

What do you dislike?

Nothing is there from my end to dislike it

What business problems are you solving with the product? What benefits have you realized?

Through olap system we can give data to end users to do forecast their business

PowerCenter review by Seth M.
Seth M.
Validated Reviewer
Review Source

"Informatica PowerCenter"

What do you like best?

Ease of use through visualization. It's as easy as gathering your requirements and then mapping it out.

What do you dislike?

Without a 3rd party tool, scheduling a series of workflows to run on a set schedule can be difficult to manage.

Recommendations to others considering the product

Take advantage of demos that are offered through vendors.

What business problems are you solving with the product? What benefits have you realized?

By upgrading and implementing Informatica PowerCenter, we are able to retire old ETL tools/systems. Informatica handles the big data more efficiently than the old tools, which benefits the business by saving time and resources.

PowerCenter review by Industry Analyst / Tech Writer in Retail
Industry Analyst / Tech Writer in Retail
Validated Reviewer
Review Source

"Great product"

What do you like best?

Will highly recommend this product , it makes charting, reporting very easy, with various building blocks needed to generate exec reporting

What do you dislike?

The tool sometimes take some hands on learning in the initial stages to get accustomed to.

What business problems are you solving with the product? What benefits have you realized?

reporting, retail analytics, data science

PowerCenter review by User in Higher Education
User in Higher Education
Validated Reviewer
Review Source

"Occasionally use for fast ETL development"

What do you like best?

Powerful tools, get results very quickly with full functionality

What do you dislike?

Too many features, easy to make wrong choices if you don't know what you are doing

Recommendations to others considering the product

One of the best data integration tools out there in the market today.

What business problems are you solving with the product? What benefits have you realized?

Discover data quickly for timely data delivery

PowerCenter review by Consultant in Insurance
Consultant in Insurance
Validated Reviewer
Review Source

"Informatica PowerCenter Review"

What do you like best?

User - friendly and easy to use and better features

What do you dislike?

They should not come up with many products rather they should concentrate on existing products to improve the quality.

What business problems are you solving with the product? What benefits have you realized?

Data warehouse - Warehousing data from different sources and presenting to the business

PowerCenter review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source

"Best ETL tool"

What do you like best?

Informatica can connect to multiple databases without any issues

What do you dislike?

Needs more tools and more transformations. Also need performance tuning.

What business problems are you solving with the product? What benefits have you realized?

Etl requirements.

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source
Business partner of the vendor or vendor's competitor, not included in G2 Crowd scores.

"SF Trip experience"

What do you like best?

I like most product Performance and also it's flexibility.

What do you dislike?

we need to train the consultants with a long time before starting the projects

What business problems are you solving with the product? What benefits have you realized?

the business problems we are solving nowadays are mainly focus in extraction, load and transformation issues

PowerCenter review by Consultant in Information Technology and Services
Consultant in Information Technology and Services
Validated Reviewer
Review Source

"Strong DI product"

What do you like best?

Great features. Tight Metadata integration. Ease of use

What do you dislike?

Pipeline architecture. No control flow (for example loops)

Recommendations to others considering the product

Research. Google is your friend

What business problems are you solving with the product? What benefits have you realized?

Use it to load data warehouses for large enterprises

Kate from G2 Crowd

Learning about Informatica PowerCenter?

I can help.
* We monitor all Informatica PowerCenter reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.