Data Warehouse Architect 3

Lansing, MI, US • Posted 1 hour ago • Updated 1 hour ago
Contract Independent
Contract W2
Contract Corp To Corp
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

👾 Reticulating splines...

Job Details

Skills

  • ETL Developer
  • ETL Architect
  • Data Warehouse Architect
  • Data Integration
  • IBM DataStage
  • IBM Cloud Pak for Data (CP4D)
  • Cloud Pak for Data
  • ETL Development
  • ETL Pipelines
  • Data Pipeline Development
  • Data Migration
  • Data Modernization
  • Data Transformation
  • Data Warehouse
  • Data Engineering
  • IBM InfoSphere DataStage
  • Parallel Jobs
  • Server Jobs
  • Job Sequencing
  • ETL Performance Tuning
  • SQL
  • Advanced SQL
  • Python
  • XML
  • Shell Scripting
  • Unix
  • Linux
  • Master Data Management (MDM)
  • Data Quality
  • Data Governance
  • Relational Databases
  • Agile
  • SDLC
  • Root Cause Analysis
  • Data Validation
  • Enterprise Data Solutions
  • State Government

Summary

Role: IT - CSS - EICIM - ETL – Data Warehouse Architect 3

Location: Lansing, MI

Duration: 12 Months

 

Description:

The ETL Developer is responsible for designing, developing, and maintaining high‑quality data integration solutions using IBM DataStage and related technologies. This role supports both on‑premise and cloud environments, contributes to enterprise data modernization efforts, and plays a key role in migrating DataStage workloads to IBM Cloud Pak for Data (CP4D). The developer will collaborate with technical and business teams to deliver reliable, scalable, and secure data pipelines aligned with organizational objectives.

 

Responsibilities and Technical Skills

  • Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
  • Support the migration of on‑premise DataStage jobs to IBM Cloud Pak for Data (CP4D), including code refactoring, testing, validation, and workflow modernization.
  • Use Python and XML to automate processes, perform data transformations, and integrate automation into ETL workflows.
  • Work extensively in Linux/Unix environments to write shell scripts, manage file systems, monitor processes, and troubleshoot runtime issues.
  • Apply Master Data Management (MDM) principles to ensure data quality, governance, and consistency across enterprise systems.
  • Develop complex SQL queries for data extraction, transformation, validation, and performance improvement across relational database platforms.
  • Work within Agile teams to support sprint activities, deployments, documentation, and continuous improvement practices.
  • Collaborate with data architects, analysts, DBAs, and business users to ensure successful and accurate delivery of data solutions.
  • Troubleshoot ETL issues, perform root‑cause analysis, recommend improvements, and ensure adherence to data standards and security policies.

 

Required Skills

  • 5+ years of experience ETL (IBM DataStage) - Required
  • 1+ years of exposure to Cloud Pak for data - Required
  • 5+ years of experience with Unix/Linux
  • 3+ years of experience with Master Data Management

 

Desired Skills

  • Previous Government experience

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91093837
  • Position Id: 8619-19746-
  • Posted 1 hour ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Lansing, Michigan

Today

Easy Apply

Third Party, Contract

Hybrid in Lansing, Michigan

Today

Easy Apply

Contract, Third Party

Depends on Experience

Hybrid in Lansing, Michigan

Today

Easy Apply

Contract, Third Party

Depends on Experience

Lansing, Michigan

Today

Easy Apply

Contract

Depends on Experience

Search all similar jobs