Informatica PowerCenter Reviews

I have worked with Informatica PowerCenter for almost six years. My usual use cases for Informatica PowerCenter involve creating multiple mappings that include loading SCD dimensions and facts, along with loading some transaction data from different files, APIs, or message queues to tables.

The most valuable features of Informatica PowerCenter that I have found so far include transformations, the ease of connectivity with different source systems, and the parameter files. These features are a huge help, along with the target load mappings.

The target load mappings are valuable because there are many times when I have to load one target system or one pipeline before loading the other when there's some data dependency, and in that case, a target load plan helps. PowerCenter's ETL functionalities have made the entire data flow and data pipeline creation very easy in my organization. Apart from this, I can create reusable mappings or maplets, and reusable maplets or components help speed up the processes.

A reusable workflow helps, as we can use the components in multiple scenarios, meaning a reusable maplet or sometimes mappings help to reuse the components by changing the session parameters, using the parameter file, or with other adjustments. We can work with the same mapping for multiple similar use cases, and pipeline integration has actually aided in integrating the pipelines.

Sometimes, I see various performance issues with Informatica PowerCenter, including caching concerns, whether it's a joiner transformation or other transformations, so I believe the team can enhance the performance perspectives of these transformations. Additionally, sometimes the Informatica Monitor hangs or takes time to open the current run or logs, which the team can also look into.

Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

I have worked with Informatica PowerCenter for almost six years.

The stability and reliability of Informatica PowerCenter are commendable, as the product is very stable with very few issues encountered in production, and I can rely on it without any doubt.

Informatica PowerCenter is scalable; if I speak about an on-premise system, increasing the CPU capability leads to faster performance. In the cloud, scaling up and down becomes easy when working with cloud providers.

I have occasionally needed to communicate with the technical support of Informatica PowerCenter, especially when raising cases for complex mappings and performance optimization to identify bottlenecks in transformations.

Based on my experiences with technical support, I would rate them an eight out of ten for helpfulness.

I don't have any specific improvements in mind for the technical support of Informatica PowerCenter; nothing needs changing.

Positive

I have worked on Informatica PowerCenter in my last organization, and I changed my organization from Fidelity International to Nagarro at the end of July. At Fidelity International, I primarily worked with Informatica PowerCenter.

Informatica PowerCenter was earlier deployed on-premise, but since support for it is being phased out, the organization is pushed to migrate to Informatica Cloud, which is more expensive.

We have over 10,000 data mappings and many other things in place, and the return on investment from using Informatica PowerCenter is significant, as the system built on this tool creates the backbone of some applications. It also plays a vital role in revenue calculations, net asset valuations, and other key factors that support customer data and investment data pipelines.

Informatica is transitioning to cloud solutions and discontinuing on-premise support after 2026, so when we discuss Informatica Cloud and its support, it becomes quite expensive for the organization compared to peers such as SnapLogic or Netezza, which offer lower pricing. Informatica Cloud Intelligence's pricing is notably high.

In my firm, I am a customer of this tool, as they have taken the licenses.

I have used Informatica PowerCenter internally in my company. The admin part is not problematic, and once Informatica server systems are set up on the Unix box, we have this dashboard, manager, and admin setup, facilitating easy integration with different systems.

PowerCenter is used extensively, with a lot of mappings and workflows across the entire organization. There are multiple teams and domains utilizing PowerCenter, resulting in many mappings for individual domains or applications.

On a scale of one to ten, I rate Informatica PowerCenter a seven.

During my internship, I worked for a pharmaceutical client where I used Informatica PowerCenter for extracting data and loading it into other tools. In my internship, I loaded the data into Informatica MDM, but in my current project, I am using Informatica PowerCenter and loading the data into Oracle SQL Developer and also GCP BigQuery.

