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

BJC Healthcare

Interventional Radiology Technologist Job at BJC Healthcare

 ...Overview Missouri Baptist Medical Center , an acute care hospital in St. Louis County, offers a full continuum of medical and surgical...  ...separate emergency department in collaboration with St. Louis Childrens Hospital. Missouri Baptist is the first and only hospital... 

PrideStaff

Marketing Assistant Job at PrideStaff

 ...and manage digital marketing campaigns across various channels Manage and optimize all social media accounts Analyze digital advertising campaigns Video Editing and Design Create and distribute engaging, high-quality content Stay updated on digital... 

Joy Memories

Christmas Photo Set Manager-Laurel Park Job at Joy Memories

 ...Job Description Job Description Love the Holidays? Want to work alongside Santa Claus? Weve got a job for you! VIP Holiday...  ...needs your help to make children's dreams come true this coming Christmas season. WHY WORK WITH VIP HOLIDAY PHOTOS? VIP Culture:... 

Boston Children's Hospital

Physical Therapist I, Pelvic Floor, Waltham 20 hours Job at Boston Children's Hospital

 ...state of MA. **New hires are eligible for a $2,500 sign-on bonus, and part-time benefits The posted pay range is Boston Childrens reasonable and good-faith expectation for this pay at the time of posting. Any base pay offer provided depends on skills, experience... 

AbbVie

Scientific / Medical Director, Global Hematology Pipeline, Medical Affairs Job at AbbVie

 ...Scientific / Medical Director, Global Hematology Pipeline, Medical AffairsFull-timeSalary Min: 160500Therapy Area: OncologySalary Max: 305000Workday Global Grade: 21Travel: Yes, 25% of the TimeCompensation: USD 160,500 - USD 305,000 - yearlyAbout AbbVieAbbVie'...