Return To Search
DataStage Developer
Location: Lansing, MI
Job Type: Contract
Company: IDR
Category: All Other
IDR is seeking a DataStage Developer to join one of our top clients for a remote opportunity. This client operates within the public sector, focusing on critical data integration projects for state agencies. The role involves designing, developing, and maintaining ETL workflows to support data warehousing and reporting initiatives.
Position Overview for the DataStage Developer:
- Support and maintain parallel and sequence ETL jobs using IBM InfoSphere DataStage.
- Extract, transform, and load data into a Medicaid data warehouse and decision support platform.
- Collaborate with data architects, analysts, and stakeholders to ensure data quality and integration standards are met.
- Troubleshoot ETL job failures, resolve data issues, and optimize performance of data pipelines.
- Create technical specifications, update data mapping, and support production workflows to ensure timely data loads.
Requirements for the DataStage Developer:
- Expert-level experience with IBM InfoSphere DataStage, including building, optimizing, and troubleshooting ETL jobs.
- Strong SQL proficiency, with the ability to write complex queries, validate transformations, and tune performance across large datasets.
- Hands-on Linux/Unix shell scripting experience for automation, file management, and job orchestration.
- Solid understanding of data warehousing and BI concepts, including source-to-target mapping and data modeling.
- Proven ability to support, monitor, and troubleshoot production ETL workflows, resolving data load failures and performance issues.
What's in it for you?
- Competitive compensation package
- Full Benefits; Medical, Vision, Dental, and more!
- Opportunity to get in with an industry leading organization.
Why IDR?
- 25+ Years of Proven Industry Experience in 4 major markets
- Employee Stock Ownership Program
- Dedicated Engagement Manager who is committed to you and your success.
- Medical, Dental, Vision, and Life Insurance
- ClearlyRated's Best of Staffing® Client and Talent Award winner 12 years in a row.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite employees to voluntarily self-identify their race or ethnicity, gender, and veteran status (if applicable). Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. You may access this form here.