Direct Client: Senior ETL Developer @ Lansing, MI – Hybrid – Locals Preferred

KSN Technologies. Inc; Lansing (MI); Hybrid; USD 90,000 - 140,000; Full time

Job summary

MDHHS/DTMB Analytics and Visualization Division in Lansing, MI is seeking a Senior ETL Developer for a one-year contract. The role focuses on IBM DataStage, IBM Cloud Pak for Data (CP4D), and Teradata 20, with responsibilities for migrating workloads to CP4D and building robust ETL pipelines.

You will provide technical leadership on data quality, governance, and integration, develop SQL and BTEQ scripts, create automation with Python, Shell, and XML, and collaborate with architects, DBAs,

Qualifications

• Requires IBM DataStage, CP4D, and Teradata 20 experience.
• Strong SQL and performance tuning abilities; experience with large enterprise datasets.
• Unix/Linux scripting and shell skills; automation experience.
• Experience with data governance, data quality, and Master Data Management (MDM).

Responsibilities

• Design, build, enhance, and optimize ETL pipelines using IBM DataStage (parallel/server jobs, performance tuning, job sequencing).
• Support migration of DataStage workloads to CP4D, including refactoring and validation.
• Develop and optimize SQL and BTEQ scripts for Teradata 20.
• Create automation scripts using Python, Shell, and XML for ETL workflows.
• Apply MDM and data governance principles to ensure data quality.
• Collaborate with MDHHS data architects, DBAs, analysts and business owners to align deliverables.
• Troubleshoot ETL issues and support Agile delivery.

Skills

Unix/Linux scripting

SQL

Python

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

IBM DataStage

IBM Cloud Pak for Data (CP4D)

Teradata 20

Python

Shell scripting

XML

MDM

Job description

Senior ETL Developer

Lansing, MI Hybrid Locals Preferred

One Year Contract

We are looking for candidates who can work on our W2.

No C2C/1099.

Job Summary

The MDHHS/DTMB AS Analytics and Visualization Division is seeking a Senior ETL Developer with extensive experience in IBM DataStage, IBM Cloud Pak for Data (CP4D), and Teradata 20. The resource will support enterprise data modernization efforts, including migration of legacy workloads to CP4D, development of robust ETL pipelines, and technical leadership for data quality, governance, and integration initiatives. This role requires strong analytical capabilities, advanced ETL engineering skills, and the ability to work effectively across complex enterprise environments.

Key Responsibilities

• Design, build, enhance, and optimize ETL pipelines using IBM DataStage (parallel/server jobs, performance tuning, job sequencing).
• Support the migration of DataStage workloads from on premise environments to IBM Cloud Pak for Data (CP4D), including refactoring, modernization, testing, and validation.
• Develop and optimize complex SQL and BTEQ scripts for Teradata 20, supporting large-scale data integrations and analytics workloads.
• Create automation scripts using Python, Shell scripting, and XML for ETL workflows and data processing.
• Apply Master Data Management (MDM) and data governance principles to ensure consistency, quality, and reliability across systems.
• Work collaboratively with MDHHS data architects, DBAs, analysts, business owners, and technical teams to align deliverables with program objectives.
• Conduct troubleshooting, root cause analysis, and remediation activities for ETL pipeline issues.
• Support Agile delivery, including sprint participation, documentation, testing, and continuous improvement activities.

Required Skills

• -1+ years of hands-on experience with IBM Cloud Pak for Data (CP4D).
• -3+ years of strong experience with Teradata 20, including SQL/BTEQ, performance optimization, and working with large enterprise datasets.
• - 5+ of Unix/Linux scripting and system operations
• 3 + years of Advanced SQL for analysis and ETL support

Preferred Skills

• -Public health, Health Industry, or State Government experience

Required Education

• - Bachelor s degree in computer science, Information Systems, Data Analytics, or related field.

Other desired Skills

• 5+ years of experience developing ETL solutions using IBM DataStage.
• Proficiency in:
• Python for automation
• MDM, data quality, and data governance methodologies
• Proven ability to translate business and technical requirements into scalable ETL and data integration solutions.
• Experience in large, complex enterprise data environments with multiple data sources.

• Prior experience supporting State of Michigan projects or other public-sector environments.
• Knowledge of IBM Knowledge Catalog (metadata, lineage, governance).
• Exposure to IBM Manta for lineage and impact analysis.
• Familiarity with cloud-native platforms such as OpenShift or Kubernetes.
• Experience with CI/CD pipelines, version control, and Agile methodologies.