Informatica IDMC Lead

Primary Skill: 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, and managing workflows in the cloud. *Experience in migrating 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