One of the workflows I can recall recently is that I am presently working for a restaurant client. We have sales data that we receive daily. Once we get the end-of-day site closure for every site, we receive the sales data from SQL Server, which is our source. From Informatica PowerCenter, we have one workflow named INS010 Duplicate Record, which removes all the duplicates. It is a data validation and data cleansing workflow in Informatica that has multiple sessions. The sessions run simultaneously, and the workflow executes to remove all the duplicates. These duplicate records are then entered into Oracle SQL Developer, which is our final target table.

Some other scenarios I can recall are that we have some replication jobs that back up the data. If there is any crash or if we need historical data from the past five years, we can easily extract the data from there. There are also some replication jobs built into Informatica PowerCenter.

The development process improved significantly once we switched to Informatica PowerCenter. Before, we used SnapLogic IPaaS tool, where around ten to fifteen developers were needed to create the same workflows, but when we switched to Informatica PowerCenter, the number of people reduced to half. Five to six developers are more than enough to create the same workflows.

One of the best features I appreciate about Informatica PowerCenter is that anyone with minimal knowledge of ETL can easily use it. It has four different interfaces: Monitor, Repository, Designer, and Workflow Manager. With our use case, we can easily go to that particular interface and use it. Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload.

Informatica PowerCenter has positively impacted my organization because, as I mentioned previously, the development team has been reduced to half since we moved to it due to its easy interface and the reusability of Mapplets. It has also saved us a lot of time; for example, it has saved nearly one hour per day on monitoring and workflow tasks.

Saving one hour a day is key because it has led us to report the data to business users one hour earlier than the usual time. If there are any anomalies or defects in the data, we can easily rectify them within that hour, which reduces the chance of errors in the data. Regarding cost, the number of people working on the project has been reduced to half, thus significantly decreasing costs for our organization since we moved to Informatica PowerCenter.

The pricing of Informatica PowerCenter is somewhat high compared to other tools that provide almost the same features, and there are some advanced tools in the market right now. I think Informatica needs to adapt to those changes.

One limitation I can mention is that sometimes it crashes, and we need to reboot the server to get Informatica PowerCenter running again. I think the crashing and freezing of Informatica PowerCenter need to be addressed.

I have been using Informatica PowerCenter for more than one year.

The security is good because we have access level security to give only developer access or only read-only access to the user, ensuring that the workflows cannot be changed. The security is very high in Informatica PowerCenter, and I have never experienced any crashes, but sometimes there are server crashes that have been rectified immediately.

Mostly, I have never experienced any issues with the software, but occasionally we do experience some server issues. We experience crashes sometimes, but mostly it is stable.

Recently, we have scaled the Informatica PowerCenter storage. The process is smooth, and we have not faced any issues before or after scaling.

We can easily scale the memory and also the workflows.

I have never reached out directly to customer support, but the documentation provided by Informatica PowerCenter and the website is enough to rectify the errors we encounter. The documentation is thorough, and anyone with minimal knowledge of ETL can easily understand it and work through errors.

The documentation is sufficient for our needs.

Along with Informatica PowerCenter, I am also using GCP DAGs and SnapLogic IPaaS. Comparatively, in terms of working and user interface, Informatica PowerCenter leads among them.

The return on investment is very good, as I previously mentioned, because the development team has been reduced to half, and it has saved us around one hour per day since we switched to Informatica PowerCenter.

Since we wanted an ETL tool, we checked the market, and Informatica PowerCenter was already at the top, so we did not evaluate any other options.

Anyone with previous ETL knowledge will easily understand Informatica PowerCenter. However, for those with a less technical background in ETL, I advise them to go through the documentation first, then understand it, and use the tool. I would rate my overall experience with this product as an eight out of ten.

The Advanced Transformation capabilities in Informatica PowerCenter are particularly useful.

Informatica PowerCenter supports data governance and compliance requirements from my side, but I haven't worked extensively on the metadata management and data governance aspects of it.

Informatica should add functions related to low-code, no-code generation. We are actually exploring some AI-powered technologies/applications that can generate readily usable, plug and play code. With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations, enabling automatic code generation for productivity improvements.

Positive

