Informatica IDMC Lead

Location: Charlotte, NC
Salary: $110,000.00 USD Annually - $120,000.00 USD Annually
Description:
Informatica Idmc Lead
Location: Charlotte, NC | Plano, TX
Employment: Fulltime

Role Overview

We are seeking experienced Informatica IDMC Lead support large-scale data integration and analytics platforms for a leading financial services client. The role focuses on production monitoring, incident management, Informatica/IDMC operations, performance tuning, and automation in a high-availability environment.

Must-Have Technical & Functional Skills

Primary Skill

• ETL Production Support

Secondary Skills

• Informatica (PowerCenter) and IDMC (Informatica Intelligent Data Management Cloud)
• Oracle Database
• SQL Performance Tuning
• Shell Scripting (Unix/Linux)
• Autosys
• Spark (YARN logs, Spark troubleshooting)

Experience

• Minimum 10 years of hands-on experience in ETL production support environments

Roles & Responsibilities

Production Monitoring & Incident Management

• Monitor production environments and respond to alerts proactively
• Resolve incidents within defined SLAs and perform root cause analysis (RCA) to prevent recurrence
• Track, document, and manage incidents using ticketing systems

ETL & Informatica Support

• Support and manage Informatica workflows and IDMC components in cloud environments
• Migrate ETL workflows from Informatica PowerCenter to IDMC
• Configure and optimize session objects and ETL job executions

Troubleshooting & Performance Tuning

• Debug Informatica, Spark, Oracle, and Shell scripts
• Analyze logs and troubleshoot application, system, and performance issues
• Optimize SQL queries and Spark engines for high-volume data ingestion
• Manage file descriptors and resource configurations for large-scale batch processing

Deployment & Environment Management

• Assist with code deployments and migrations across environments:
• Dev, SIT, UAT, and Production
• Ensure smooth release transitions with minimal production impact

Automation & Reporting

• Use scripting languages (Shell, Python) to automate routine operational tasks
• Maintain system documentation, SOPs, and operational runbooks
• Generate performance, stability, and operational reports for stakeholders

Tools & Platforms

• Monitoring tools: Splunk, Datadog
• Ticketing systems: Jira, ServiceNow
• Cloud and big data platforms: Spark, YARN
• Job scheduling: Autosys

Additional Technical Knowledge

• Metadata-driven ETL processes
• Batch/job processing frameworks
• Unix/Linux command-line operations
• Strong understanding of data pipelines and enterprise data ecosystems

Generic / Managerial Skills

• Strong analytical and problem-solving abilities
• Ability to work in a fast-paced, 24x7 production support environment
• Excellent communication and documentation skills
• Experience collaborating with development, QA, and infrastructure teams
• Ownership mindset with a focus on stability and continuous improvement

Keywords for Resume Search

• Primary Skill: Production Support
• Informatica, IDMC, ETL Support
• Oracle, SQL Performance Tuning
• Shell Scripting, Autosys
• Spark, YARN, Splunk
• Incident Management, RCA
• 10+ Years Experience

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.

Contact:

This job and many more are available through The Judge Group. Please apply with us today!