ETL Application Support Analyst - Jobs in Toronto, ON

Job Description

Requisition ID: 139988Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.The team:Scotiabank’s Global Technology Services (GTS) Technology Operations & Site Reliability Engineering (SRE) is responsible for the operations engineering required to provide highly available and resilient systems. In GTS Enterprise Data Warehouse (EDW) & Reference Data Management (RDM) TechOps & SRE, we are responsible for providing critical data platform services, following SRE and data governance best practices, as well as consulting and coordinating with the Bank’s technology teams to meet business expectations.The role:The successful candidate will have the opportunity to work with a very supportive and helpful team while taking on a very crucial production support role that heavily impacts Scotiabank’s operation.When required, you can provide after-hours support.Is this role right for you

• You are a skilled software engineer who possesses a broad set of skills and is familiar with SRE software engineering culture and practice.

• You enjoy looking for opportunities to be proactive, automate, and solve problems before they happen.
• You want to be challenged with problem solving in time sensitive situations to reduce system downtime and customer impact, taking those learnings forward as continuous improvements.
• You will provide production batch processing support using ETL Informatica.
• You get to troubleshoot failed jobs and output data & remediate issues.
• You will work with the development team and level 3 supports to resolve day to day issue(s).
• You manage production incident tickets effectively & efficiently.
• You conduct root cause analysis of application incident and implement recommendations to improve the situation focusing on permanent solutions.

Do you have the skills that will enable you to succeed in this role

• You can demonstrate very good communication (verbal/written) skills.
• You have hands-on technical working experience in responding to production incidents that cross application and technology boundaries.

• You can demonstrate the ability to conduct root cause analysis of application incident and implement recommendations to improve the situation, while focusing on permanent solutions.
• You have at least 4+ years of hands-on technical working experience with production batch processing support via the use of Informatica.
• You have at least 2+ years of hands-on technical working experience in the use of the IBM Tivoli Workload Scheduler tool.
• You have at least 2+ years of hands-on technical working experience with relational databases (preferably DB2).
• You have at least 2+ years of hands-on technical working experience with SQL queries on any RDBMS.
• You have at least 1+ year of hands-on technical working experience with UNIX scripting.
• Although you possess excellent problem-solving skills, it’s in your “DNA” to proactively identify and resolve issues before they become a problem.
• You can adapt to work under pressure in a dynamic environment.

• You have hands on experience authoring Standard Operating Procedures and Run Books.

• Working experience with SAS, Python, Cobol, HiveQL, and Cognos is an asset.

• You have completed a post-secondary education in computer science, engineering or in a related technology field.

Whats in it for you

• Youll get to work with and learn from diverse industry leaders, who have hailed from top technology companies around the world.
• We have an inclusive and collaborative working environment that encourages creativity, curiosity, and celebrates success! We foster an environment of innovation and continuous learning.
• We care about our people, allowing them to design how they work to deliver amazing results.
• We offer a competitive total rewards package, including a performance bonus, company matching programs (pension & Employee Share Ownership), generous vacation; health/medical/wellness benefits; employee banking privileges.
• While we currently work remotely from home, when required to be onsite, our primary location in Toronto is:

• Located just north of the TTC’s Line 1 King subway station. This location has access to The PATH & is located minutes from GO Transit/VIA Rail hub at Union Station; as well as the TTC’s King 504 streetcar line.
• Minutes from the Gardiner Expressway & the DVP.
• Located nearby is The Commons, a dining space for employees where breakfast & lunch are served. Also, The Bean serves hot/cold beverages & snacks.
• Directly accessible to The PATH & its many food courts, restaurants, grocery stores, LCBO, hairdressers, pharmacies, gyms, clothing stores & services.

Location(s): Canada : Ontario : TorontoScotiabank is a leading bank in the Americas. Guided by our purpose: "for every future", we help our customers, their families and their communities achieve success through a broad range of advice, products and services, including personal and commercial banking, wealth management and private banking, corporate and investment banking, and capital markets.At Scotiabank, 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. If you require accommodation (including, but not limited to, an accessible interview site, alternate format documents, ASL Interpreter, or Assistive Technology) during the recruitment and selection process, please let our Recruitment team know. Candidates must apply directly online to be considered for this role. We thank all applicants for their interest in a career at Scotiabank; however, only those candidates who are selected for an interview will be contacted.Quick Apply

• Terms & Conditions
• New Privacy
• Privacy Center
• Accessibility

For Job Seekers

• Browse Jobs
• Advanced Job Search
• Emplois Quebec

For Employers

• Post a Job

Stay Connected