Senior ETL Architect – Teradata, CP4D & DataStage Lead

COOLSOFT; Michigan; Hybrid; USD 90,000 - 120,000; Full time

Job summary

COOLSOFT is seeking a Senior ETL Architect to design, implement, and optimize DataStage-based ETL pipelines. The role includes migrating on‑prem DataStage workloads to IBM Cloud Pak for Data (CP4D) and building scalable data integrations acrossTeradata 20 environments.

You will develop complex SQL/BTEQ scripts, automate ETL workflows with Python, Shell, and XML, and apply MDM and data governance across enterprise data assets. Strong collaboration with MDHHS data teams is required.

Qualifications

• Bachelor's degree in CS, IS, data analytics, or related field.
• Experience with IBM DataStage ETL development.
• Exposure to CP4D and Teradata 20 is preferred.

Responsibilities

• Design, build, and optimize ETL pipelines with IBM DataStage.
• Support migration of DataStage workloads to CP4D.
• Develop SQL/BTEQ queries for Teradata 20.
• Create automation scripts in Python, Shell, XML.
• Apply MDM and data governance principles across systems.
• Collaborate with data architects, DBAs, analysts, and business owners.
• Troubleshoot ETL issues and perform root cause analysis.
• Support Agile delivery and continuous improvement.

Skills

CP4D experience

Teradata 20

Unix/Linux scripting

Advanced SQL

Education

Bachelor's degree in Computer Science or related field

Tools

IBM DataStage

Python

Shell scripting

Job description

COOLSOFT is seeking a Senior ETL Architect to design, implement, and optimize DataStage-based ETL pipelines. The role includes migrating on‑prem DataStage workloads to IBM Cloud Pak for Data (CP4D) and building scalable data integrations acrossTeradata 20 environments.

You will develop complex SQL/BTEQ scripts, automate ETL workflows with Python, Shell, and XML, and apply MDM and data governance across enterprise data assets. Strong collaboration with MDHHS data teams is required.