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!