--- title: Informatica PowerCenter Reviews meta_title: 'Informatica PowerCenter Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 90 reviews by the users' company size, role or industry to find out how Informatica PowerCenter works for a business like yours. aggregate_rating: rating_value: 4.3 review_count: 90 scale: '5' date_modified: '2026-07-17' parent_category: name: Data Integration Tools url: https://www.g2.com/categories/data-integration-tools --- # Informatica PowerCenter Reviews **Vendor:** Informatica **Category:** [On-Premise Data Integration Software](https://www.g2.com/categories/on-premise-data-integration) **Average Rating:** 4.3/5.0 **Total Reviews:** 90 ## About 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 Pros & Cons **What users like:** - Users value the **automation** capabilities of Informatica PowerCenter, simplifying ETL processes and minimizing manual coding requirements. (3 reviews) - Users appreciate the **ability to integrate data from multiple sources** with Informatica PowerCenter, enhancing their data management efficiency. (3 reviews) - Users value the **easy-to-use interface** of Informatica PowerCenter, simplifying ETL processes without extensive coding requirements. (3 reviews) - Users appreciate the **user-friendly interface** of Informatica PowerCenter, making ETL processes simple and efficient. (2 reviews) - Users appreciate the **drag and drop feature** of Informatica PowerCenter, making ETL processes intuitive and user-friendly. (2 reviews) - Users appreciate the **easy integrations** of Informatica PowerCenter, enabling seamless connectivity with various data sources. (2 reviews) - ETL Efficiency (2 reviews) - Features (2 reviews) - Integrations (2 reviews) - Intuitive (2 reviews) **What users dislike:** - Users find Informatica PowerCenter to be **expensive** , burdened by high licensing and maintenance costs alongside complex infrastructure needs. (2 reviews) - Users experience **integration issues** with Spark and Python, complicating setups and limiting functionality in cloud environments. (2 reviews) - Users face challenges due to **cloud dependency** , hindering integration and scalability in modern environments. (1 reviews) - Users find the **complexity of accessing workflow parameters** cumbersome, impacting their overall experience with PowerCenter. (1 reviews) - Users find **complex management** burdensome due to high costs, resource demands, and lack of cloud integration support. (1 reviews) - Complex Usability (1 reviews) - Data Limitations (1 reviews) - Difficult Setup (1 reviews) - High Licensing Cost (1 reviews) - Lacking Features (1 reviews) ## Informatica PowerCenter Reviews ### 1. Good ETL Tool **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Automotive | Enterprise (> 1000 emp.) **Reviewed Date:** July 01, 2019 **What do you like best about Informatica PowerCenter?** It has been very reliable. We have had very little downtime in our production environment because the platform is so stable. **What do you dislike about Informatica PowerCenter?** We dislike having to install thick client software in order to view running workflows and design them. **What problems is Informatica PowerCenter solving and how is that benefiting you?** We are able to transfer data between our Oracle and Microsoft databases easily. ### 2. For all your data needs - Informatica **Rating:** 4.0/5.0 stars **Reviewed by:** Arun K. | Senior Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 19, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** Definitely recommend this product to other customers. But considering the price, I feel it bit more expansive than other software. **What problems is Informatica PowerCenter solving and how is that benefiting you?** We are using Informatica to integrate various sources. Loading data very easily. A powerful tool used to extracts tons of data. ### 3. Does Informatica Powercenter have Future ? **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 08, 2019 **What do you like best about Informatica PowerCenter?** Easy of learning and understanding for new person **What do you dislike about Informatica PowerCenter?** Adaptability to cloud and big data is slow **What problems is Informatica PowerCenter solving and how is that benefiting you?** Data Migration, Data Integration ### 4. It was easy to use and develop **Rating:** 4.0/5.0 stars **Reviewed by:** Amankumar A. | Mobile Application Developer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 06, 2019 **What do you like best about Informatica PowerCenter?** various tools in it, which makes workflow development easy. **What do you dislike about Informatica PowerCenter?** If the PC configuration is not good, then it lags a lot **What problems is Informatica PowerCenter solving and how is that benefiting you?** Used it to solve the data sparse over different databases and accumulated it in one database using different transformations. It helped in building reports on top of centralized data. ### 5. Best tool in market for data integration **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 08, 2019 **What do you like best about Informatica PowerCenter?** Informatica Powercenter provides the real time data integration services Its highly intuitive and customizable that speeds up the development process It comes with full suit of data management components including data integration, data quality, data governance etc Seamless integration with informatica MDM and data masking tools **What do you dislike about Informatica PowerCenter?** Its a bit costly compared to other cheaper alternatives **Recommendations to others considering Informatica PowerCenter:** Its a great tool, definitely recommended **What problems is Informatica PowerCenter solving and how is that benefiting you?** Data Integration ### 6. I have used informatica powercenter for the last 5 months and I found out it is easy to learn. **Rating:** 4.0/5.0 stars **Reviewed by:** Samip H. | Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 09, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 7. Best and convenient ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** August 09, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 8. Solid data integration tool, recommended for enterprise-level integration needs **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** January 02, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** Management features of Informatica PowerCenter do not include metadata management. **Recommendations to others considering Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 9. Easy to use and way more flexible **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** October 11, 2018 **What do you like best about Informatica PowerCenter?** Easy to use and flexible professional and lots of options and compatibility **What do you dislike about Informatica PowerCenter?** sometimes its a bit complex with database drivers **What problems is Informatica PowerCenter solving and how is that benefiting you?** its used to load the data ETL , it will handle large amount of data from multiple sources ### 10. Informtica Power center Review **Rating:** 3.5/5.0 stars **Reviewed by:** Praveen K. | Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** March 12, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** Informatica having so many sub tools like designer,workflow designer and monitor **Recommendations to others considering Informatica PowerCenter:** It is best ET tool to work on ,tool is contains all transformation to cleans and lload the data **What problems is Informatica PowerCenter solving and how is that benefiting you?** Informatica helps us to cleanse the data which are coming from different sources like flat file,database etc. ### 11. Informatica power center **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 01, 2018 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** This run one job many components needs to be created like mapping session and worflow **Recommendations to others considering Informatica PowerCenter:** Informatica power center is a best tool,you start loving it when you start using it **What problems is Informatica PowerCenter solving and how is that benefiting you?** DAta transmisssion from dource system to warehouse ### 12. Review on Informatica Power center **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** December 20, 2017 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** There are few bugs in the tool which can be fixed. It is slow in sometimes. **Recommendations to others considering Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 13. Best ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** July 22, 2018 **What do you like best about Informatica PowerCenter?** Informatica can connect to multiple databases without any issues **What do you dislike about Informatica PowerCenter?** Needs more tools and more transformations. Also need performance tuning. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Etl requirements. ### 14. great tool for data integration **Rating:** 5.0/5.0 stars **Reviewed by:** Vishal S. | Technical Team Lead/Consultant, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 28, 2018 **What do you like best about Informatica PowerCenter?** Ease of using tool, flexibility and durability, adaptibility gives an edge compare to other Data integration tools. **What do you dislike about Informatica PowerCenter?** I don't have anything which I dislike about the power center tool. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Doing data integration for the client using interfacing with multiple systems. ### 15. Best ETL tool for data integration and master data management **Rating:** 4.0/5.0 stars **Reviewed by:** Amol G. | Senior Principal Consultant, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2018 **What do you like best about Informatica PowerCenter?** Informatica Power center tool for data integration **What do you dislike about Informatica PowerCenter?** Does not show data when it flows from different components. **What problems is Informatica PowerCenter solving and how is that benefiting you?** High volume data llad ### 16. The Perfect Data Integration Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Jomin V. | Senior Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** April 11, 2017 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** Developers are provided with very limited access. **Recommendations to others considering Informatica PowerCenter:** A product that will help to save millions of development cost. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 17. Informatica - Power to Information! **Rating:** 4.5/5.0 stars **Reviewed by:** Sandeep T. | Supply Chain Analyst, Telecommunications, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** A definite product to try for the Data Person of the company. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 18. Synonymous with ETL **Rating:** 3.5/5.0 stars **Reviewed by:** Victor C. | BI Consultant for Workforce Insight, Sporting Goods, Enterprise (> 1000 emp.) **Reviewed Date:** August 11, 2016 **What do you like best about Informatica PowerCenter?** > 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 about Informatica PowerCenter?** > 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 Informatica PowerCenter:** > 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 problems is Informatica PowerCenter solving and how is that benefiting you?** > 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 ### 19. I have 8 Years of experience with Informatica Tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 21, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** It's best and fast ETL tool with Cloud computing in the market. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Business day to day data . Effective reporting . ### 20. Medium size Project **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 31, 2016 **What do you like best about Informatica PowerCenter?** It is one of the best segments of the tools that worked. It is among the best in the market and is very well regarded by all professionals who know it. The best feature of the tool, in my opinion, is the performance. Very good with large volumes of data. **What do you dislike about Informatica PowerCenter?** Like other tools and frameworks for integrating large volumes of data, it has a layered architecture that is not very simple for any industry analyst to begin developing with. It requires little learning time. **Recommendations to others considering Informatica PowerCenter:** It should always be considered for an integration project. Market leader. **What problems is Informatica PowerCenter solving and how is that benefiting you?** I worked with integration between two databases for a system upgrade. ### 21. A true ETL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Nelson E. | Manager, Business Intelligence and Vendor Management, Health, Wellness and Fitness, Enterprise (> 1000 emp.) **Reviewed Date:** June 21, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** It needs to incorporate more features in the Standard Edition. All Standard edition is lacking was custom built and integrated with the tool **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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 ### 22. Its great working with informatica things get so easy. **Rating:** 4.5/5.0 stars **Reviewed by:** Kushal R. | Associate, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** October 22, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** One thing i don't like is you have to close and open the folders to see the changes reflected. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Informatica is great for ETL it makes working with data so much easier. There is everything available for everyone. ### 23. Informatica power center 9.6.1 **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Research | Enterprise (> 1000 emp.) **Reviewed Date:** August 04, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** There are still bugs in the tool which are to be fixed like tracing problem while running multiple workflows. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 24. As good as it gets **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Non-Profit Organization Management | Enterprise (> 1000 emp.) **Reviewed Date:** May 29, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** We are trying to solve enterprise ETL functionality and are realizing very consistent performance that we do not see with other products. ### 25. PowerCenter as an on-premise integration and management tool **Rating:** 3.5/5.0 stars **Reviewed by:** Michael R. | Data Warehouse Administrator, Higher Education, Mid-Market (51-1000 emp.) **Reviewed Date:** January 05, 2016 **What do you like best about Informatica PowerCenter?** PowerCenter does what it does very well. The support structure, often bemoaned in public, actually works pretty well for me. **What do you dislike about Informatica PowerCenter?** 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 Informatica PowerCenter:** Get your table structures, design, architecture, and EA ownership right first. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 26. Great product **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Retail | Enterprise (> 1000 emp.) **Reviewed Date:** January 04, 2017 **What do you like best about Informatica PowerCenter?** Will highly recommend this product , it makes charting, reporting very easy, with various building blocks needed to generate exec reporting **What do you dislike about Informatica PowerCenter?** The tool sometimes take some hands on learning in the initial stages to get accustomed to. **What problems is Informatica PowerCenter solving and how is that benefiting you?** reporting, retail analytics, data science ### 27. The best ETL tool ever! **Rating:** 5.0/5.0 stars **Reviewed by:** Niranjan S. | Consultant, Management Consulting, Enterprise (> 1000 emp.) **Reviewed Date:** January 12, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** Simple interface, easy to learn, use and administer. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 28. Leader in Data Integration **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Oil & Energy | Enterprise (> 1000 emp.) **Reviewed Date:** August 01, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** Need seamless job scheduling with dependency flexibility like control or autosys scheduling **What problems is Informatica PowerCenter solving and how is that benefiting you?** Integrate data from wide range of source for enterprise integration and business decision support system.. ### 29. Occasionally use for fast ETL development **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** August 25, 2016 **What do you like best about Informatica PowerCenter?** Powerful tools, get results very quickly with full functionality **What do you dislike about Informatica PowerCenter?** Too many features, easy to make wrong choices if you don't know what you are doing **Recommendations to others considering Informatica PowerCenter:** One of the best data integration tools out there in the market today. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Discover data quickly for timely data delivery ### 30. Informatica Powercentre : A Leader in the Data Migration tools stack like no other. **Rating:** 5.0/5.0 stars **Reviewed by:** Samrat M. | Data Integration / Datawarehousing Specialist, Enterprise (> 1000 emp.) **Reviewed Date:** May 19, 2015 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** 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 problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 31. Using this product since 2006 as an ETL developer/Architect **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 07, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** error message documentation is not correct or enough to debug issues. **Recommendations to others considering Informatica PowerCenter:** Highly recommend this product for ETL related work **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 32. Informatica by far is the most user friendly and advanced ETL tool **Rating:** 4.5/5.0 stars **Reviewed by:** Naresh K. | Solutions Designer, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 07, 2016 **What do you like best about Informatica PowerCenter?** the user interface, diversity in its products to achieve anything related to data integration etc **What do you dislike about Informatica PowerCenter?** too many products with overlapping features **What problems is Informatica PowerCenter solving and how is that benefiting you?** data integration, quality & master data management ### 33. One of the simplest ETL tool available in the market! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** January 14, 2016 **What do you like best about Informatica PowerCenter?** 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 about Informatica PowerCenter?** 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 Informatica PowerCenter:** Simple interface, worth a trying the 30 day free trial, easy for both user and administrator **What problems is Informatica PowerCenter solving and how is that benefiting you?** Better performance: able to run Multiple huge scale data integration and data warehousing projects can be executed ### 34. The best ever ETL tool - Informatica PowerCenter **Rating:** 5.0/5.0 stars **Reviewed by:** Vijay Purna M. | Senior Associate, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 12, 2016 **What do you like best about Informatica PowerCenter?** Can implement anything using Informatica PowerCenter Easy and Flexible to use. **What do you dislike about Informatica PowerCenter?** I do not have any to mention. I like all the features which are included in Informatica PowerCenter. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Solving and processing all providers in Insurance area. ### 35. Datawarehouse ETL Developer with Informatica DI PowerCenter Certification (ICS Exam 9.x) **Rating:** 4.0/5.0 stars **Reviewed by:** Omprakash G. | IT Analyst, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 05, 2016 **What do you like best about Informatica PowerCenter?** The complete tool architecture and client tools for the developers. **What do you dislike about Informatica PowerCenter?** Version comparison utility and debugger can be improved. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Making data available for reporting from varieties of data sources into single data warehouse that further helps in taking business decisions. ### 36. Strong DI product **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** March 07, 2016 **What do you like best about Informatica PowerCenter?** Great features. Tight Metadata integration. Ease of use **What do you dislike about Informatica PowerCenter?** Pipeline architecture. No control flow (for example loops) **Recommendations to others considering Informatica PowerCenter:** Research. Google is your friend **What problems is Informatica PowerCenter solving and how is that benefiting you?** Use it to load data warehouses for large enterprises ### 37. Informatica PowerCenter Review **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** January 12, 2016 **What do you like best about Informatica PowerCenter?** User - friendly and easy to use and better features **What do you dislike about Informatica PowerCenter?** They should not come up with many products rather they should concentrate on existing products to improve the quality. **What problems is Informatica PowerCenter solving and how is that benefiting you?** Data warehouse - Warehousing data from different sources and presenting to the business ### 38. SF Trip experience **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** September 17, 2015 **What do you like best about Informatica PowerCenter?** I like most product Performance and also it's flexibility. **What do you dislike about Informatica PowerCenter?** we need to train the consultants with a long time before starting the projects **What problems is Informatica PowerCenter solving and how is that benefiting you?** the business problems we are solving nowadays are mainly focus in extraction, load and transformation issues ### 39. Informatica PowerCenter **Rating:** 4.0/5.0 stars **Reviewed by:** Seth M. | BI Team Lead, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** May 20, 2014 **What do you like best about Informatica PowerCenter?** Ease of use through visualization. It's as easy as gathering your requirements and then mapping it out. **What do you dislike about Informatica PowerCenter?** 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 Informatica PowerCenter:** Take advantage of demos that are offered through vendors. **What problems is Informatica PowerCenter solving and how is that benefiting you?** 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. ### 40. Informatica Power Center Review **Rating:** 4.5/5.0 stars **Reviewed by:** Nikhil P. | Performance and Security Architect Lead, Consumer Goods, Enterprise (> 1000 emp.) **Reviewed Date:** March 03, 2014 **What do you like best about Informatica PowerCenter?** - 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 about Informatica PowerCenter?** - 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 Informatica PowerCenter:** - Conduct a Proof Of Concept - Budget for Informatica Professional Services resources in your project planning **What problems is Informatica PowerCenter solving and how is that benefiting you?** - Multiple Large scale data integration and data warehousing projects executed using Informatica PWC ## Informatica PowerCenter Discussions - [What is Informatica PowerCenter used for?](https://www.g2.com/discussions/informatica-powercenter-what-is-informatica-powercenter-used-for) - 1 comment - [View Informatica PowerCenter pricing details and edition comparison](https://www.g2.com/products/informatica-powercenter/reviews?page=2§ion=pricing&secure%5Bexpires_at%5D=2026-07-29+12%3A46%3A40+-0500&secure%5Bsession_id%5D=479d653c-c618-4aa2-8a9a-a9a106a8cd62&secure%5Btoken%5D=8a025bc9f20f7ae39e14c5eb645cbd2c875ddd00876ba7776b2deb2e43330da1&format=llm_user) ## Informatica PowerCenter Features **Administration** - Database Management - Access Control - Data Security **Management** - Reporting - Auditing **Functionality** - Data visualisation - Data transformation - Data migration - Process various formats - No-code functionality - Data manipulation - Analytics - Reporting **Federation** - Architecture - Provisioning - Orchestration - API / Integrations **Functionality** - Extraction - Transformation - Loading - Automation - Scalability **Transformation** - Data Visualization - Application Performance - Data Modeling ## Top Informatica PowerCenter Alternatives - [Pentaho Data Integration](https://www.g2.com/products/pentaho-data-integration/reviews) - 4.3/5.0 (17 reviews) - [AWS Glue](https://www.g2.com/products/aws-glue/reviews) - 4.3/5.0 (194 reviews) - [Alteryx](https://www.g2.com/products/alteryx/reviews) - 4.6/5.0 (852 reviews)