Lead ETL Developer

Description

Huntington Bank’s Enterprise Data Warehouse team is looking for a Lead ETL (Extract, Transform, Load) Developer. This role will be required to learn and model using a variety of different ETL tools and databases. Will be required to develop, maintain and enhance code for new projects and current bank deliverables, ensure all IT SDLC processes are documented and practiced, work closely with the Enterprise Information team, and cross-impact other bank applications as code and processes change. The role may also assist other Enterprise Information Management programmers across different technology stacks.

Key Responsibilities

• Translate requirements and data mapping documents to technical design.
• Create, enhance, and maintain code following best practices and standards.
• Create and execute unit test plans.
• Support regression and system testing efforts.
• Debug and problem solve issues found during testing and/or production.
• Communicate status, issues, and blockers with the project team.
• Support continuous improvement by identifying and solving opportunities.

Basic Qualifications

• Bachelor’s degree
• A minimum of 5 years of experience in ETL development (Datastage and PySpark).
• A minimum of 5 years of experience writing SQL queries and troubleshooting.

Preferred Qualifications

• Star Schema design and coding (Dimension and Fact Table design)
• Understanding of enterprise data warehousing best practices and standards
• Good communication and interpersonal skills
• Good organization skills and the ability to work independently as well as with a team
• Experience in financial services (banking) industry
• Experience in Datastage
• Experience with AWS Cloud technologies and/or Snowflake
• Experience in Agile processes
• Experience leading development teams.

Exempt Status

No = eligible for overtime pay

Workplace Type

Office

Compensation Range

$70,000.00 - $140,000.00 Annual Salary