Source description
About the role
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
Role: Technical Lead
Desired skills: Informatica | Oracle | SQL
Qualifications: BACHELOR OF COMPUTER SCIENCE
-
Experience: 10 - 15 Years
-
Job function: TECHNOLOGY
-
Location: Charlotte, NC
Salary range: $100,000–$120,000
Apply by: 2026-08-10 00:00:00
More at Tata Consultancy Services