Join Our Winning Team: Lead Data Automation Engineer (ETL)

Requisition ID: 196851

Are you driven by purpose and results? Do you thrive in an inclusive and high-performing culture? We invite you to join our dynamic team at Scotiabank as a Lead Data Automation Engineer (ETL).

Role Overview

As an Automation Specialist with our Global Wealth Data Team, you'll collaborate closely with various scrum teams to emphasize quality and contribute to our esteemed in-house automation frameworks for Data Platform, APIs, and Performance Testing.

Key Responsibilities

• 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.
• Work within Unix/Linux environments and GIT/Bitbucket workflows.
• Write moderate to complex code/scripts to test systems.
• Develop a modular, extensible, and reusable test automation framework to enable continuous testing in a DevOps environment.
• Automate the testing (Unit/Integration) of Datahub/Lake, microservices (Rest APIs) and ensure adequate test coverage.
• Collaborate with development engineers to develop a comprehensive test approach.
• Enhance existing automation frameworks, test harnesses, and processes.
• Become a Subject Matter Expert (SME) on the entire application suite, processes, workflows, etc.
• Work with Engineering Management to optimize the testing process.
• Understand principles of enterprise software design – architecture, design patterns, Object-Oriented Programming (OOP).
• Work autonomously, prioritizing tasks and managing your time efficiently.

Required Skills and Experience

• Over 7 years of experience in software quality assurance as a test automation developer.
• At least 2 years of hands-on Test Automation experience with Java/Python/Robot Framework.
• Proficiency in SQL queries for data comparison in test scenarios.
• Experience automating web-based APIs and database-centric applications.
• Familiarity with Unix/Linux environments.
• Understanding of GIT/Bitbucket (source code management tool) and CI/CD Pipeline.
• Comfortable working with diverse banking & financial applications, innovative automation technologies, and testing tools.
• Knowledge of Java ORM Frameworks like Hibernate and Spring DAO.
• Experience with RDBMS such as Oracle or Sybase and SQL queries.

Preferred Qualifications

• Experience in building, integrating, and deploying web services (REST/SOAP/JSON/XML) is a plus.
• Experience developing test automation strategies and frameworks for Data Platforms (APIs and ETL tools).
• Able to run and analyze large-scale simulations to find issues, bottlenecks, and regressions.
• Experience in building, maintaining, and continually updating software quality best practices.

What's In It For You?

Diversity, Equity, Inclusion & Allyship
At Scotiabank, we strive to create an inclusive culture where every employee can reach their fullest potential. We embrace diversity and offer opportunities for all employees to learn, grow, and participate through various Employee Resource Groups (ERGs).

Accessibility and Workplace Accommodations
We are committed to creating an inclusive and accessible environment for everyone. We continually work to locate, remove, and prevent barriers so that we build a diverse and inclusive workplace while meeting accessibility requirements.

Professional Development
Benefit from online courses, cross-functional development opportunities, and tuition assistance to enhance your skills.

Competitive Rewards
Enjoy a competitive rewards program which includes bonuses, flexible vacation, personal and sick days. Benefits start on day one.

Dynamic Ecosystem
Our workspace includes free tea & coffee, universal washrooms, and ample space for team collaboration.

Community Engagement
Participate in community engagement programs including hackathons, contests, cooking with friends,