About the Role
We are seeking an experienced Lead DataStage Integration Support Engineer to spearhead our critical ETL architecture, operations, and support infrastructure. In this role, you will be instrumental in designing, optimizing, and maintaining scalable enterprise data integration pipelines that drive business-critical analytics and reporting across the organization.
Working within a fast-paced and collaborative technical environment, you will bridge the gap between business requirements and scalable integration solutions. You will collaborate closely with onshore and offshore engineering teams, drive automated platform monitoring, and enforce industry-leading governance, ensuring maximum uptime and data integrity.
Key Responsibilities:
- Architect, develop, and maintain robust ETL workflows and integration jobs utilizing IBM DataStage.
- Lead production support, monitoring, troubleshooting, and incident resolution for enterprise-wide batch and real-time data pipelines.
- Write, tune, and optimize complex SQL queries and relational database scripts to ensure peak data manipulation performance.
- Develop automation utilities and environment health checks leveraging Python and Unix shell scripting.
- Administer DataStage environments, managing upgrades, patch management, security best practices, and performance tuning.
- Track, manage, and report on operational KPIs and SLA adherence using enterprise ITSM ticketing frameworks.
- Collaborate with cross-functional stakeholders and business analysts to translate complex business needs into precise technical specifications.
- Oversee scheduled workflows and file transfers using enterprise tools such as Control-M and MFT.
Required Qualifications & Skills:
- 7+ years of progressive hands-on experience in ETL development, administration, and support using IBM DataStage.
- Demonstrated proficiency in writing advanced SQL queries, stored procedures, and performing database performance tuning.
- Strong background in Unix/Linux shell scripting, Cron jobs, and automated scheduling systems.
- Solid hands-on automation scripting capabilities using Python for data processing enhancements.
- Proven track record managing enterprise production support, incident resolution, and adherence to strict SLAs.
- Experience driving technical deliverables within Agile environments leveraging JIRA and modern CI/CD practices.
- Excellent verbal and written communication skills with proven ability to lead onshore/offshore team models.
Preferred Qualifications:
- Hands-on experience or architectural familiarity with Snowflake cloud data platform.
- Operational experience with Managed File Transfer (MFT) protocols and IBM Gentran integration.
- Familiarity with enterprise job orchestration tools, specifically Control-M.
- Prior experience supporting media, entertainment, or global enterprise corporate environments.
What We Offer / Benefits:
- Competitive hourly compensation commensurate with senior-level enterprise experience.
- Opportunity to lead critical data integration initiatives for a globally renowned brand.
- Dynamic, innovative, and collaborative engineering culture.
- Access to cutting-edge cloud migration and data modernization initiatives.