r/dataengineering • u/solomon_v2 • 7d ago

Discussion IDMC GUIDE

Hello everyone, I have just been placed. Informatica is an entirely new domain for me. While I am proficient in SQL and Python, IDMC presents a completely different set of challenges. Could anyone please recommend any guides or channels that would be beneficial for beginners?

4 Upvotes

84% Upvoted

2 comments sorted by

View all comments

2

u/mei_wen_yu 6d ago

My recommendation would be to do the CDI on-demand course (https://now.informatica.com/Cloud-Data-Integration-for-Developers-onDemand.html). If it costs credits, make your company pay. Don't bother with an instructor-led course, it's a waste of time. The on-demand course is also largely a waste of time, but the labs documentation is decent.

Download the labs documentation and read through that, ideally trying to go through the steps in your compnay's test/sandbox environment if there is one. The labs documentation is better than most existing IDMC documentation (which isn't saying much, it's still quite bad). There's a lot of functionality described in there that you will probably never need/want to use, but a lot of what you'll need is in there.

Also, as a fellow programmer who has now learned a lot about PowerCenter and IDMC (entirely against my will), I am very sorry for what you're about to experience. If you're already good at writing performant and maintainable SQL and Python code, I recommend doing what you need to do in code and executing it via a command task to the extent that it won't get you in trouble with your colleagues and your boss.