Job Title or Location

Lead Data Automation Engineer (ETL)

Scotiabank - 795 Jobs
Toronto, ON
Posted 6 days ago

Requisition ID: 196851
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

As an Automation Specialist, you will be a part of our Global Wealth data team. You will collaborate closely with various scrum teams to promote a focus on quality. You will also contribute to our highly regarded in-house automation frameworks for Data Platform, APIs, and Performance testing.

Is this role right for you? In this role you will:

  • Design, improve, and maintain automation frameworks and tools.
  • Create and estimate automation scripts using Java, Python, and Unix platforms.
  • Utilize SQL queries for effective data comparison in test scenarios.
  • Participate in Unix/Linux environments and GIT/Bitbucket workflows.
  • Write moderate to complex code/scripts to test systems.
  • Be responsible for the design, development, and maintenance of a modular, extensible, and reusable test automation framework to enable continuous testing in a DevOps environment.
  • Develop code to automate the testing (Unit/ Integration) of Datahub/Lake, microservices (Rest APIs) and ensure adequate test coverage of the application code.
  • Collaborate with development engineers during story and task breakdown to develop a test approach that effectively covers the functional and performance characteristics of a feature.
  • Build, maintain, and enhance the existing automation framework, test harness, and processes.
  • Become a Subject Matter Expert (SME) on the usage of the entire application suite, processes, workflows, etc.
  • Work with the Engineering team Management to improve the testing process.
  • Understand enterprise software design principles – architecture, design patterns, Object-Oriented Programming (OOP).
  • Comfortably work in a self-guided manner with the ability to prioritize tasks and manage your own time efficiently, without direct input or oversight.

Do you have the skills that will enable you to succeed in this role? We'd love to work with you if you have:

  • A proven track record in software quality assurance, demonstrating over 7 years of experience as a test automation developer.
  • At least 2 years of hands-on Test Automation experience applying Java/Python/Robot Framework.
  • Proficiency in SQL queries, especially for data comparison in test scenarios.
  • Practical experience in automating web-based APIs and database-centric applications.
  • Familiarity with Unix/Linux environments.
  • Solid understanding of GIT/Bitbucket (source code management tool) and CI/CD Pipeline.
  • Comfortable working in a diverse environment with a variety of banking & financial applications, innovative automation technologies, and testing tools.
  • Knowledge/experience in Java ORM Frameworks such as Hibernate, Spring DAO.
  • Exposure to RDBMS such as Oracle or Sybase. Knowledge and experience with SQL queries.
  • It would be a plus if you have experience in building, integrating, and deploying web services (REST/ SOAP/JSON/XML).
  • Work with engineers to develop test automation strategies and frameworks for Data Platforms involving APIs, and ETL tools.
  • Build and run automated functional, integration, stress, and performance tests.
  • Design, build, and automate data flows while evaluating and improving existing data systems.
  • Run large-scale simulations based on custom or real-world data to find or reproduce issues, bottlenecks, and regressions.
  • Analyze and report the results of testing efforts in a clear and timely manner.
  • Build, maintain, and continually update software quality best practices within assigned teams.

What's in it for you?

  • Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential, respected for who they are, and are embraced through bias-free practices and inclusive values across Scotiabank. We embrace diversity and provide opportunities for all employee to learn, grow & participate through our various Employee Resource Groups (ERGs) that span across diverse gender identities, ethnicity, race, age, ability & veterans.
  • Accessibility and Workplace Accommodations - 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. Scotiabank continues to locate, remove and prevent barriers so that we can build a diverse and inclusive environment while meeting accessibility requirements.
  • Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
  • Competitive Rewards program including bonus, flexible vacation, personal, sick days and benefits will start on day one.
  • Dynamic Ecosystem - Free tea & coffee, universal washrooms, and lots of space for team collaboration.
  • Community Engagement - No matter where you choose to work from; we offer opportunities for community engagement & belonging with our various programs such as hackathons, contests, cooking with friends, Humans of Digital and much more!

Working location condition: Hybrid


Location(s): Canada : Ontario : Toronto
Scotiabank 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. If you require technical assistance, please click here. 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.

Competition Number: 196851
Save Job