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

Wall Colmonoy Limited

Furnace Operator Job at Wall Colmonoy Limited

 ...Functions Ability to Charge Making.Ability to Powder Process.Can troubleshoot alloys and equipment.Operate, monitor, and maintain furnaces and equipment to produce a quality product (established and or experimental) in a safe, clean and professional manner.Prepares... 

Idahoan Foods

Paid HS Internship: Heavy Equipment Parts & Service Job at Idahoan Foods

 ...A leading heavy equipment company is offering a paid part-time internship in Pflugerville, Texas, aimed at high school students interested in the heavy equipment industry. Interns will gain hands-on experience by shadowing technicians, assisting in the parts department... 

Perry Health Inc

Multi-State Remote RD, CDCES - Contracted Position Job at Perry Health Inc

 ...rethinking chronic care through a fully remote, continuous care model. We provide expert diabetes education and clinical management for Medicare patients, delivered by a comprehensive team of specialized Registered Nurses, Registered Dietitians, and Accountability Coaches.... 

Butternut Mountain Farm

Experienced Production Operator - Maple Syrup Packaging Year-Round | 4-Day Workweek | Morrisville, Vermont Job at Butternut Mountain Farm

 ...Mountain Farm is one of the largest packers of pure maple syrup in the United States. We operate a year-round food manufacturing and packaging facility in Morrisville, Vermont. We're looking for experienced production employees who want more than just a job running... 

ChildServe

School to Work Intern Job at ChildServe

This application is for high school students who have been pre-approved for placement in the School to Work program at ChildServe.