Senior DataStage Engineer — Data Pipelines & Oracle SQL

Tata Consultancy Services; Pennington (NJ); On-site; USD 110,000 - 125,000; Full time

Job summary

Tata Consultancy Services in the United States (New Jersey, Pennington) is seeking a Senior DataStage Developer to design and optimize data pipelines using IBM DataStage, Oracle, and SQL. You will monitor job execution, troubleshoot bottlenecks, and ensure high‑quality data flows across systems.

The role requires 10+ years of experience, with strong scripting skills (Linux shell) and familiarity with Autosys for job scheduling. This is a full‑time position based in Pennington, NJ.

Qualifications

• Minimum 10 years of experience in data integration or related field.
• Expertise in IBM DataStage to design data flows.
• Strong SQL and Oracle experience.
• Experience with scheduling tools like Autosys.

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.

Skills

IBM DataStage

Oracle

SQL

Tools

Autosys

Linux shell scripting

Job description

Tata Consultancy Services in the United States (New Jersey, Pennington) is seeking a Senior DataStage Developer to design and optimize data pipelines using IBM DataStage, Oracle, and SQL. You will monitor job execution, troubleshoot bottlenecks, and ensure high‑quality data flows across systems.

The role requires 10+ years of experience, with strong scripting skills (Linux shell) and familiarity with Autosys for job scheduling. This is a full‑time position based in Pennington, NJ.