Job Description

We are seeking an experienced IBM DataStage Developer with 7+ years of experience designing, developing, and supporting enterprise ETL and data integration solutions. The ideal candidate will have strong expertise in IBM DataStage, ETL concepts, SQL, data validation, and production support.

Responsibilities

Design, develop, and support scalable ETL solutions using IBM DataStage.
Develop DataStage jobs to extract, transform, validate, and load data from Oracle databases, flat files, CSV, text, Excel, and external systems.
Write complex SQL queries for data extraction, validation, reconciliation, and performance optimization.
Build and process JSON files using DataStage Hierarchical Stages.
Implement data quality checks covering data structure, data types, and business rules.
Troubleshoot ETL failures, handle production issues, and perform root cause analysis.
Support L1/L2 escalations and implement preventive measures to improve system stability.
Develop and maintain Unix shell scripts for automation and operational support.
Work with scheduling and monitoring tools such as Control-M.
Use tools such as ServiceNow, Jira, ADO, and Confluence for incident management, tracking, and documentation.
Collaborate with Business Analysts, Architects, SMEs, and development teams to deliver reliable data integration solutions.
Identify opportunities for automation, performance improvement, and operational efficiency.

Required Skills

IBM DataStage / IIS DataStage
ETL Concepts
Data Architecture
SQL
Oracle
Unix/Linux Shell Scripting
Control-M
Data Quality and Validation
Production Support and Troubleshooting
JSON and Hierarchical Data Processing
SDLC

Job Tags

Temporary work

Similar Jobs

Meds

Senior Warehouse Associate Job at Meds

...operations in Elmhurst and Libertyville. Were searching for a Senior Warehouse Associate who is hard-working, highly organized, a team player,... ...positiononsiteMonday-Friday. This is notsimilar toan Amazon-like warehouse; rather, there are days in the weekwhereone of...

Young World Physical Education

German Teacher Job at Young World Physical Education

German TeacherUtica Community School District TBD - Sterling Heights, MichiganThis job is also posted in Utica Community School DistrictJob DetailsJob ID: 5709493Application Deadline: Posted until filledPosted: YesterdayStarting Date: To Be DeterminedJob...

SimVentions, Inc - Glassdoor ✪ 4.6

SLBM Junior - Mid Level Test Engineer Job at SimVentions, Inc - Glassdoor ✪ 4.6

...consistently voted one of Virginia's Best Places to Work, is looking for a Test Engineer to join our Submarine-Launched Ballistic Missile (SLBM)... .... We offer: Medical, dental, vision, and prescription drug coverage Employee Stock Ownership Plan (ESOP) Competitive 40...

Aston Carter

Safety Coordinator Job at Aston Carter

...Job Description Job Description Join a leader in the food manufacturing industry where safety, quality, and teamwork are at the heart of everything we do. We are seeking a dedicated Safety Coordinator to help foster a safe, healthy, and compliant work environment within...

Singing River Health System

Surgical Tech Apprentice Job at Singing River Health System

...part of the Singing River Health System recognized Surgical Technologist Apprenticeship. The 2-year program consists... ...BCLS certification upon hire and/or transfer. Experience: None Reports to: Surgical Tech/First Assistant Educator; Surgical Patient Care Manager...

IBM DataStage Developer Job at PB consulting, Chicago, IL