1 day old

ETL Developer (Data & ETL Administration)

Bank of Hawaii
Oahu, HI
  • Job Code
    159486

ETL Developer (Data & ETL Administration)-1800833
Description

TITLE:
ETL Developer I
SALARY:
$93,000.00 - $110,000.00
Summary: 
Under the direction of the Manager, this position designs/develops, prototypes, tests, and documents existing and new ETL processes while supporting and maintaining existing ETL/Data integration jobs. Also, assists in business unit’s compliance with applicable laws, regulations, regulatory requirements and Bank policies and procedures, including but not limited to those related to Fair Banking, Anti-Money Laundering laws and regulations, Bank Secrecy Act and USA PATRIOT Act.
 
Duties:
DEVELOPMENT (20%):  Designs, develops, and tests technical solutions while ensuring they meet end-user requirements. Leads design, code and configuration reviews.  Investigates, analyzes, and understands data contents of source data systems. 
PRODUCTION MAINTENANCE (25%):  Supports the production environment; logs and tracks problems; responds to questions and support requests and ensures the production environment meets established service levels. Leads and ensures appropriate analysis of problems, initiates corrective actions through resolution, takes steps to improve production support, implements preventative measures and ensures status updates are provided to those impacted.  Facilitates meetings with technical staff to address issues. 
SYSTEMS ANALYSIS (15%):  Leads systems and/or process analysis and design to meet functional and organizational requirements, individually and/or through assigned staff.  Provides input and recommends alternatives while costing, estimating, or validating solutions, individually and/or through assigned staff.  Incorporates Bank of Hawaii Information security policies and procedures into all system designs. 
TESTING (15%):  Directs and performs testing activities and recommends business testing requirements. Leads design and pre-implementation walkthroughs and ensures test results are documented and approvals are received prior to implementation.  Ensures development and validity of disaster recovery plans. 
LEADERSHIP (10%).  Educates users on systems and processes and acts as and IT consultant.  Provides cross training with other team members to maintain effective back up.  Provides technical leadership, assistance, and review of work for junior and peer staff members and vendors along with appropriate staff mentoring and coaching to foster a strong team atmosphere. 
VENDOR MANAGEMENT (10%):  Leads the development of Request for Information (RFIs), Request for Proposal (RFPs), and business cases.  Leads and/or participates in evaluation of vendor proposals and performance, taking into account corporate strategy and IT architecture standards.  Assesses vendor solution options, identifying risks, cost/benefits, and on-going support considerations.  Understands contractual agreements and holds vendors accountable to the terms of the agreement. 
 
 

Qualifications
DEGREE:  Bachelor’s degree in Computer Engineering, Computer Science or Information Systems
EXPERIENCE: 5 years of experience in increasingly responsible Information Technology positions with the following: 
 
  • at least 5 years of experience using ETL tools such as IBM Data Stage and
  • at least 3 years of experience working with banking/financial industry or related field.
SKILLS: 
Experience with System Development Life Cycle (SDLC) or with Relational Database Management Systems (RDBMS). 
Experience with Structured Query Language (SQL). 
Experience with data warehousing (Star/Snowflake schema) or data vault concepts. Experience with ETL/Data Integration using the following: IBM Data Stage, Shell scripting, Oracle PL/SQL, or Microsoft SSIS. 
Experience with ETL tool installation / upgrade and ETL job migration
Job Function Information Technology
Primary Location Hawaii-Oahu
Schedule Full-time
Job Posting Oct 17, 2018, 3:23:20 PM
Unposting Date Nov 18, 2018, 2:59:00 AM

Categories

Posted: 2018-11-14 Expires: 2018-12-13
  • Salary Questions

    Find out how your paycheck compares by industry, function, location, and more.

    Check Right Now

  • Tips for ABLE Grads

    From creating the perfect resume to nailing the interview, this article is a must-read before you start your Job Hunt.

    Get Started Now

  • Set Up Your Job Alerts

    Be alerted when a job is posted that fits your professional criteria.

    Set Up Your Alerts Right Now

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

ETL Developer (Data & ETL Administration)

Bank of Hawaii
Oahu, HI

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast