What are the responsibilities and job description for the DataStage Developer position at IDR, Inc.?
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.