I worked for around seven to eight months on a project in the insurance domain using Informatica Intelligent Data Management Cloud (IDMC) and there I was working as a Senior Solution Architect or a Principal Cloud Consultant.

We use the data integration features of Informatica Intelligent Data Management Cloud (IDMC) with a focus primarily on the ETL perspective or the data warehouse perspective, where we are taking different data sources, combining them, implementing some data quality rules on top of it, and then storing it in our data warehouse environment. From there, we are using that data for our reporting and analytics purposes.

We also use the IDMC Data Catalog, but that is very limited, and we are using it only for governance purposes. As a Solution Architect, my main involvement is to design the solution at a very high level; at a ground level, I'm not using the Data Catalog on a day-to-day basis.

The best part about the Informatica Intelligent Data Management Cloud (IDMC) is the modularity; when I say modularity, I mean the things get easier by working into different modules. For example, if you want to implement the Master Data Management solution, we are only limited to the master data solution. If you want to go with the admin side of the things, then we are only limited to the admin side of the things. The second important thing I appreciate about this is the more focus from the AI angle, Artificial Intelligence angle, which is inbuilt into the IDMC.

Definitely, we see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.

One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach.

My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, for products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point.

I worked for around seven to eight months on a project in the insurance domain using Informatica Intelligent Data Management Cloud (IDMC) where I was working as a Senior Solution Architect or a Principal Cloud Consultant.

I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.

My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, for products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point.

My experience with technical support would indeed be rated as nine out of ten.

Positive

The initial setup of Informatica Intelligent Data Management Cloud (IDMC) is moderate; it is not complex.

We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.

My company is a partner with Informatica, and we are the service provider for the company, which defines my relationship with Informatica.

My main role is not involved in the pricing side of things because that is already between the company and the clients. My title is Principal Cloud Engineer at Fifth Dimension Robotics.

On a scale of 1-10, I rate Informatica Intelligent Data Management Cloud (IDMC) a nine out of ten.

The typical use case of Informatica Intelligent Data Management Cloud (IDMC) is governance activities for data quality and data cataloging. I need to look at the request type from whom I am getting to provide the details.

The most helpful features in Informatica Intelligent Data Management Cloud (IDMC) are data cataloging and the data marketplace.

In terms of data quality management, Informatica Intelligent Data Management Cloud (IDMC) helps with data governance overall.

There are some improvements needed in Informatica Intelligent Data Management Cloud (IDMC), especially from a user experience point of view over the last year. They are improving, and there is still scope for enhancement.

The observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.

In terms of cost effectiveness, Informatica Intelligent Data Management Cloud (IDMC) is more than 20% costly compared to the industry.

Regarding AI features in Informatica Intelligent Data Management Cloud (IDMC), there is always improvement and clarity present, but compared to the competitors, they are still lacking. The AI features are helpful, but when compared to its competitors, they need enhancement.

I have been working with Informatica Intelligent Data Management Cloud (IDMC) for five and a half years.

The deployment of Informatica Intelligent Data Management Cloud (IDMC) is user-friendly, but if the software is available, it takes some time.

I have contacted the Informatica technical support team, and they have good technical support, but there is always room for improvements. My experience with Informatica technical support overall rates around three, which is above medium, but not extraordinary.

Neutral

Informatica Intelligent Data Management Cloud (IDMC) takes about a couple of days to configure, depending on the services.

I am aware of its competitors, and I will provide the details once I know them more thoroughly.

I definitely would recommend the Informatica solution to other people.

I am satisfied with Informatica Intelligent Data Management Cloud (IDMC), even if it might be lacking in some areas. The expectations will be somewhere, and the tool can support somewhere, with opportunities to improve, considering the features they are building and their strengths.

I would rate Informatica Intelligent Data Management Cloud (IDMC) at around seven.

Informatica Intelligent Data Management Cloud (IDMC) is one of the cloud-based data management facilities that Informatica provides for us.

I have been working with this tool for many years, primarily focused on the CDGC, which involves working on on-premise cloud data governance models. Informatica has facilitated managing this with a modern approach, integrating base data quality and data governance. The tool retains the same on-premise architecture, but the terminologies and verbiage are somewhat different, leading us to comparatively start working with cloud-based data governance tools.

