ETL (IBM DataStage) Data Warehouse Architect 3

PROLIM Global Corporation () is hiring a ETL (IBM DataStage) Data Warehouse Architect 3 for a leading government Client.

Job Title: ETL (IBM DataStage) Data Warehouse Architect 3
Location: Lansing, Michigan – Hybrid

Job Description
We are seeking an experienced ETL Developer / Data Warehouse Architect to support enterprise data modernization initiatives and the migration of IBM DataStage workloads to IBM Cloud Pak for Data (CP4D). The selected candidate will be responsible for designing, developing, and maintaining scalable and secure data integration solutions across on-premise and cloud environments.

The ideal candidate will have strong expertise in IBM DataStage, Unix/Linux administration, SQL development, Python scripting, and Master Data Management (MDM). This role requires close collaboration with technical and business teams to ensure reliable delivery of enterprise data solutions.

Key Responsibilities

·         Develop, enhance, and optimize ETL pipelines using IBM DataStage, including parallel and server jobs, job sequencing, and performance tuning.

·         Support 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 develop 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 optimization.

·         Participate in Agile development activities, including sprint planning, deployments, documentation, and continuous improvement initiatives.

·         Collaborate with data architects, analysts, DBAs, and business users to deliver accurate and scalable data solutions.

·         Troubleshoot ETL issues, perform root cause analysis, and ensure adherence to data standards and security policies.

Required Skills & Qualifications

·         5+ years of experience with ETL development using IBM DataStage (Required)

·         1+ year of exposure to IBM Cloud Pak for Data (Required)

·         5+ years of experience working in Unix/Linux environments

·         3+ years of experience with Master Data Management (MDM)

·         Strong knowledge of SQL development and performance tuning

·         Experience with Python scripting and XML processing

·         Experience supporting enterprise data integration and modernization initiatives.

·         Local Michigan candidates only – candidates must reside in Michigan at the time of submission.

·         Ability to work onsite two days per week (Monday & Tuesday) from Day 1.

Preferred Qualifications

·         Previous experience working with Government or Public Sector organizations.

·         Experience supporting enterprise data migration and modernization projects.

·         Familiarity with cloud-based data integration platforms and governance practices.

Interested Candidates

Please send your updated resume and contact details to:

About PROLIM Corporation

PROLIM is a leading provider of end-to-end IT, PLM, and Engineering Services and Solutions for Global 1000 companies. We understand business as much as technology and help our customers improve profitability and efficiency through high-value consulting, staffing, engineering, and project management services.

Our offerings include Advisory Services, PLM Software & Services, Program Management, Solution Architecture, Training & Staffing, Cloud Solutions, Infrastructure Services, ERP Practices, Quality Assurance Services, and Engineering Services across a wide range of industries.