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.

one of the biggest challenges we face during dev is that we can't delete any attributer we create and there no safe way to permanently remove records. This makes it difficult when we are testing or iterating on designs. Another issue is that the public APIs available in IDMC are still limited.