QA – ETL/SQL
Location Address: WFH – Office: Toronto
Contract Duration: 8 Months (until Oct 31)
Number of Positions: 1
Scheduled Hours: 9am-5pm (7.5 hours/day)
Extension: Possibility up to 2 years (tenure rule)
FTE: Possibility of conversion after 2 years
Project Summary: The group is searching for a strong SQL and ETL QA
• Business group: The Global Wealth Management Service (GWMS), Quality Assurance department looks after all QA testing for the banks multiple applications.
Candidate Value Proposition
• The successful candidate will have the opportunity to work with a true agile team that embraces growth and change within the bank. Testing multiple applications, this candidate will have an opportunity to diversify their environment while mastering their craft. Exposure to EDL lab.
Typical Day in Role:
• Develop Test Strategies for EDL (Enterprise Data Lake) lab delivery.
• Develop Test scenarios and queries for frontend, DB level and E2E testing scripts
• Execute test plans, scenarios, scripts or procedures
• Ability to produce dashboards and reports for sprints or code releases. Reporting frameworks like Allure, Extent reports
• Document software defects, and report to software developers.
• Monitor bug resolution efforts and track successes
• Plan test schedules or strategies in accordance with project scope or delivery dates
• Working with the test lead and scrum master
Job Responsibilities:
• Execute test plans, scenarios, scripts or procedures
• Develop testing programs that addresses areas such as database impacts, software scenarios, or usability Document software defects, using a bug tracking system, and report defects to software developers
• Identify, analyze and document problems with program function, output, online screen or content
• Monitor bug resolution efforts and track successes
• Create or maintain databases of known test defects
• Plan test schedules or strategies in accordance with project scope or delivery dates –
• Good understanding of testing standards and methodologies
Must Have Skills
1) 3+ years of hands on experience with ETL from quality assurance and testing perspective.
2) 3+ years of hands of experience in database/backend testing. (writing and verifying results of medium to high complexity SQL & PL/SQL queries) & creation of functions and stored procedures)
3) Experience working on end-to-end Software Testing Life Cycle projects
4) 3 years of experience working with Agile methodology
5) Good Knowledge of JIRA, confluence
6) Knowledge in extraction, cleansing and modification of data from/to various data sources such as flat files and databases.
7) 3+ Prior Canadian FI experience
Nice-To-Have Skills:
• Prior banking experience – asset
• 1+ year of experience with Unix/Linux system commands
Degrees or certifications
• Bachelor's degree or diploma in a technical field such as computer science, computer engineering or related field Candidate Review & Selection:
Structure and Format:
One round with HM and Test Lead (Teams meeting, 30 minutes)