ETL Production Support

Tata Consultancy Services; Charlotte (NC); On-site; USD 100,000 - 120,000; Full time

Job summary

A leading IT services company is seeking a skilled professional in Charlotte, North Carolina, to monitor production environments, debug code, and manage cloud workflows. The ideal candidate will have over 10 years of experience with Informatica, Hadoop, and Oracle, along with strong skills in SQL, Unix/Linux commands, and scripting languages. Responsibilities include responding to alerts, assisting in code deployments, and maintaining system documentation. Competitive salary range of $100,000 - $120,000 per year offered.

Qualifications

• Minimum 10 years of experience in relevant fields.
• Proficiency in Unix/Linux commands and SQL for database querying.
• Experience in migrating workflows from Informatica to IDMC.

Responsibilities

• Monitor production environments and respond to alerts.
• Debug code and troubleshoot hardware/software issues.
• Assist with code deployments and migrations through environment stacks.

Skills

Informatica

Hadoop

Oracle

SQL

Python

Shell scripting

Unix/Linux commands

Splunk

Datadog

Jira

ServiceNow

Job description

• Secondary: Informatica, Hadoop and oracle
• Experience: Minimum 10 years
• 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.
• Configuring session objects, optimizing Spark engines, and managing file descriptors for high-volume data ingestion

Salary Range: $100,000 - $120,000 a year