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

Employer Services USA

Nursing Home Administrator Job at Employer Services USA

 ...Job Description Job Description Description: CHECOTAH NURSING AND REHABILITATION IS LOOKING FOR A QUALIFIED ADMINISTRATOR TO JOIN...  ...Requirements: Qualifications: A current, valid state nursing home administrator license is required. Thorough knowledge of... 

Claxton Dietetic Solutions

Registered Dietitian Nutritionist Job at Claxton Dietetic Solutions

 ...Claxton Dietetic Solutions, LLC is hiring a Registered Dietitian to provide clinical nutrition services within a long-term care and rehabilitation environment. This hybrid, part-time position is approximately 12 hours per week. Additional hours, including PRN opportunities... 

SRI Tech

UI Path resource Job at SRI Tech

 ...Tech SolutionsRole:- UI Path resourceLocation- Las Vegas, NV (Hybrid)Expertise with 8+ years of experience in RPA toolsExpertise in UiPath development for more than +6 yearsHighlight Risk and Issues throughout the project life cycle to the respective Project Manager.... 

Lycoming College

Public Safety Officer Job at Lycoming College

 ...Lycoming College is hiring a Public Safety Officer! This is a full-time position within the Office of Public Safety. Public safety officers perform a variety of safety and security-related functions involved in the safeguarding of students, employees, visitors, and... 

FISH SHOP

Butcher Job at FISH SHOP

Primary Responsibilities: Prepare, cut, and portion meat to specification, ensuring consistency and minimizing waste. Set up and prepare assigned station. Recreate recipes/dishes as provided by the chef. Communicate with the team regarding pars to keep the ...