Description

Key Skills: IBM DataStage, ETL Development, DataStage Director, Operations Console, InfoSphere Information Server, Performance Optimization, Job Monitoring, Production Support, Database Management, Troubleshooting

Good to Have Skills: Experience with Huntington Bank enterprise scheduling tools like Zena, knowledge of partitioning techniques including Hash Range Entire and Auto, buffer tuning, memory configurations, parallel processing best practices, working with Infrastructure teams, IAM coordination, change management processes, cross-functional collaboration with upstream and downstream teams, Finance and Regulatory Reporting domain knowledge.

Roles & Responsibilities:

• Monitor DataStage Director and Operations Console to ensure smooth execution of daily monthly and quarterly ETL workloads
• Manage job schedules using Huntington Bank enterprise scheduling tools Zena and ensure adherence to SLAs for all Finance and Regulatory Reporting job cycles
• Provide L2 and L3 support for ETL job failures including error analysis and timely restarts with root cause analysis
• Debug and support issues caused by upstream system defects or downstream application failures even outside pure ETL scope
• Collaborate with Infrastructure teams to maintain IBM InfoSphere Information Server IIS platform health and manage environment level configurations
• Promote DataStage code DSX and ISX across environments following Huntington change management process and validate ETL components during deployment
• Assist in patching fix packs and version upgrades of the IIS DataStage platform and support approval workflows for DataStage project access
• Perform periodic job health checks to identify high latency or long running ETL workloads and optimize DataStage jobs through efficient partitioning techniques
• Work with DBAs to maintain performance of source and target databases by ensuring indexes are updated and statistics are refreshed
• Document incident recovery steps and preventive actions while supporting ETL execution across Dev QA Stage and Production environments

Experience Required: Skilled ETL Senior Developer specializing in IBM DataStage with experience in maintaining production support, job monitoring, troubleshooting, and performance optimization for Finance and Regulatory Reporting functions

Key Skills

Education

Any Graduate