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

Legacy CPAs, LLC

Audit Associate Job at Legacy CPAs, LLC

 ...We are hiring for an Audit Associate to work out of Indianapolis. This is a hybrid role working from client offices and remotely as Legacy does not have a physical office in Indianapolis. About Us: We are a Chicagoland-based CPA firm with offices in Westchester... 

Telecare

Psych Hospital Administrator - Behavioral Health 155 Job at Telecare

 ... - Client from Telecare What You Will Do to Change LivesThe Administrator is a key position in driving the organizations success. They...  ...systems. Heritage Psychiatric Health Facility (PHF) is a 26-bed hospital providing acute psychiatric treatment to adults over the age... 

PwC

Financial Services Tax - Real Estate Manager Job at PwC

 ...Demonstrating proficiency in financial statement analysis and tax auditing Utilizing analytical thinking to monitor and analyze...  ...hired individuals are eligible for an annual discretionary bonus. PwC offers a wide range of benefits, including medical, dental, vision... 

Carney, Sandoe & Associates

Computer Science Teacher Job at Carney, Sandoe & Associates

 ...Carney, Sandoe & Associates , an education recruitment firm, is currently seeking Computer Science Teacher for the 2027-2028 school year at independent schools in the Washington D.C. area . About CS&A: Our free job placement service connects educators with... 

Stride

Middle School Computer Science Teacher Job at Stride

 ...Job Description Certificates and Licenses: Alabama Computer Science Teaching Certificate ~ If the current Teaching Certification...  ...an annual bonus. Start Date - ASAP The remote CTE Teacher is a highly qualified, state certified educator responsible for...