Informatica IDMC Lead

Informatica IDMC Lead (8 Open Positions)

Locations:
Plano TX or Charlotte, NC
Compensation: $110-115K (some flex)

We’re seeking experienced Informatica IDMC Leads to support large‑scale ETL production environments for a major financial services client. This role requires deep expertise in Informatica, IDMC, and production support, along with strong troubleshooting and performance‑tuning capabilities.

• 10+ years of experience in ETL Production Support
• Strong proficiency with Informatica and IDMC
• Expertise in Oracle, SQL performance tuning, Shell scripting, and Autosys
• Hands‑on experience with Unix/Linux environments
• Experience debugging Informatica, Spark, Oracle, and Shell code
• Familiarity with monitoring tools such as Splunk or Datadog
• Experience with Jira, Service Now, and cloud‑based workflow management
• Knowledge of metadata‑driven ETL processes and batch/job frameworks

• Monitor production environments, respond to alerts, and resolve technical issues
• Track incidents against SLAs and perform root‑cause analysis to prevent recurrence
• Manage and troubleshoot Informatica and IDMC workflows in cloud environments
• Lead migration efforts from Informatica to IDMC
• Analyze logs and resolve hardware/software issues across ETL components
• Maintain and update system operating procedures and performance reports
• Support code deployments and migrations across Dev, SIT, UAT, and Prod
• Optimize Spark engines, configure session objects, and manage file descriptors for high‑volume ingestion
• Automate processes using Python, Shell, and SQL scripting
• Work with Yarn and Spark logs for cloud platform monitoring

• Experience in large enterprise or financial services environments
• Strong analytical and problem‑solving abilities
• Ability to manage production support in high‑availability systems

Please send resume and Linked IN to be w2 to accept permanent employment (without sponsorship now or in the future)

Joy Provenzano
The Judge