IBM DataStage Developer Job at PB consulting, Chicago, IL

  • PB consulting
  • Chicago, IL

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

Contract work

Similar Jobs

Jack Morton Worldwide

Head of Finance, North America Job at Jack Morton Worldwide

 ...interview and any bona fide offer of employment will only come from an authorized representative of Jack Morton with an email address @...  ...or "@impact-xm". We will never require an applicant to provide credit card or banking information to cover any supposed advance costs... 

Paragould School District

Assistant Technology Technician Job at Paragould School District

 ...Assistant Technician. Contract length is 188 days per year 8 hours per day. Position begins August 6 2026. Salary is based on salary...  ...States. Qualifications: Bachelors degree certification in technology or equivalent work experience required. Technology troubleshooting... 

PAM Health

Occupational Therapy Assistant (COTA/OTA) - PRN Days | Thousand Oaks Rehab Job at PAM Health

 ...Hospital Opening early 2026! We are looking for an Occupational Therapy Assistant (COTA/OTA) to join our team and care for our diverse...  ...than 80 locations, as well as wound clinics and outpatient physical therapy locations, in 17 states. PAM Health is committed to providing... 

Electric Power Research Institute (EPRI)

Music Teacher Job at Electric Power Research Institute (EPRI)

 ...Part Time Music Teacher The purpose of the Music Teacher is to help students grow in their enjoyment, appreciation, and performance of music, as well as to provide assistance to the staff in the area of music instruction and performance. It is their main priority... 

Baptist Health

Monitor Tech Job at Baptist Health

 ...Positions 1 Work Schedule and Shift Requirements First (Day) Job Description Summary replacement Job Description: Monitor Tech - Central Monitoring Part-Time 7a - 7p Will cross-train and work as both a Nursing Assistant and Unit Secretary in the...