ETL Developer Job at Codetech Inc, Michigan

WnNHUTBncjRFR2U0Z2toVStOM1BaVWVZREE9PQ==
  • Codetech Inc
  • Michigan

Job Description

Job ID: 164300

Title: Data Warehouse Architect

Location: Lansing, MI (Locals)

Duration: 12+ months

Client: State of MI

Rate: $85/hr C2C

Description:

Client 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.

Job Tags

Local area

Similar Jobs

LBU Community Clinic

Grants Manager, Private & Federal Job at LBU Community Clinic

 ...Difference Card LBU funds part of your deductible for eligible in-network medical expenses. What you WILL DO: As a Grants Manager (Private& Federal) , you will lead the full lifecycle of grant development researching prospects, preparing and submitting... 

UnitedHealth Group

Pharmacy Technician Job at UnitedHealth Group

 ...Genoa we become their voice, their partner. Working as part of a coordinated care team, we...  ...Our personalized services - in-clinical pharmacies, medication management and more - are...  ...Growing together. We seek a Pharmacy Technician to support all functions of the Genoa... 

Elevare Branding

Public Relations Specialist Job at Elevare Branding

 ...connections with their audiences. We are looking for a talented Public Relations Specialist who thrives in a collaborative environment...  ...projects. Paid time off and company-recognized holidays. Comprehensive benefits package based on company policy.... 

Caring Professionals

Med Aide Job at Caring Professionals

 ...Job Description Tekakwitha Living Center is currently seeking a Medication Aideto join our vibrant team. Thisindividual must have a good work ethic that can establish trust and build excellent rapport with our residents and their family.Follows company policies and... 

Bobcat Transport

CDL Driver Dedicated Team Lease Great Lanes Own truck in 2 yrs Job at Bobcat Transport

 ...Need Class A drivers with 6 months or more experience ~ No SAP drivers Looking for pre made teams only All dry van no touch freight Small company with dedicated freight...  ...If you are a team and want to own your truck in less than 2 years Apply today limited...