DataStage​/ETL Developer - CSS

Client Name Michigan Center for Shared Solutions (CSS)

Requisition 161004

Location Lansing, MI

Duration 6 months

Due Date 07/14/2026

C2C Possible Yes. Rate depends on experience

Interview Method On-site in Lansing

NOTE:
Local candidates ONLY candidates must be located in Michigan at time of submission. Relocation not allowed. Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. ((Monday/Tuesday). We can accept H1b, H4, TN and other valid work visas for IT. However we cannot accept OPT or CPT visas at this time.

Our client is looking for a Data Stage/ETL Developer who is responsible for designing, developing, and maintaining high-quality data integration solutions using IBM Data Stage 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 Data Stage 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.

• Develop, enhance, and optimize ETL pipelines using IBM Data Stage, including parallel and server jobs, job sequencing, and performance tuning.
• Support the migration of on-premise Data Stage 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.

• 5+ years
  - Experience with ETL (IBM Data Stage)
• 1+ years
  - Experience with Cloud Pak for data
• 5+ years
  - Experience with Unix/Linux
• 3+ years
  - Experience with Master Data Management