Previously, Informatica EDC was separate for managing data and metadata management, while Axon was dedicated to data governance initiatives. The integration of both was needed, but it was too complex for a layman to understand the EDC, integrate with Axon, or vice versa. The cost involved was also quite high, as there were separate licenses for EDC and Axon; utilizing EDC without Axon was not fruitful. We mandatorily needed to purchase licenses for Axon to create a full framework.

In the earlier case, proper separate licenses were required. The technical team had to ensure integration and maintain both environments, which was a difficult task. Now, with the cloud-based data quality, they have merged the two into one element. In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.

The marketplace has also moved to Informatica Intelligent Data Management Cloud (IDMC), forming a cloud data marketplace. They consolidated many tools into one, which is impressive.

The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview. As a matter of POC, they are assessing whether their requirements can meet data governance initiatives. The need for skilled professionals is increasing, but cost remains a significant consideration for organizations when implementing CDGC. If a budget is allocated and they are satisfied with the Informatica CDGC license price, then it is a very good tool to implement.

Regarding improvements, besides the price, the advanced clusters feature in CDGC needs attention. There are advanced scanners features present in both on-premise and cloud, but the setup isn't straightforward; there are lots of dependencies to consider. For instance, an SAP connector dealing with CDGC isn't simple. There are precautions and prerequisites that must be followed; otherwise, it won't work easily compared to the Oracle connector. Thus, resources need to be handled carefully with the advanced scanner configuration guide.

I have been working with this tool for many years.

Informatica Intelligent Data Management Cloud (IDMC) has been very quick and easy to deploy because it only requires a reliable internet connection and a compatible browser. We can do many tasks without needing advanced hardware; a basic laptop or desktop with an updated browser suffices for managing data with IDMC. There is no necessity for extensive engineering tasks to utilize the tools.

The technical support team from Informatica is excellent. If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses. This level of intimacy and coordination is excellent.

Positive

If the process is set, every organization has its own governance structure for providing access to users, subject to policies and processes. If everything is in place, it takes only about 10 to 15 minutes; it's straightforward.

If user access approval is excluded from the process, it can take less than 5 minutes.

The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview. As a matter of POC, they are assessing whether their requirements can meet data governance initiatives. The need for skilled professionals is increasing, but cost remains a significant consideration for organizations when implementing CDGC. If a budget is allocated and they are satisfied with the Informatica CDGC license price, then it is a very good tool to implement.

Customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview. As a matter of POC, they are assessing whether their requirements can meet data governance initiatives. The need for skilled professionals is increasing, but cost remains a significant consideration for organizations when implementing CDGC.

I haven't found any difficulties managing different data standards. The team and everyone at Informatica Corporation are friendly, and the documentation is self-learning and self-taught, presented in an understandable format with pictorial representations that help us not to depend on others. The only challenge is reading through around 200 pages of documentation, which can be a pain point.

Informatica is easy to integrate with other tools using APIs. However, it has some difficulties. Informatica appears to build revenue by offering different environments. If you have a rare setup, such as SAP HANA CRM systems, it isn't bundled within a standard license, so purchasing an exclusive license is necessary for integrating such atypical systems. These should be included as part of a single license.

Some connections, like MongoDB, are straightforward, and Oracle works well under a single license, but certain source systems pose challenges in managing connections and integration, such as SAP systems and CRM systems, where licenses must be obtained separately from Informatica.

If you have an SAP environment, it's better to consider alternatives or be aware that additional costs may incur for integration.

On a scale of 1-10, I rate Informatica Intelligent Data Management Cloud (IDMC) a 10 out of 10.

Positive

I have used Informatica Intelligent Data Management Cloud (IDMC) for customer data management and analytical product master data management solutions. The first use case involved finding unique customer references with match and merge functionality. The second use case was creating a master data repository for products for use in the analytical layer.

The match and merge functionality is invaluable for discovering golden master data records. Additionally, the integrated data transport and master data creation capabilities are significant. The platform's ability to pull in and push out data from other platforms without the need for an additional integration tool enhances its appeal. The availability of data quality tools within the platform is another bonus. The presence data governance tools for meta data management adds to the benefits. 

There are various areas for improvement in IDMC. Enhancements on basic data management functionality and the UI front, such as multiple templates and improved grid views, would be beneficial. Bulk data management features could be improved from the UI perspective to get to the level of the on prem versions of Informatica MDM. 

The tool needs to mature but missing small but important features, like restricted dynamic attributes functionality, data inheritance rules in master hierachies, identifiers not being passed in jobs is a drawback.

