IBM Infosphere DataStage Developer

Tekskills Inc.; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

The candidate will develop and maintain ETL processes, perform data cleansing, error handling, performance tuning, and work with scheduling and monitoring of DataStage jobs through production.

Qualifications

• 6-8 years of experience in IBM Infosphere DataStage.
• Extensive work with parallel jobs, sequences and routines.
• Strong SQL skills across Teradata, Oracle, SQL Server, DB2.
• Proficient in UNIX shell scripting for ETL workflows.

Responsibilities

• Develop and maintain DataStage ETL jobs.
• Perform data cleansing, error handling, logging and performance tuning.
• Schedule, monitor and support DataStage jobs through production.
• Assist in unit, integration testing and UAT; troubleshoot issues and SLA breaches.
• Prepare technical docs, mappings and job design specifications.
• Support migrations and upgrades (DataStage versions, cloud migrations).

Skills

IBM Infosphere DataStage

SQL

UNIX shell scripting

Tools

Teradata

Oracle

SQL Server

DB2

Job description

Job Title: IBM Infosphere DataStage Developer

Location: Bangalore (WFO)

Skills Required: IBM Infosphere DataStage

Experience Range Required: 6-8 Years

Job Description:

• Job Description for DataStage Worked extensively in parallel jobs, sequences and preferably in routines.
• Good conceptual knowledge on data- warehouse and various methodologies. Strong SQL database skills in Teradata and other databases like Oracle, SQL Server, DB2 etc.
• Working knowledge in UNIX shell scripting. Implement data cleansing, error handling, logging, and performance tuning techniques in ETL workflows. Schedule, monitor, and support DataStage jobs till production activities.
• Perform unit testing, system integration testing, and UAT support. Troubleshoot data and performance issues, ensuring SLAs are met.
• Maintain technical documentation, mapping documents, and job design specifications.
• Support migration and upgrade projects (DataStage version upgrades, platform migrations to cloud, etc.)
• Good communication and presentation skills.