ETL Developer with DataStage

Seeking a skilled ETL Developer specializing in IBM DataStage to support, monitor, and maintain ETL processes used across Finance and Regulatory Reporting functions. The role involves maintenance, production support, job monitoring, troubleshooting, performance optimization, and working closely with upstream and downstream teams to ensure timely, accurate, and compliant data processing., Monitor DataStage Director and Operations Console to ensure smooth execution of daily, monthly, and quarterly ETL workloads. Manage job schedules using Huntington Bank’s enterprise scheduling tools (Zena). 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. Perform root cause analysis for incidents such as source file corruption, network connectivity drops, database locks, or deadlocks. Document incident recovery steps and preventive actions through efficient use of partitioning techniques (Hash, Range, Entire, Auto), buffer tuning, memory configurations, and parallel processing best practices. Work with DBAs to maintain performance of source and target databases by ensuring indexes are updated, statistics are refreshed, and tablespace storage issues are resolved.

10 years of hands-on IBM DataStage development and support experience. Strong SQL skills with Snowflake and Oracle databases. Experience supporting Finance or Regulatory Reporting ETL workloads. Solid understanding of ETL performance tuning and parallelism concepts. Experience in production support, job monitoring, and incident management. Knowledge of job scheduling tools, with Control-M preferred. Preferred Qualifications Prior experience working with a banking client. Familiarity with regulatory reporting domains such as FR Y-9C and FFIEC. Exposure to cloud data platforms including Azure and AWS. Experience with Data Quality, Metadata, or Data Governance systems. Soft Skills Strong communication and stakeholder management abilities. Analytical, detail-oriented, and proactive in problem-solving. Ability to support high-pressure reporting cycles with tight deadlines. Skills in DataStage, SQL, Snowflake, Oracle, Python, awareness of ServiceNow, and awareness of ITIL.