Senior DataStage Developer

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

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage

Parental Leave

Auto Insurance

Identity Theft Protection

Commuter Benefits

Training Reimbursement

Paid Time Off

Legal Assistance

Job summary

Tata Consultancy Services in Charlotte, NC seeks a senior ETL Developer with deep IBM DataStage expertise to design and optimize data pipelines. You will extract, transform, and load data from Oracle databases using SQL, monitor jobs, and drive performance improvements.

The role requires 10+ years of experience, a BS in Computer Science, and familiarity with Autosys and Linux shell scripting. This on-site opportunity offers competitive compensation and comprehensive benefits.

Qualifications

• Minimum 10 years of experience in data integration and ETL.
• Strong IBM DataStage, Oracle, and SQL skills.
• UI/Linux shell scripting and Autosys experience preferred.

Responsibilities

• Strong knowledge in IBM DataStage to create data flows using DataStage Designer, Director, and Administrator.
• Extract and manipulate data in Oracle databases using SQL.
• Monitor jobs, fix bottlenecks, and build efficient pipelines.
• Debug issues and identify root causes in data and processes.
• Work with scheduling tools such as Autosys.

Skills

IBM DataStage

Oracle

SQL

UI/Linux shell scripting

Autosys

Education

Bachelor of Computer Science

Job description

Job Description

Must Have Technical/Functional Skills

Primary Skill: IBM DataStage, Oracle, SQL

Preferred: UI –Linux shell script, Autosys

Experience: Minimum 10 years

Roles & Responsibilities

• Strong knowledge in IBM DataStage to create data flows using DataStage Designer, Director, and Administrator.
• Strong knowledge to extract and manipulate data in relational databases like Oracle using SQL.
• Should be able to monitor jobs and fix bottle necks to make processing of data fast and build efficient pipelines.
• Should have problem solving ability and deep analytical skills to debug the issues and find root cause of issues created by data or the broken process.
• Should have working knowledge on scheduling tools such as Autosys.

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-$125,000 a year

Qualifications

BACHELOR OF COMPUTER SCIENCE