Quality Assurance Testing Specialist - Contract Full Time

Title: Quality Assurance Testing Specialist - Contract Full Time

Requisition ID: 200665

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

The Team

The Data Quality Assurance Team under Canadian Banking Technology (CBT) Data Services Organization is responsible for quality assurance & testing automation for all projects related to data engineering, ingestion, transformation, and delivery between Canadian Banking source applications and Enterprise data lake (EDL), Enterprise Data Warehouse, and Global Data & Analytics Platform.

The role:

This position will help to ensure the performance of functional and non-functional testing of ETL/ELT jobs for data and analytics platforms, including but not limited to Hadoop, Azure, SQL Server, DB2, Oracle, and NoSQL. Responsibilities include developing test plans, driving test development and execution, testing code fixes, and establishing a testing framework that promotes a repeatable, quality-driven test process for all phases of the software development lifecycle. The QA Specialist is expected to function independently while ensuring that management is kept informed and that problems and issues are escalated appropriately.

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

1. Your passion for Software/Data Quality and ETL testing.
2. Exposure to Big Data, Enterprise Data Lake, Hadoop is an asset.
3. Expert knowledge of SQL queries, ETL, Back-End testing.
4. Work with Technology Partners, Source Teams, Developers, Business Analysts to understand mapping and resolve complex data logic.
5. Work with QAT Leads across value streams within QAT to understand test data requirements and facilitate test data preparation.
6. Document test artifacts such as test plans, test cases, test results, and defect reports.
7. Be proactive and part of a dynamic team in an Agile environment.
8. Work with your scrum team to design and develop test strategies, testability requirements, and implementation strategies.
9. Contribute to test automation tools and infrastructure by creating and augmenting test cases and test libraries.
10. Work comfortably in a self-guided manner with the ability to prioritize tasks and manage your own time efficiently.
11. Encourage both individual and collaborative innovation.
12. Be a fast learner with an appetite for understanding both simple and complex solutions.
13. Have a positive and resilient personality, embracing feedback and desiring continuous improvement.
14. Possess strong analytical and problem resolution skills.

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

1. QA Specialist with strong ETL testing background, minimum of 9 years of experience.
2. Excellent knowledge of SQL.
3. Experience with Automation skills such as Robot framework, Python, etc.
4. Excellent knowledge of data warehouse concepts and databases such as Oracle, DB2, SQL Server, NoSQL (MongoDB, Cassandra).
5. Experience with one or more ETL applications like Talend, SSIS, Data Stage, Informatics, Oracle Data Integrator.
6. Testing experience in Hadoop and public cloud environment, including Azure.
7. Working knowledge of JIRA, Data Comparison tools.
8. Experience in software testing techniques, methodologies, and tools.
9. Establish traceability between test cases, user stories, and bugs.
10. Expert understanding of UAT standards and methodology.
11. Testing Automation strategy definition and execution.
12. Effective communication skills to address issues with QA testing and other department staff.
13. Outstanding written and verbal communication abilities.

What's in it for you?

1. Diversity, Equity, Inclusion & Allyship - We strive to create an inclusive culture where every employee is empowered to reach their fullest potential.
2. Accessibility and Workplace Accommodations - We value the unique skills and experiences each individual brings to the Bank.
3. Upskilling through online courses, cross-functional development opportunities, and tuition assistance.
4. Competitive Rewards program including bonus, flexible vacation, personal, sick days, and benefits starting on day one.
5. Community Engagement opportunities with various programs.
6. Work arrangements: 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 achieve success through a broad range of advice, products, and services.

If you require accommodation during the recruitment and selection process, please let our Recruitment team know. Candidates must apply directly online to be considered for this role.