IBM DATASTAGE Developer Job at VDart Inc, Chicago, IL

  • VDart Inc
  • Chicago, IL

Job Description

Title: IBM DataStage Developer

Location: Chicago, IL

Type: Sub-contract

Job Summary
We are seeking an experienced IBM DataStage ETL Developer with 8+ years of hands-on experience designing, developing, and supporting enterprise data integration solutions. The ideal candidate understands business requirements and mapping documents, translating them into scalable end-to-end ETL applications using IBM DataStage, with strong SDLC knowledge and a proven track record of delivering high-quality data solutions.

Key Responsibilities

  • 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 JSON files using DataStage Hierarchical Stages
  • Implement robust data quality checks - structural, data type, and business rule validations
  • Troubleshoot ETL failures, address L1/L2 escalations, conduct root cause analysis, and implement preventive measures
  • Use Unix shell scripting, Control-M scheduling, ServiceNow, JIRA/ADO, and Confluence for automation, monitoring, incident management, and documentation
  • Collaborate with SMEs, Business Analysts, Architects, and Development teams to deliver reliable, compliant, efficient data integration solutions
  • Drive operational excellence through automation and continuous improvement

Required Skills

  • Data Architecture
  • ETL Concepts
  • IBM InfoSphere DataStage (IIS-DataStage)
  • Oracle, SQL (complex query writing)
  • Unix shell scripting
  • Control-M scheduling
  • ServiceNow, JIRA/ADO, Confluence
  • Strong SDLC background
  • Production support / L1-L2 troubleshooting experience

Experience

  • 10-14 years overall (8+ years hands-on DataStage ETL development)

Job Tags

Contract work

Similar Jobs

Cigna Healthcare

AI/ML Engineer Intern Job at Cigna Healthcare

 ...with AI/ML Engineering Bring your curiosity, engineering skills, and bold ideas to Evernorth Health Services, a division of The Cigna Group. This internship is a foundational development opportunity for emerging AI/ML engineers ready to build scalable solutions for... 

Ruby Labs

UX Researcher Job at Ruby Labs

 ...passionate individuals to join us. Learn more about our story at: About the role Were looking for a sharp, user-focused UX Researcher to help shape and improve the overall player experience. Youll act as the voice of the user by conducting research, uncovering... 

Sonsoft

IBM Datastage Developer Job at Sonsoft

 ...modeling / database design(Oracle and DB2 preferred)At least 4 years of hands on experience in Design, Development & Build activities in IBM Datastage(v8.5 and above) ETL ProjectsAt least 3 years of experience in software development life cycle At least 3 years of... 

Clinical Support Staff

Farm Assistant Job at Clinical Support Staff

 ...Full-Time Farm Assistant Our hospital is seeking a full-time farm assistant to help provide outstanding patient care and client service...  ...in the care of equine patients. The farm assistant will work closely with the veterinarians and technicians to help ensure all... 

My BTLR

Fractional CFO Job at My BTLR

 ...highly experienced and strategic Fractional Chief Financial Officer (CFO) for placement with a client. This contract/1099 position involves providing financial leadership and expertise on a part-time basis, working closely with the client's executive team to drive financial...