> Markdown version of [/jobs/ext/3071849-datastage-engineer-developer](https://www.wearedevelopers.com/jobs/ext/3071849-datastage-engineer-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # DataStage Engineer/Developer - **Company:** Innovative Information Technologies, Inc - **Location:** Chicago, IL, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** CA Workload Automation Ae, Bash Shell, Unix, Command-Line Interface, Data Integration, Extract Transform Load (ETL), Data Warehousing, IBM InfoSphere DataStage, Dimensional Modeling, File Transfer, Monitoring of Systems, Job Scheduling, Korn Shell, Oracle Databases, Oracle (Applications), Performance Tuning, Shell Script, Software Configuration Management, Software Deployment, SQL Stored Procedures, Data Processing, Scripting, Star Schema, Control M - **Published:** September 25, 2026 - **Apply:** https://www.dice.com/job-detail/6c12a635-7db9-4a64-aabf-f439437dea37 ## About the Role Seeking a Lead DataStage Engineer with approximately 10 years of hands-on development experience to design, build, and optimize enterprise-scale ETL pipelines, batch automation workflows, and database integrations., IBM DataStage: 8+ years of hands-on experience building complex parallel jobs, sequences, shared containers, and custom stages. Unix/Linux Platform: 8+ years of expertise in command-line utilities, bash/Korn shell scripting, process monitoring, and batch process control. Oracle & PL/SQL: 8+ years of proficiency with Oracle databases, execution plans, index tuning, partitioning, and writing performant PL/SQL logic. Data Warehousing: Deep understanding of ETL architecture, dimensional modeling (Star/Snowflake schemas), and Slowly Changing Dimensions (SCD Type 1/2/3). ## Description * Design, develop, test, and deploy robust ETL jobs using IBM InfoSphere DataStage parallel framework. * Author advanced Unix/Linux shell scripts to automate batch execution workflows, file transfers, directory management, and error handling. * Write, optimize, and maintain complex Oracle PL/SQL code, including stored procedures, packages, functions, triggers, and analytical queries. * Conduct performance tuning across DataStage jobs, Unix scripts, and Oracle database queries to support high-volume data processing. * Collaborate with data architects and business analysts to translate business requirements into technical specs and dimensional data models. * Manage batch job scheduling (e.g., Control-M, Autosys), production deployments, system monitoring, and Tier-3 escalation support. * Maintain data quality standards, code repository management, and comprehensive technical documentation. ## Related Videos - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Brewing Tea over the Internet](https://www.wearedevelopers.com/videos/697-brewing-tea-over-the-internet) - [A Technical Introduction to Bitcoin's 2nd Layer- The Lightning Network](https://www.wearedevelopers.com/videos/15-a-technical-introduction-to-bitcoin-s-2nd-layer-the-lightning-network) - [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries)