Data Warehouse Architect 3 / IBM DataStage ETL Developer

Location: Lansing, MI (Hybrid - 2 Days Onsite)

Duration: 6+ Months Contract (Possible Extension)

Job Overview

We are seeking an experienced IBM DataStage ETL Developer to design, develop, and maintain enterprise data integration solutions supporting large-scale data modernization initiatives. The ideal candidate will have strong expertise in IBM DataStage, ETL development, data migration, SQL, Linux/Unix, and cloud-based data platforms. This role involves developing scalable, high-performance data pipelines while supporting migration to modern cloud data environments.

Key Responsibilities

• Design, develop, enhance, and optimize ETL solutions using IBM DataStage.
• Develop and maintain parallel jobs, server jobs, job sequences, and reusable ETL components.
• Support migration of on-premises IBM DataStage workloads to IBM Cloud Pak for Data (CP4D).
• Refactor, test, validate, and modernize ETL workflows for cloud deployment.
• Develop automation solutions using Python, XML, and shell scripting.
• Work in Linux/Unix environments to manage ETL execution, file systems, scheduling, and troubleshooting.
• Develop complex SQL queries for data extraction, transformation, validation, and performance optimization.
• Apply Master Data Management (MDM) principles to improve data quality, governance, and consistency.
• Collaborate with data architects, database administrators, business analysts, and technical teams to deliver reliable data integration solutions.
• Troubleshoot ETL failures, perform root cause analysis, and implement performance improvements.
• Create and maintain technical documentation, deployment procedures, and ETL design artifacts.
• Participate in Agile ceremonies, sprint planning, code reviews, and continuous improvement initiatives.

Required Qualifications

• 5+ years of hands-on experience developing ETL solutions using IBM DataStage.
• Experience with IBM Cloud Pak for Data (CP4D).
• 5+ years of experience working in Linux/Unix environments.
• Strong SQL development skills, including query optimization and data validation.
• Experience with Python, XML, and shell scripting for automation.
• 3+ years of experience with Master Data Management (MDM) concepts and implementations.
• Experience designing scalable, secure, and high-performance ETL workflows.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration abilities.
• Experience working within Agile development environments.

Preferred Qualifications

• Experience supporting enterprise data modernization initiatives.
• Experience migrating ETL workloads from on-premises environments to cloud platforms.
• Previous experience supporting government or public-sector projects.
• Experience with enterprise data governance and data quality initiatives.

Desired Skills

• IBM DataStage
• ETL Development
• IBM Cloud Pak for Data (CP4D)
• Data Integration
• Data Migration
• Linux
• Unix
• Shell Scripting
• Python
• XML
• SQL
• Performance Tuning
• Master Data Management (MDM)
• Data Warehousing
• Data Quality
• Data Governance
• Agile
• Root Cause Analysis
• Enterprise Data Architecture
• Cloud Data Platforms