Scotiabank ETL Developer With Java and Hadoop in Toronto, Ontario

ETL Developer With Java and Hadoop

Apply now »

Date: Jan 13, 2019

Location: Toronto, ON, CA

Company: Scotiabank

Requisition ID: 48830

Join the Global Community of Scotiabankers to help customers become better off.

Job Purpose

The ETL team within the Scotiabank Wealth Management technology area is key to meeting the operational data needs of the various stake holders within Wealth. The ETL team is instrumental in sourcing the data from the key wealth systems and transforming the data to meet the business objectives. The ETL team also fulfills the requirements for AML regulatory needs. To meet the above objectives we are seeking a highly skilled ETL developer who will provide technical leadership in the areas of design, data modeling and ETL development best practices to help the team achieve the desired goals.

Key Accountabilities

  • Develop ETL code and build packages based on existing standards and suggest improvements when possible

  • Leading development efforts in ingesting and transforming data from various sources. Building scripts, writing specifications and responsible for end to end delivery of data

  • Develop and test code from design specifications, as well as implement and support enhancements to applications

  • Provide technical expertise in medium to complex projects as a Technical Lead capable of providing guidance and advise to the team

  • Has some hands on experience working in an agile environment and knowledge of waterfall as a methodology and is able to adhere to team and organization standards.

  • Works in close collaboration with Architects and other cross functional team members in creating design documents, outlining overview, diagrams, technical requirements and solution that best addresses a business needs.

  • Participate in technical discussions, client meetings and presentation of solutions to the technical team members as well as Business

  • Participate in code review of peers and junior team members and recommend suggestions for improvement where appropriate to ensure high quality product

  • Provide leadership in production support issues and carry after-hours support phone on a rotational basis

  • Prior experience in the Wealth business arena is desired but not mandatory

Functional Competencies

  • Should be a team player and should adapt to change and work accordingly in a positive manner.

  • Should have excellent verbal and written communication, effectively convey ideas verbally, have clear written communication especially when responding to non-technical / business team members.

Must / Plus have Technical Skills

  • 3+ years’ experience in Java development or in other Object Oriented languages

  • 3 to 5+ years’ experience with relational databases with a good knowledge of SQL Scripting, database structures, principles and design theories is a must have

  • Excellent hands on working experience and knowledge of ETL tools such as DataStage, iWay or equivalent

  • Excellent in reading and writing complex SQL queries

  • Experience working in Agile/Lean delivery teams

  • Good to have familiarity with data visualization tools such as Tableau.

  • Any Big Data and Hadoop experience is good to have.

Education/ Experience

  • Degree in Computer Science or related field or equivalent experience.

Location(s): Canada : Ontario : Toronto

As Canada’s International Bank, we are a leader when it comes to inclusion. We are a diverse and global team, speaking more than 100 languages with backgrounds from more than 120 countries. We value the unique skills and experiences each individual brings to the bank, and are committed to creating and maintaining an inclusive and accessible environment for everyone. Candidates selected for an interview will be contacted directly. If you require accommodation during the recruitment and selection process, please let us know. We will work with you to provide as seamless a recruitment experience as possible.