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

Joby Aviation

Staff Operational Test Pilot - Advanced Development Job at Joby Aviation

 ...Overview Joby Advanced Development designs, develops, and flight-tests novel aircraft using a software-first autonomy approach. We...  ...Overview Joby Aviation is seeking a Staff Operational Test Pilot to serve as a senior technical authority for operational evaluations... 

Glacier Bancorp

Loan Documentation Specialist Job at Glacier Bancorp

 ...About The Role POSITION SUMMARY: This position is responsible for ensuring collateral perfection and tracking, completing loan files reviews, various loan collateral and type reporting as well as providing back up for the Loan QC Manager and Loan Document Drafting... 

Confidential

Wholesale Distributor Branch Manager Job at Confidential

 ...analyze, and track purchases. Monitor market conditions and customers' needs to maintain appropriate inventory levels and identify opportunities to increase sales. Ensure the branch is clean, organized, professional, and inviting to customers. Conduct weekly staff... 

MSD

Associate Specialist, Engineering Job at MSD

 ...Process Support Lab at the Durham site is seeking an Associate Specialist with strong interpersonal, communication, and collaboration...  ...Education Minimum Requirement: ~ Bachelors Degree or higher in Engineering or Sciences, with relevant academic experience with at least... 

DOCTORS CHOICE PLACEMENT SERVICES, INC.

Plastics - Hand Surgery Physician Job at DOCTORS CHOICE PLACEMENT SERVICES, INC.

Plastic/Hand Surgery Opportunity in Metro Louisville, Kentucky Full-Time Positions Available - Joining very busy/thriving well-established full-spectrum Plastic Surgery practice (4 Plastic Surgeons). Seeking BC/BE Fellowship Trained Plastic/Hand Surgeon - New Grads...