Informatica IDMC Lead Developer

Requirements

Must have:

- Over 10 years of experience in ETL Production Support - Strong knowledge of Informatica and IDMC - Proficiency in Oracle, SQL performance tuning, Shell scripting, and Autosys - Practical experience with Unix/Linux systems - Expertise in debugging Informatica, Spark, Oracle, and Shell scripts - Familiar with monitoring tools like Splunk or Datadog - Experience with Jira, ServiceNow, and cloud-based workflow management - Understanding of metadata-driven ETL processes and batch/job frameworks

Responsibilities:

- Monitor ETL production environments, reacting to alerts and troubleshooting technical problems - Identify incidents against SLAs and conduct root-cause analysis to avert future issues - Oversee and resolve Informatica and IDMC workflows within cloud platforms - Lead migration projects from Informatica to IDMC - Examine logs to troubleshoot hardware and software issues across ETL components - Maintain and revise system operating procedures and performance documentation - Assist with code deployments and migrations through various environments: Dev, SIT, UAT, and Prod - Enhance Spark engines, configure session objects, and manage file descriptors for efficient high-volume data ingestion - Automate procedures using Python, Shell, and SQL scripting - Utilize Yarn and Spark logs for cloud platform supervision

Company:

We are currently looking for skilled Informatica IDMC Leads to join our team, supporting large-scale ETL production environments for a leading financial services client. The positions are available in either Plano, TX or Charlotte, NC, and offer a competitive salary range of $110,000 to $115,000 annually, with some flexibility. We value expertise in Informatica, IDMC, and production support as well as strong troubleshooting and performance-tuning skills. Join us to become a key player in optimizing our ETL operations.