Role : Informatica IDMC Lead - Dev, Prod Support
Location : Charlotte, NC / Plano, TX
Duration : Full-Time
Interview : Online / Video
Must Have Technical / Functional Skills
Primary Skil : ETL Production Support
Secondary : IDMC, Informatica, Oracle, SQL Performance Tuning, Shell Scripting, Autosys
Experience : Minimum 10 years
Roles & Responsibilities
- Monitor production environments, respond to alerts, and resolve technical issues, including tracking incidents against SLAs and preventing recurring issues through RCA.
- Experience with Informatica, IDMC components, manage the workflows in cloud.
- Experience in migrating the workflows from Informatica to IDMC.
- Debug Informatica, Spark, Oracle and Shell scripting code, analyze logs, and troubleshoot hardware / software issues.
- Maintain, document, and update system operating procedures, and provide performance reports.
- Assist with code deployments and migrations through environment stacks (Dev, SIT, UAT, Prod).
- Proficiency in Unix / Linux commands, SQL for database querying, performance tuning and scripting languages (e.g., Python, Shell) for automation.
- Experience with monitoring tools (e.g., Splunk, Datadog), ticketing systems (e.g., Jira, ServiceNow), and cloud platforms(Yarn and Spark logs).