My main use case for Informatica PowerCenter is to start a workflow, to schedule workflows, and basically, I'm using it for orchestration. I can give you a specific example of a workflow I've scheduled or orchestrated with Informatica PowerCenter; one of the workflow's names is DEH, which is an OTC job that runs every day and provides users with several files. Informatica PowerCenter is used to schedule some workflows, and for example, there are several PUS jobs that run daily, and we also trigger them from Informatica PowerCenter. Some of the jobs, Costco and Walmart as well as Ingram, are some of the vendors from which we load data through PowerCenter.

Regarding how I'm using Informatica PowerCenter with vendors, we are using it to schedule jobs on a weekly basis for some vendors, while for others, we load files on a daily basis, so we use it on a regular basis.

Informatica PowerCenter has positively impacted our organization over the last 5.5 years, and the outcome is that we are working very closely with our client on this tool, enabling us to orchestrate any workflow that we are receiving or is newly enabled. It's very easy to add a workflow, and it's a highly trusted tool.

I can tell you that there are measurable improvements since using Informatica PowerCenter; time is saved considerably due to the automation of the workflow, and the communication has improved as our client receives email notifications about whether the workflow has started or not. My team, as the operations team, can interact with the client on a daily basis. It is a very handy tool, so we like it a lot.

The best features that Informatica PowerCenter offers include its user-friendly interface, allowing us to easily schedule and unschedule tasks and add various servers to it. It is very useful as far as the UI is concerned, and it has many different windows as well. Informatica monitors can be used to monitor the jobs that we run, and if there is any kind of failure, we can diagnose it right away.

The monitoring tools in Informatica PowerCenter have helped me, and there was an instance when I ran a workflow that is used to run a file, but I hadn't downloaded or uploaded the TIMEX file, so that workflow didn't trigger right away. It was showing on the monitor, so I checked why I wasn't getting any email for that workflow. I could check on the monitor that the job is running, but it doesn't give any kind of email. That's how I can check that the monitor is working properly or not.

Informatica PowerCenter has various features, including a separate workflow monitor which we can use to monitor the tasks, whether they are scheduled or non-scheduled, if they are running or paused, and we can abort them if there is any kind of issue. Additionally, we can add various other repositories, so if one of the repositories is not connected, we can uncheck it and check another repository to trigger or schedule a workflow, which is a very cool feature.

Informatica PowerCenter can be improved by integrating features that allow scheduling a workflow more easily on the main window itself, and also, I miss the ability to connect to several repositories at the same time; if that's possible, it would be very handy.

Other than that, I feel very good using this tool, but these are some improvements I see that you may consider as feedback.

I have been using Informatica PowerCenter for 5.5 years.

Informatica PowerCenter is very stable in my experience; we have not encountered any downtime or major issues, and we are getting 100% uptime every day.

The scalability of Informatica PowerCenter is tremendous because we can install it on any of our employees' systems, and it handles each and every task very swiftly. This software has very good scalability.

We haven't faced any issues with Informatica PowerCenter yet, so we haven't interacted with customer support; however, I can foresee that the customer support will be very good if we need any help.

Positive

We haven't used any solution apart from Informatica PowerCenter, but this is one of the tools we have been using for the last few years.

I have seen a return on investment with Informatica PowerCenter, and I can share that the investment we have made is tremendous; it has saved a lot of time and effort, and fewer people are needed.

My experience with pricing, setup cost, and licensing for Informatica PowerCenter is that it was integrated with our client, so we haven't paid for it; our client had paid for this tool.

Before choosing Informatica PowerCenter, we haven't chosen or evaluated any other options because we were very clear with our basic needs and requirements, so Informatica PowerCenter fulfilled our needs.

My advice to others looking into using Informatica PowerCenter is that if they need a very good to advanced software that will handle all their workflows and tasks, this is a very handy tool because we can trigger and always integrate it with other software. Informatica PowerCenter is one of the leading tools in the market, and I would give it a 10 out of 10 if they would like to use it for their organization. I would rate this product 9 out of 10.

