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

Mainstay Suites

Hotel Front Desk Receptionist Job at Mainstay Suites

 ...on peoples faces? Then you might be an excellent fit for the hotel front desk agent position on our guest services team! Youll welcome...  ...the hospitality industry as a hotel front desk agent, hotel receptionist, or guest service specialist preferred ~ Working knowledge... 

vaaridatech

IBM Maximo Developer Job at vaaridatech

 ...Role- IBM Maximo Location - Dallas TX (onsite) Job type- W2 Contract Job description Below Experience: 3-7 years; junior candidates with relevant experience may also be considered. Hands-on experience in IBM Maximo development and customization... 

Cynet Health

Travel CT Tech - $2,721 per week in Rhinebeck, NY Job at Cynet Health

 ...CT). A BLS certification is also necessary. Candidates should have a minimum of one year of experience on Siemens scanners. Weekend overnight shifts are Friday, Saturday, and Sunday from 7:00 PM to 7:00 AM. There is no on-call requirement or floating between units.... 

DRT Holdings, LLC

Tool Maker Lead - CNC Milling & Turning Job at DRT Holdings, LLC

 ...DRT Aerospace is seeking an experienced Tool Maker to support our aerospace manufacturing...  ...a hands-on role where you'll apply your machining expertise to solve problems, improve...  ...manufacturing experience ~ Strong CNC milling and turning experience ~ Ability to machine parts... 

CentiMark

Roofer Job at CentiMark

 ...CentiMark Corporation, the national leader in the commercial roofing industry, has exceptional opportunities for experienced Commercial Roofers in Chelmsford, MA. CentiMark Corporation is North America's largest commercial roofing contractor with 100 offices and...