I've been involved with our Informatica IDMC rollout for roughly two years now, mostly from the infrastructure and governance side. I don't build mappings or transformations myself -- I manage the cloud environment it connects into, handle the networking for Secure Agents, and help teams get onboarded. From that angle, I'd give it a solid 4 out of 5. It does what we need it to do, but getting there took more effort than anyone planned for. The core reason for the high marks is that before IDMC, our data cataloging situation was a mess. We had a sprawling hybrid footprint -- on-prem Oracle and SQL Server databases, AWS S3 buckets, Glue catalogs, data lakes served through Trino -- and nobody had a single view of what existed where. IDMC gave our governance team that view. After about six months of scanning and profiling, they were finally able to answer questions such as "where does this customer field live?" without pinging three different platform teams.

Overall the tool was able to accomplish all expected items. While it was difficult to start at first, we were able to troubleshoot some of the gaps.