Neutral

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

The reliability of the product and the way of orchestration of different services is valuable to us. It is a very old tool, so it is a classic solution. Once someone is familiar with it, they would like to use it.

The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.

I have been using the solution for eight years.

I haven’t faced any stability issues with the product.

When we want to scale up with more CPUs, we have to extend the license or shift to a new server with better CPUs.

I have used Dataflow, Azure Data Factory, SSIS from Microsoft, and Oracle Data Integrator, but not intensely. Compared to Dataflow and Data Factory, ways for developing source-to-target mappings are more in PowerCenter. Data Factory is bound by the ways defined by Microsoft. PowerCenter provides more flexibility to do it.

The setup is a very easy, automated process.

We have an automated solution to deploy things. We have to label objects and execute the process in the environment in which we want to deploy the solution. The solution does not require much maintenance. We have to upgrade the solution. Otherwise, we would run into a lot of security breaches.

The license model is CPU based.

If a newcomer works with the solution, it's a difficult solution to use. There are so many details that we have to find to understand what's possible to do with it. We would need help from our seniors. Otherwise, it's very hard to find all those features. Overall, I rate the solution an eight out of ten.

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

The most valuable feature of the solution stems from the fact that it is good for big data, meaning it is a useful tool if there is a need for integration functionalities to manage a huge amount of data. The tool has many functionalities and options. The main valuable features of the product revolve around its flexibility and ability to deal with big data. The tool's components help my company in areas where integrations are required.

The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive.

In the future, there will be a need to develop the product's features related to integrations with APIs. Nowadays, the most popular integration features that products offer are mostly related to cloud-based areas. When users want to fetch data from the cloud and not do it with the help of an on-premises model, then how to deal with the part involving JSON format is something I want to be made available in the product's future releases.

Though I have experience with Informatica PowerCenter, my team members work specifically with it more than me.

It is a stable and trustworthy solution. Stability-wise, I rate the solution a nine out of ten.

I use the product in my company, which is in the business of shipping containers.

Presently, I don't see the product's scalability features since our company works with it, but any changes or improvements in our environment with the use of the existing tool that is installed have been seen. I have not experienced any changes recently in our environment with the use of the tool.

Three people from my team work with the product in my company.

My company does not plan to increase the use of the solution.

I rate the technical support a nine out of ten.

Positive

My company uses several tools for integration purposes.

There is a very strong side of usage in our company when it comes to Informatica PowerCenter. Informatica PowerCenter is good for B2B, while there are other tools my company uses to manage in-house integrations. In our organization, we use several types of integration tools, and it all depends on the targets of the users.

The product's initial setup phase is very easy.

I rate the initial setup phase a nine on a scale of one to ten, where one is a difficult setup process, and ten is a very easy setup phase.

The solution is deployed on an on-premises model.

The product's deployment process in our company doesn't take much longer to be completed since it is an easy process to prepare the object to be deployed. The product can be deployed in a few hours.

The licensing charges of the tool are expensive.

I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price.

I recommend the tool to those who plan to use it, but there might be certain disadvantages attached with the product in the areas of pricing and its integration capabilities with APIs.

I rate the overall tool an eight out of ten.

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

What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly.

What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing.

Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution.

What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved.

I've been using Informatica PowerCenter for ten years now.

Informatica PowerCenter is a stable product. For example, last year my team applied some hotfix to resolve some problems, but it's very rare to experience problems from the solution.

As we work on on-premise environments and the environments are fixed, we're unable to check how scalable Informatica PowerCenter is.

Informatica PowerCenter provides good client support. My team got in touch with support when there was an issue with the solution, and the Informatica PowerCenter support team communicated how to install the hotfix, and the issue was solved.

