ETL Production Support

Tata Consultancy Services Limited

Charlotte, NC, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

10 years minimum

Compensation

$100,000.0 - $120,000.0

Working hours

Regular working hours

Job source

indeed.com

Tech stack

JIRA CA Workload Automation Ae System Configuration Extract Transform Load (ETL) Database Queries Software Debugging Monitoring of Systems Issue Tracking Systems Python (Programming Language) Log Analysis Metadata Oracle (Applications)

+15 more

Performance Tuning Shell Script Software Deployment Software Engineering SQL Databases Datadog Scripting Data Ingestion Apache Yarn Informatica Powercenter Apache Spark Information Technology Splunk Sql Tuning Servicenow

Requirements

Do you have experience in System tuning?, Do you have a Bachelor’s degree?, 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, Qualifications : BACHELOR OF COMPUTER SCIENCE

Benefits & conditions

(part of Tata group) 3.93.9 out of 5 stars Charlotte, NC $100,000 - $120,000 a year, Pulled from the full job description

Pet insurance
Health insurance
Vision insurance
Dental insurance
Commuter assistance, 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