Agile Programming Methodologies, Architectural Analysis, Automation, C++ Active Template Libraries (ATL), Cloud Computing, Continuous Improvement, Data Analysis, Data Processing, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, File Management, File Systems, IBM Product Family, IBM WebSphere DataStage, Identify Issues, Information/Data Security (InfoSec), Linux Operating System, Maintain Compliance, Master Data Management (MDM), Multiplatform/Cross-Platform, Performance Management, Performance Tuning/Optimization, Python Programming/Scripting Language, Refactoring, Relational Databases (RDBMS), Root Cause Analysis, SQL (Structured Query Language), System Migration, Systems Administration/Management, Unix Operating Systems, Unix Shell Programming, Validation Testing, XML (EXtensible Markup Language)
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