On a scale of one to five, I'm rating support a four. I didn't give it a five because sometimes, support isn't that qualified in terms of explaining the product and the problem. Informatica PowerCenter support is available, though. For example, I've worked with the support team last year, and I received a call two hours after opening the ticket. The support team answers quickly, but what can take time is understanding and explaining the problem and the solution. Sometimes, it could take three or four days before the problem is resolved because after working on the ticket, it would be escalated to another team, and so that takes time.

The initial setup for Informatica PowerCenter is complex, especially if you don't have a lot of experience with the solution. The deployment could take one day to complete, but in more sophisticated environments, it could take a week, so it depends.

We implemented Informatica PowerCenter through an in-house team.

The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good.

In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution.

On a scale of one to five, I'm rating its price a three.

I've evaluated Azure, Talend, and Data Exchange, but I found Informatica PowerCenter to be better than others. It's just that Informatica PowerCenter needs to have more progress on the cloud side.

I'm an expert on Informatica and some cloud integration tools, such as AWS and Azure.

I have experience with Informatica PowerCenter, Informatica PowerExchange, and also some data quality and master data management tools.

I'm currently using version 10.4 of Informatica PowerCenter.

The solution is deployed on-premises, but I also have experience with its cloud version.

Informatica PowerCenter requires maintenance because you have to take care of the environment, clean the logs, and check some CPU metrics, for example, the memory. The solution also requires some maintenance, for example, you need to restart it when the service is down, so maintaining it uses up your time.

You can have a team dedicated to Informatica PowerCenter maintenance, but that depends on the client. Some clients have dedicated teams for it, while some ask that you take care of the maintenance of the solution.

My team has ten people working on Informatica PowerCenter, but I do know that other teams work on the solution as well, particularly in integration, but I don't have information on how many Informatica PowerCenter users those teams have.

My advice to anyone looking into implementing the solution is to work on it or develop step by step. You also need a good concept to develop complex flows and mapping. You need to develop and test simultaneously to safely deliver good mapping and good products for your clients. You have to test. You have to invest in testing.

I'd rate Informatica PowerCenter seven out of ten.

Informatica PowerCenter is basically used for data integration and ETL processing, data extraction from different heterogeneous sources, and putting that data into different relational databases.

PowerCenter has proven to be the most beneficial for our data integration tasks. Informatica PowerCenter provides multiple transformations in one particular toolset. You don't need to apply any coding. 

Those transformations are the most valuable thing in Informatica PowerCenter, which helps to do the data integration part easily.

Error handling capability:

Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify the errors. 

In addition, there are KB articles, which are published by Informatica, that are really helpful. Even if you face any issues or errors, we can resolve that issue. 

If the error is not at all possible to solve with Informatica PowerCenter, we can raise a case with Informatica, and their support team helps us to address that particular issue. If it is not possible to solve with that particular version, they consider it and try to solve it with the next patch or hotfix.

AI Capabilities:

Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool, which doesn't have any significant role in the field. It is just an ETL on-premise tool. 

Basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud). Their AI comes into the picture there, but for Informatica PowerCenter, AI doesn't come into the picture at all.

Instead of using SQL queries, Informatica PowerCenter is very helpful when extracting data from multiple sources. That is one of the valuable things. 

Other than that, we can do multiple transformations in Informatica PowerCenter.

For data integration tasks, Informatica PowerCenter provides multiple transformations in one toolset. You don't need to apply coding or other things. The transformations are the most valuable thing in Informatica PowerCenter, which helps to do the data integration part easily.

I have had performance issues with this product. When I deal with very large amounts of data, performance issues arise.

Improvement is needed in terms of some new transformation because API integration and all those things are very critical nowadays. Some level of transformation, new transformation, if they introduce that, would be helpful, other than that, the performance and scalability related things that they need to improve. 

If they are launching another Informatica PowerCenter with a new version, I'm not sure about it because they are promoting IDMC, they are not promoting Informatica PowerCenter.

I've been working in Informatica PowerCenter for around eight plus years.

It is an on-premise environment, so it's not as scalable as compared to Informatica Cloud.

There are around ten-plus developers and around four administrators using this product.

