ETL Production Support

Job description

Must Have Technical/Functional Skills 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, 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 framework2 TCS Employee Benefits Summary: Discretionary Annual Incentive.

Comprehensive Medical Coverage

Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.

Family Support

Maternal & Parental Leaves.

Insurance Options

Auto & Home Insurance, Identity Theft Protection.

Convenience & Professional Growth

Commuter Benefits & Certification & Training Reimbursement.

Time Off

Vacation, Time Off, Sick Leave & Holidays.

Legal & Financial Assistance

Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range

$100,000- 120,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE