Job Title: Informatica IDMC Lead - Dev, Prod Support
Location: Charlotte, NC & Plano, TX (Onsite)
Duration: Full Time
Job Description:
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).
•Configuring session objects, optimizing Spark engines, and managing file descriptors for high-volume data ingestion.
•Knowledge in Metadata dependent ETL process and batch/job framework
Generic Managerial Skills, If any