Data Warehouse Architect (IBM Cloud Pak for Data (CP4D), Teradata 20, including SQL/BTEQ, Unix/Linux, Advanced SQL for analysis and ETL support - In person interview must - michigan

Hybrid in Lansing, MI, US • Posted 3 hours ago • Updated 3 hours ago
Contract Independent
Contract W2
12 Months
Hybrid
Depends on Experience
Company Branding Image
Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

  • IBM Cloud Pak for Data (CP4D)
  • Teradata 20
  • SQL/BTEQ
  • Unix/Linux
  • Advanced SQL for analysis
  • ETL support
  • Master Data Management (MDM)
  • XML
  • ETL workflows
  • data processing
  • Python
  • Shell scripting

Summary

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.

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 onpremise 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, rootcause analysis, and remediation activities for ETL pipeline issues.
  • Support Agile delivery, including sprint participation, documentation, testing, and continuous improvement activities.
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: 91162806
  • Position Id: 9051626
  • Posted 3 hours ago

Company Info

About HPTech Inc.

HPTech Inc has grown to become a premier provider of IT consulting services for technology. With a specialized niche in transaction and data warehousing applications, HPTech Inc helps clients implement mission-critical, enterprise solutions, speed conversion from legacy environments, and optimize the benefits inherent in their systems. Our consulting solutions range from project strategy and planning, software assessment and selection, to implementation and integration, hosting and change management, support and maintenance translating to higher productivity, lower costs.

Contact the job poster
HK

Hari Krishna

Recruiter @ HPTech Inc.
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Lansing, Michigan

3d ago

Easy Apply

Contract

Depends on Experience

Hybrid in Harrisburg, Pennsylvania

Today

Easy Apply

Contract

Depends on Experience

Search all similar jobs