Job ID: 161004
Position: ETL - Data Warehouse Architect
Duration: 12 months Contract
Location: Lansing, MI (Locals Only)
Direct Client: State of Michigan
Note from the client:
· In-Person interviews will be conducted July 20th and 21st
· This is a 6-month project ending 02/10/2027. The person for this project will be supporting the migration of two IBM tools (from ATL DataStage to Cloud Pak)
· Previous Govt Experience is highly desired.
· Candidate must be available for Onsite from Day 1, Tue/Wed mandatory, may transition to 5 days onsite)
· Interview Process: Vendor required to upload screenshot picture of candidate if interview is requested.
· Must be able to work onsite Tuesday & Wednesday each week (8 hours per day).
· Must be willing to transition to 5 days onsite if required (no remote-only option).
Max rate is $80/hrs all inclusive on Corp to Corp
Top Skills & Years of Experience:
- 5+ years of experience with ETL (IBM DataStage) - Required
- 1+ years of exposure to Cloud Pak for data - Required
- 5+ years of experience with Unix/Linux
- 3+ years of experience with Master Data Management
Description: The ETL Developer is responsible for designing, developing, and maintaining high‑quality data integration solutions using IBM DataStage and related technologies. This role supports both on‑premise and cloud environments, contributes to enterprise data modernization efforts, and plays a key role in migrating DataStage workloads to IBM Cloud Pak for Data (CP4D). The developer will collaborate with technical and business teams to deliver reliable, scalable, and secure data pipelines aligned with organizational objectives.
Responsibilities and Technical Skills
· Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.
· Support the migration of on‑premise DataStage jobs to IBM Cloud Pak for Data (CP4D), including code refactoring, testing, validation, and workflow modernization.
· Use Python and XML to automate processes, perform data transformations, and integrate automation into ETL workflows.
· Work extensively in Linux/Unix environments to write shell scripts, manage file systems, monitor processes, and troubleshoot runtime issues.
· Apply Master Data Management (MDM) principles to ensure data quality, governance, and consistency across enterprise systems.
· Develop complex SQL queries for data extraction, transformation, validation, and performance improvement across relational database platforms.
· Work within Agile teams to support sprint activities, deployments, documentation, and continuous improvement practices.
· Collaborate with data architects, analysts, DBAs, and business users to ensure successful and accurate delivery of data solutions.
· Troubleshoot ETL issues, perform root‑cause analysis, recommend improvements, and ensure adherence to data standards and security policies.
Regards,
Subhash @ Techridge .net
Never miss an opportunity! Create an alert based on the job you applied for.