> Markdown version of [/jobs/ext/2626113-lead-ibm-datastage-etl-consultant-production-support](https://www.wearedevelopers.com/jobs/ext/2626113-lead-ibm-datastage-etl-consultant-production-support). 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). --- # Lead IBM DataStage ETL Consultant Production Support - **Company:** Innovative Information Technologies, Inc - **Location:** Culver City, CA, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Agile Methodology, JIRA, Continuous Integration, Cron, Data Validation, Data Integration, Extract Transform Load (ETL), Relational Databases, IBM InfoSphere DataStage, DevOps, File Transfer, Monitoring of Systems, Python (Programming Language), Unix Shell, SQL Databases, Data Processing, Control M - **Published:** August 28, 2026 - **Apply:** https://www.dice.com/job-detail/0bbc0e1c-da2b-4bd2-a458-f0cffc14dada ## About the Role We are seeking a skilled Lead ETL DataStage Consultant with expertise in development, administration, production support, and maintenance. The ideal candidate will have a strong background in ETL processes, along with proficiency in Python and SQL scripting. Experience with Control-M, Managed File Transfer (MFT), and IBM Gentran is a plus. This role is crucial for ensuring the efficiency and reliability of our data integration processes., 6 years of proven experience in ETL development and administration using DataStage. Solid understanding of Unix shell scripts, Cron jobs & Relational databases Strong knowledge in Python & SQL queries to do automation and improvements in the platform. Lead & drive utilities/frameworks to automate functionality and environment checks. Familiarity with Control-M, MFT, and IBM Gentran is a plus. Very strong in Sony s ITSM process knowledge and SLA expectations Knowledge of Agile delivery models with tools like JIRA, CI/CD pipelines, and DevOps practices. Excellent analytical and problem-solving skills Clear communication and exposure to work in onshore-offshore model ## Description Understand requirements and implement ETL processes using DataStage to extract, transform, and load data from various sources. Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications. Write and optimize SQL queries for data manipulation and retrieval. Manage and configure DataStage environments, ensuring optimal performance and reliability. Monitor system performance and troubleshoot issues related to ETL processes. Implement security best practices for data handling and integration. Provide support for production processes, troubleshoot and resolve issues as they arise. Monitor job logs and performance metrics to proactively identify and address potential issues. Implement incident management processes to ensure timely resolution of production incidents. Plan and execute regular maintenance activities, including system upgrades and patches. Ensure compliance with organizational policies and industry standards during maintenance activities. Document processes, procedures, and configurations for knowledge sharing. Utilize Python for scripting tasks related to data processing and automation. Develop and maintain SQL scripts for data validation and transformation. Work closely with business & technical teams & manage application support & track KPI/SLA ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [From clicks to cribs - How to find your dream home with web scraping](https://www.wearedevelopers.com/videos/767-from-clicks-to-cribs-how-to-find-your-dream-home-with-web-scraping) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [Integrate your Cognitive Assistant with 3rd-party DBs and software](https://www.wearedevelopers.com/videos/249-integrate-your-cognitive-assistant-with-3rd-party-dbs-and-software) - [DevOps Maturity Check – a way to balance autonomy and alignment](https://www.wearedevelopers.com/videos/58-devops-maturity-check-a-way-to-balance-autonomy-and-alignment) ## Related Articles - [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) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Now is the time for industrialized software development](https://www.wearedevelopers.com/magazine/601-now-is-the-time-for-industrialized-software-development) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [A Guide to Green Tech and Green IT Careers](https://www.wearedevelopers.com/magazine/374-a-guide-to-green-tech-and-green-it-careers) - [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)