I have been using IDMC for the last three years across two projects

Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users. 

I have rated the stability a ten out of ten due to a high level of satisfaction.

As a SaaS platform, IDMC is quite scalable and provides complete flexibility. Users can increase data capacity on demand based on licenses, which facilitates easy and fast scaling.

The customer support team is good at response and issue resolution. However, due to the tool's maturity limitations, solutions are not always simple and often require workarounds, indicating a need for further improvement.

Positive

The Informatica on Prem MDM product suite is very mature as a tool and still a very good option. 

I rated the initial setup of IDMC as a six out of ten. Many tools within IDMC are new, and those familiar with on-premises versions find the features limiting. This necessitates assistance from the Informatica support team and architects for ensuring quality of implementation. 

The pricing is high and is based on the number of master data entities managed within the platform including refrence data entities. It can range from a quarter million to a couple of million a year. IDMC is often described as the 'Ferrari of Master Data Solutions,' implying that while expensive, it is still the best as a business-critical platform and, therefore, justified.

As an integrated enterprise solution, IDMC is quite good, however, the platform needs to mature in the capabilities it currently provides. 

Overall, I rate Informatica IDMC a seven out of ten.

We use Informatica Cloud Data Integration to load data from files to TelSource or Oracle tables. We also apply business rules to transform the data before loading it into the respective targets.

Most of the features are good. The advanced features like task flow and conditional integration are particularly useful. There are multiple transformations we can use in Dashflow, which are beneficial. We don't use features like centralization and data marketing because they aren't relevant to our use case. Our primary focus is on task flow, which allows us to design our jobs and execute them conditionally.

Some features require an additional license, such as Elastic Mappings. Most of the features provided are through Elastic Mappings, not the data integration service which causes restrictions. For example, the recently enabled source partitioning isn't applicable to Salesforce, which we use as our target or source. We primarily seek features that enhance performance for Salesforce and ICS Integration, aiming to reduce job execution time.

We don't have the license for Elastic Mapping, so we can't use that feature. Most of the new features added by Informatica are through Elastic Mapping. It would be helpful to have features like multithreading or partitioning for Salesforce to enhance performance.

I have been using Informatica Cloud Data Integration for five years.

The product is stable.

I rate the solution’s stability a seven out of ten.

20-30 users are using this solution.

I rate the solution’s scalability a five out of ten.

Support is good.

Positive

The initial setup is very easy. When I first started using it, I installed a 30-day trial version. I personally explored it during that period, and it was good.

It takes 30-40 minutes depending on the jobs.

I rate the initial setup a ten out of ten, where one is difficult, and ten is easy.

The team is very user-friendly, meeting our expectations much like PowerPoint does.

It supports integration with most cloud sources, including AWS, and has various cloud connectors. So, It's a good choice for anyone.

Overall, I rate the solution a seven out of ten.

In the past, people used Informatica MDM because it was one of the leading tools at that point in time to work on an on-premises model. It was the leading tool in the market, offering vast customization options and matching and merging options that were better compared to other solutions. The way the data lineage or the customization options it gave, the tool was good. Now, the tool has a changed dynamic, and it is currently available on the cloud. Apart from Informatica MDM, there are other tools, as well as the market, that are completely on the cloud.

The feature of the product that has been most helpful in improving data quality revolves around Informatica DQ or IDQ, which is one of the tools Informatica offers. IDQ helps cater to the scoring of the data, clean up the data, and integrate it.

In terms of the room for improvement required in the product, I would say that the product is still in the maturing phase, specifically on the cloud. The product is not too user-friendly to do the configurations. There are a couple of areas in the product where I feel improvements can be made, but if I consider the algorithms used in the match process, the tool is very robust.

I have been using Informatica MDM for nine to ten years. My company is a partner of Informatica, and we also implement the tool.

Stability-wise, I rate the solution a seven out of ten.

In terms of scalability, I would say that the product is currently more available in the cloud. Scalability-wise, I rate the solution a five out of ten. The scalability on the cloud is good. On the cloud, by default, the tool becomes quite scalable.

Informatica provides premium products. The product is mainly meant for enterprise-level customers because the tool is available at the premium cost.

I have not used the technical support provided by the product. If you asked me about the support offered for the tool's on-premises model, I would say they were really good. We really liked Informatica's support. With the cloud, I'm not aware of the support.

If one is a difficult setup and ten is easy, I rate the product's initial setup phase as a five.