The approximate volume of data we process varies from project to project; on average, it is eight to nine gigabytes of data.

I have experience in Informatica Cloud, IDMC (Informatica Data Management Cloud), Azure Data Factory, and a little bit of Fivetran.

Informatica PowerCenter is a very robust tool. You can implement any kind of complex business logic with it. However, Informatica PowerCenter is a very traditional ETL tool that came into the market very early in the 2000s. They have a very good hold on the market and are able to handle all the complex data problems and business data integration use cases.

Whereas, other tools that came new into the market are less complicated to learn, execute, and create data pipelines. But sometimes, I feel that if some complex business problems arise, then we need to jump into the coding part. And there are not as many transformations available.

The initial setup is not at all easy. Setting up PowerCenter is not at all easy, especially when you are installing your server on Linux machines. It's very complicated, especially the upgrade part, if it is a multi-node cluster environment with high availability.

I would recommend using it. But currently all things are moving to the cloud. Informatica PowerCenter is a little bit lagging behind, and now everybody is moving to the cloud.

So, Informatica itself is promoting the use of IDMC and cloud instead of Informatica PowerCenter. But some clients, like banking and pharmaceutical clients, still prefer traditional on-premises ETL tools. So, in that case Informatica PowerCenter is definitely one of the best and unbeatable tools for enterprises.

Overall, I would rate the solution an eight out of ten.

Informatica PowerCenter is basically used for data integration and ETL processing. It extracts data from different heterogeneous sources and loads that data into different relational databases.

Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. 

In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. 

If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix.

AI Initiatives:

Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. 

It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.

It is very helpful when extracting data from multiple sources instead of using SQL queries. That is one of the valuable things. Other than that, we can do multiple transformations in Informatica PowerCenter.

For data integration tasks, Informatica PowerCenter provides multiple transformations in one toolset. You don't need to apply coding or other things. The transformations are the most valuable thing in Informatica PowerCenter, which helps to do the data integration part easily.

When I deal with very large amounts of data, there have been performance issues.

For improvement, some new transformations for API integration, as that is very current nowadays. If they introduce some level of transformation or new transformation, that would be helpful.

Other than that, Informatica needs to improve in performance-related and scalability-related things. If they are launching another Informatica PowerCenter with a new version, I'm not sure about it because they are promoting IDMC (Informatica Data Management Cloud) and not promoting Informatica PowerCenter.

I have been working in Informatica PowerCenter for around eight plus years.

It is an on-premise environment, so it's not as scalable as compared to Informatica Cloud.

There are around ten-plus developers and around four administrators using this product.

The approximate volume of data we process varies from project to project; on average, it is eight to nine gigabytes of data.

I have experience in Informatica Cloud, IDMC (Informatica Data Management Cloud), Azure Data Factory, and a little bit of Fivetran.

Informatica PowerCenter is a very robust tool. You can implement any kind of complex business logic with it. However, Informatica PowerCenter is a very traditional ETL tool that came into the market very early in the 2000s. They have a very good hold on the market and are able to handle all the complex data problems and business data integration use cases. 

Whereas, other tools that came new into the market are less complicated to learn, execute, and create data pipelines. But sometimes I feel that if some complex business problems arise, then we need to jump into the coding part. And there are not as many transformations available.

The initial setup is not at all easy. Setting up PowerCenter is not at all easy, especially when you are installing your server on Linux machines. It's very complicated, especially the upgrade part, if it is a multi-node cluster environment with high availability.

I would recommend using it. But currently all things are moving to the cloud. Informatica PowerCenter is a little bit lagging behind, and now everybody is moving to the cloud. 

So, Informatica itself is promoting the use of IDMC and cloud instead of Informatica PowerCenter. But some clients, like banking and pharmaceutical clients, still prefer traditional on-premises ETL tools. So, in that case Informatica PowerCenter is definitely one of the best and unbeatable tools for enterprises.

Overall, I would rate the solution an eight out of ten.