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

INTEGRITY HEALTHCARE SERVICES LLC

Registered Nurse (RN) Job at INTEGRITY HEALTHCARE SERVICES LLC

 ...Careers Advancement Job Summary We are seeking a Registered Nurse to join our team. In this role, you will primarily be creating...  ...client care skills Valid drivers license First aid/CPR certification required Flexible work from home options available.... 

The Spokesman-Review

Home Delivery Assistant Job at The Spokesman-Review

 ...The Spokesman-Review, a family-owned newspaper in the Inland Northwest, is seeking Home Delivery Assistants to join their team! Remember the times of paper deliverers riding bicycles down neighborhood streets to deliver your local news? They're not over yet! Our very own... 

Praxis Tech

Social Media Content Creator Job at Praxis Tech

 ...Role OverviewThe Social Media Content Creator will be responsible for creating engaging content for BetMGM's social media channels, including posts, videos, and campaigns.About BetMGMBetMGM is a leading iGaming operator with a growing presence in the US market.Location... 

Energy Job Shop

Assistant Driller Job at Energy Job Shop

 ...No Experience Driller Assistants - Exploration - Entry Level - Baton Rouge, LATerracon is seeking Driller Assistants/Exploration Team Members...  ...entry-level opportunity is ideal for candidates eager to learn field operations and equipment maintenance in a collaborative... 

RICEFW Technologies

Account Manager - REMOTE Job at RICEFW Technologies

 ...Account Manager . REMOTE Roles & Responsibilities: Serve as the primary point of contact with the State agency contract manager . Act as the contract liaison for the State agency leadership team . Ensure ongoing fulfillment of...