If you are talking about the product on the cloud, the initial configuration must be done. There is quite a lot of refresh which takes place every time we have to publish something, and then we have to wait for some time. It is not that you make a change, but you can see it immediately in the tool. The wait period is quite long. If you are a first timer, it takes time for that person to figure out the product. Once you get the hang of it, then it becomes easy.

An end-to-end implementation would take nine to ten months, or maybe a little more than that, depending upon the customer's desired features.

The tool does give a good ROI.

The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives.

On a scale of one to ten, if one is a cheap solution and ten is an expensive one, I rate the tool's price as seven.

Informatica MDM is able to handle complex data integration scenarios with the help of IDCM, which offers the power of an ETL tool.

Speaking about the AI part, I feel the product is still in the maturing phase.

My first preference would be for Welkio, and only after that would I prefer Informatica MDM, so I would say that it won't be my first choice.

I rate the tool a seven out of ten.

We use the solution for ETL.

It's a powerful tool to create data warehouse solutions for our clients. We take unstructured data and use Informatica Cloud to structure it in various ways, making it usable on a reporting front end. This enables clients to make informed business decisions based on the data.

It's the accessibility and the range of features that stand out. Before using Informatica Cloud, we were working with Informatica PowerCenter. The transition from PowerCenter to Cloud wasn't entirely effortless, but it was seamless enough for our developers to adapt and continue their work smoothly.

Our main issue is transitioning from on-premise to cloud data storage. As many clients move their data to cloud platforms like Azure, Snowflake, and AWS, we're encountering problems with Informatica. Errors that were straightforward and clear with on-premise databases now appear ambiguous in cloud environments. Our developers spend significant time reducing these generic errors, often simple issues like a column not accepting null values. This lack of clarity is causing unnecessary delays as they have to sift through logs or contact support to diagnose problems that would have been more easily identified in an on-premise setup.

I have been using Informatica Cloud Data Integration as a financial partner for over five years.

We have about seven developers. It is a scalable solution.

When errors arise, contacting support can be frustrating. Sometimes, the technician can't solve the issue and transfers us to someone else. This makes us less confident that the person helping us is truly equipped to resolve the problem.

Neutral

The initial setup is simple and depends on the task. However, it usually takes a couple of hours if development is complete and we're moving from the development environment to production.

ROI is strong because we have a structured portal that ensures development is done correctly. It is shareable, scalable, and equipped with enough monitoring tools to quickly address any issues. Ultimately, the client doesn't care what tools we use. They just want problems resolved quickly. Informatica provides the necessary tools and features to help us do that effectively.

It has premium pricing. Depending on what we're working on and which features we're using within Informatica, there can be additional costs. It's mostly data integration, but you might need to upgrade your license to include other aspects of Informatica. Certain connectors require a license upgrade to access.

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

What I like best about Informatica MDM is its structured, table-based approach. Unlike Reltio, where data is only visible through the UI and cloud-based, the solution allows access to normalized tables. This means I can directly query and see data in each table. For instance, I can easily get all customer details from the customer table. However, for more complex queries, like seeing all customer interactions with the organization, some SQL knowledge is needed to join different tables and retrieve the details.

The tool could be improved in terms of ease of use, particularly for those without technical expertise. Understanding and extracting data from the table-based structure requires some SQL knowledge and technical skills. Additionally, while Informatica MDM has moved towards a cloud-based MDM with a UI similar to Reltio, I haven't used it, so I can't comment on its effectiveness.

I have been working with the product for six months. 

I haven't had any issues with the tool's stability. 

I'm not entirely sure about scalability, but I've heard that adding custom features can be complicated. We have to go through several steps. First, we need to determine if we're adding a column to an existing Informatica MDM table or creating a new one. Then, we have to contact Informatica with our customization request. They do the customization. After that, we have to check if it's working correctly.

In our organization, we use Informatica MDM in a specific way. It's primarily based on tables; users don't directly log into it. The process works like this: data flows into the MDM tables as an inbound process. Once the master data merge has been completed, the output data flows out as an outbound process.

The tool's support team is good. The product is quite technical, and so is the support team. When we have questions, we reach out to them, and they provide answers. Their response time is also good—we don't have to wait long for replies.

Positive

I rate the overall product a seven out of ten. If you don't have the budget for Reltio, then you can go for Informatica MDM. 

I use the solution for financial institutions, where we push our data into the warehouses and analytics platforms. We query the Kafka messaging services and see whatever message we get. We used to take the API responses and load them into different target systems, some cloud-based and some on-prem. For some security reasons, we used to push the data to the on-prem and then the cloud versions.

In Informatica, we can export the metadata in XML format, and then we can see what all are available. Metadata querying is right now not there in Informatica Cloud Data Integration. Informatica Cloud Data Integration needs to make metadata querying available in the tool, and Informatica needs to put more reports to get the lineage details and then the source system, if at all there is a need for us to identify them. It is an area where we face big challenges. I started using Informatica Cloud Data Integration recently.

I have been using Informatica Cloud Data Integration for two years.

The solution's technical support is pretty good, especially since the turnaround time is good. When we raise tickets with the tech support team, we get support within the shortest span. I rate the technical support an eight out of ten.

Positive

I have used IBM Cloud Paks and Informatica Cloud Data Integration. Sometimes, we have to go with our client's perspective, especially if they have pre-existing licenses and get any discounts. My company has suggested IBM Cloud Paks, but with the existing things that our clients work on in Informatica, sometimes they prefer the same vendor. We did PoCs for both IBM Cloud Informatica Cloud Data Integration to help clients figure out the overall run time cost and then the number of credits that they are after, based on which they have opted for Informatica.

I have previously worked with IBM Cloud Paks and Snowflake, and both of them were client-specific tools for which we had to choose. If some tool was already in place, then it has already been paid for as a part of the procurement process, so we should continue with it. If it is a new proposal, then we have to go for it and list out to our customers all the things that we have in our pocket, and where we can take care of all the accesses, billing per hour for users, number of hours, and all such related details. After that, we suggest to our customers to take a call depending upon the amount of budget that needs to be allocated for the technical stuff.

For the last few months, I have been working only on Informatica Cloud Data Integration. Some people are interested in the Azure Databricks for their pipelines. Some of the partners who are providing tools to customers are also interested in Azure Databricks.

Instead of Informatica, I recommend IBM products to others, especially if someone already has other products from IBM's family or has purchased some information catalog. My company suggests that such customers go with IBM Cloud Paks since it allows you to lift and shift some of the existing jobs or processes to the IBM Cloud Catalog. If somebody wants to go for a cross-platform, then there was a time when my company used to suggest they go for Azure Databricks. It all depends on the existing infrastructure and a user's broader plan. Based on it, we used to suggest tools to customers. My company also used to look at what our customers were using and what their target was.

When it comes to the impact of the mapping and transformation features on data integration processes, Informatica has an existing license system where we directly map it to the existing cloud and then run it over the cloud. Any new development activities that we are doing are done directly on the cloud. Informatica has provided this migration tool for lift and shift purposes. With the tool, almost 80 to 90 percent of things are directly convertible from on-prem to cloud services, but through reports, we figured out that 10 percent can't be done, so we have to redo such areas in the cloud.

Speaking about the ease of use and learning curve of Informatica, I would say that my total experience is close to thirteen years with ETL tools. I have worked on multiple ETL tools on different clouds. I don't see much difference between IBM Cloud Paks and Informatica Cloud Data Integration. For me, these are more or less similar tools, with just a change in cosmetics.

Speaking about Informatica Cloud Data Integration's performance and scalability and how it meets our company's project needs, I would say that we have to buy CPU units. Initially, we had some 10,000 CPU units, and with that, we knew how many credits there were. Most of our systems are in production, so only with the peak loads, our threshold is not going beyond 60 to 70 percent of utilization.

Informatica Cloud Data Integration is associated with a bigger integration part where we have around 200 mappings and it works well. I don't see many issues in the tool except in the area of metadata querying. If I want to figure out a particular column of the table that is impacting the number of mappings, previously, we used to go for query, or we used to query in XML format. Currently, we have to call the APIs, but the information that we are after is not that precise.

Informatica Cloud Data Integration can be integrated with Salesforce. We can also have some other API integrations. If you have any specific systems, then considering whatever ERPs or legacy systems we have used with the tool, we don't see many issues.

I would recommend the tool to others. I would recommend the product to mid-sized companies. At the end of the day, everything is about the number of CPUs or the units that are needed to run it. Everything depends on the number of mappings of the growth prospect of the ETL pipelines that one is going to build. If it is mid-level and companies are above the mid-level zone, Informatica and IBM Cloud Paks are preferable to the other tools.

I rate the tool a seven and a half to eight out of ten.