Description

Key Responsibilities
•    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.

Required Skills
•    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

Key Skills

Education

Bachelor's degree