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

Genesis Oral Surgery & Implant Center

Dental receptionist / admin Job at Genesis Oral Surgery & Implant Center

 ...Professionalism Starts with You: Join Us as an Experienced Dental Receptionist We are seeking a high-caliber Experienced Dental Receptionist to serve as the vital first point of contact for our oral surgery and implant center. In this role, you will be responsible for... 

Geisinger

RN-Experienced Registered Nurse-Advanced Acute Care Units (Danville) Job at Geisinger

 ...care as established in unit standards including, patient and family education, family needs and discharge planning throughout hospitalization with members of the interdisciplinary team. Provides direct patient care including, treatments, medications, and diagnostic... 

gobravvo

Remote Mobile Game QA Tester | Flexible Hours Job at gobravvo

 ...gobravvo is seeking a motivated Mobile Game Tester to join its remote quality assurance team. This full-time role focuses on evaluating user experience and testing mobile games across devices, delivering actionable feedback for continuous improvement. The tester will... 

Aria Care Partners

Traveling Registered Dental Hygienist - Nursing Home Care Job at Aria Care Partners

 ...Full-time Description Aria Care Partners is the national leader in providing onsite dental, vision, hearing, and podiatry care to over 3500 long-term care and skilled nursing facilities across 25 states. Aria Care Partners believes that our clinicians should be... 

Alts

Tailor Job at Alts

 ...Tailor PositionAlteration Specialists is looking for Tailors in NYC, Hoboken, NJ & Greenwich, CT. We are looking for a dynamic professional Tailors, distinguished by their charisma, technical prowess, and professional integrity. This role will include sewing on the machine...