IS Technical Specialist

Description

Job Title: IS Technical Specialist

Organization Name: The Huntington National Bank

Department Description

The Huntington National Bank

7 Easton Oval

Columbus, OH 43219

Detailed Description

As a Senior ETL Developer, develop ETL processes that source data from different systems and load them into Snowflake database and use DataStage to process and format data to meet CCAR reporting requirements, including FR 2052a and FR Y-14M. Design and develop quality controls and perform data profiling to make sure source data issues are resolved and data in enterprise data warehouse is accurate and clean. Use WinSCP to FTP (File Transfer Protocol) files from one server to another. Analyze, design, and develop systems based upon user specifications. Create Unix shell scripts for file manipulation and to improve application functionality. Create files on premises and FTP to AWS S3. Help business users to resolve Regulatory data issues (i.e., Axiom, OFSAA, CCAR, etc.). Lead a team of five or more developers. Participate in 24x7 on-call support for DataStage ETL processes. Hybrid work from home policy may apply.

Job Requirements

Bachelor’s degree in Computer Science, Management Information Systems, Engineering, or related field and 7 years of experience in the following: ETL development using DataStage, Quality Stage, Oracle and SQL Server. 3 years of: Snowflake development; data quality using Infogix; and developing multiple Zena jobs for batch processing schedules. 2 years of: developing ETL processes sourcing data from different systems and loading into Snowflake; experience creating and sending files from on premises to AWS S3; processing and formatting data using DataStage to meet CCAR reporting requirements; and developing ETL processes to store data into Axiom for FR Y-14M, QRM, FR 2052a, and other regulatory reporting.


Exempt Status: (Yes = not eligible for overtime pay) (No = eligible for overtime pay)

Yes

Workplace Type:

Hybrid

Huntington is an equal opportunity and affirmative action employer and is committed to providing equal employment opportunities for all regardless of race, color, religion, sex, national origin, age, disability, sexual orientation, veteran status, gender identity and expression, genetic information, or any other basis protected by local, state, or federal law.

Tobacco-Free Hiring Practice: Visit Huntington's Career Web Site for more details.

Agency Statement: Huntington does not accept solicitation from Third Party Recruiters for any position