DataStage Developer – Engineer

Role Overview

• Design, develop, and maintain ETL jobs using IBM InfoSphere DataStage.
• Build and optimize data pipelines for Medicaid/MMIS data processing and reporting.
• Extract, transform, and load data from multiple sources including mainframe, relational databases, and external systems.
• Collaborate with data architects to implement scalable and reusable ETL frameworks.
• Perform data cleansing, validation, and transformation to ensure data quality and integrity.
• Optimize job performance and troubleshoot ETL failures and data issues.
• Work with large datasets including claims, eligibility, provider, and reference data.
• Support data integration between legacy systems, data warehouses, and cloud environments.
• Develop and maintain documentation for ETL processes and data mappings.
• Participate in testing, deployment, and production support activities.

Requirements

• 5–8+ years of experience in ETL development with IBM InfoSphere DataStage.
• Experience with Unix/Linux and shell scripting
• Strong experience in Medicaid/MMIS data environments.
• Proficiency in SQL and relational databases (DB2, Oracle, SQL Server, etc.).
• Experience working with large-scale data warehouses and data marts.
• Knowledge of data modeling concepts and ETL design patterns.
• Experience integrating data from mainframe and on-premise systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and collaboration skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field.

Tech Stack

• Cloud
• ETL
• Linux
• Oracle
• Shell Scripting
• SQL
• Unix