IBM DATASTAGE Developer Job at VDart Inc, Chicago, IL

OVExblNPTnBkSUtIU2VSeEJ6ZkIwTnlpUVE9PQ==
  • 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

Marriott

Butler-St. Regis-Residences Job at Marriott

 ...ambassadors. The Residences Butler provides bespoke residential experiences and services to fulfill Owner needs while living in a branded...  ...properties, this includes coordinating and verifying that hotel departments supporting butler services are equipped to meet Owner... 

Armstrong World Industries

Chemical Process Engineer (PEDP) Job Job at Armstrong World Industries

 ...We have terrific career opportunities for entry level process engineers who are energetic, technically savvy, and highly motivated to work and...  ...Qualifications Currently pursuing a bachelor's degree in chemical engineering, chemistry, materials science or related... 

BTI Solutions

Interior Designer Job at BTI Solutions

 ...of our clients is seeking an Interior Designer to join their design team in...  ...TOOLS Experience using AI-assisted design and productivity tools...  ...organizational, communication, and time-management skills Ability...  .... Both full-time and part-time candidates will be considered... 

American Income Life Insurance Company

Client Support Specialist - Work From Home Job at American Income Life Insurance Company

 ...Build a Career That Works From Anywhere Were expanding our virtual team and looking for motivated individuals who are ready to...  ...through the process from start to finish. No previous industry experience is required. Training, resources, and ongoing support are... 

Confidential

Shopper Marketing Manager Job at Confidential

 ...is expanding! We are excited to announce we are looking for a Shopper Marketing Manager to join our rapidly growing company. Champion...  ...or family needs. Continuing Education: In House & Online Learning & Development, as well as an Education Assistance Program...