Sr Data Warehouse Architect

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Data Warehouse Architect ,Hybrid, MI

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

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 dat 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 methodologie

DIA SOFTWARE SOLUTIONS LLC.

DIVYA| DIA SOFTWARE SOLUTIONS LLC.

Direct: Two Four Eight Three Zero Six Nine Three Nine Three

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer