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

2T Consulting

Senior Consultant - Infrastructure / Mainframes - VTAM Job at 2T Consulting

 ...vendor software implementation. ExecuteSMPE and non-SMPE installationsof ISV products. Install, configure, maintain, and upgradeIBM and Broadcom software products. Performz/OS operating system upgrades and RSU maintenanceusing z/OSMF workflows. Architect,... 

Energy Job Shop

Assistant Driller, Helper Job at Energy Job Shop

 ...who enjoy physical work, are safety-focused, and are eager to grow their careers in the environmental drilling industry. No prior experience is required, making this a great entry-level opportunity.Perks & Benefits Competitive wages: $20.00 - $25.00 per hour (higher... 

Pacifico Energy Group

Office Coordinator / Recruiting & HR Assistant Job at Pacifico Energy Group

 ...Job description Position Summary: Pacifico Energy Group is seeking a tech-savvy, proactive, and highly organized Office Coordinator & Recruiting/HR Assistant to be the welcoming face at our front desk and the engine behind our growing office. This is a full-time... 

LRES

Senior Biostatistician Job at LRES

 ...Employment Opportunities Designed to Help Us Collaborate in Creation! Senior Biostatistician Thank you for your interest in Loyola University Chicago. To view open positions, please enter your search criteria below. You may view all open positions by not specifying... 

Bruflat Services LLC

Home Remodel Professional - Mr. Handyman of Lee's Summit Job at Bruflat Services LLC

 ...Description Job Description Are you ready to join a team that answers all customer calls for you and fills your schedule? At Mr. Handyman were growing our team of professionals so we can continue to be one of the most well-respected home repair and maintenance...