Position- Data Warehouse Architect 3/ETL Developer
Location- Lansing, MI (LOCALS ONLY)
Rate- $70/hr on W2
In-Person interviews will be conducted July 20th and 21st
Duration: 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)
Hybrid: Resource will be working a hybrid schedule 2 days office in week
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
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.
Required Skills
- 5+ years of experience 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
Desired Skills
- Previous Government experience