QA / QC Test Analyst / Engineer – SQL

ProViso Consulting

  • Toronto, ON
  • Contract
  • Full-time
  • 30 days ago
Story Behind the Need
  • Business group: GWMS – Quality Assurance
  • Project: Candidate will be working on the Data Migration to Cloud
  • Reason for request: New resources required for meeting new project targets
Candidate Value Proposition
  • The successful candidate will have the opportunity to work on the SF DI Migration to Cloud Project, which is an important project to the bank.
Typical Day in Role
  • Develop, Execute test plans, scenarios, scripts or procedures
  • Test system modifications for 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 and database validations
  • Monitor bug resolution efforts and track successes
  • Plan test schedules or strategies in accordance with project scope or delivery dates
  • Develop, maintain and communicate (stakeholder presentation) delivery status, KPI and metric scorecards, quality checks and knowledge management solutions.
  • Perform test execution and present roadmap as needed.
  • Communicating with an average of three other QAs, Scrum master, developers, etc. from the same lab
Candidate Requirements/Must Have Skills:
  • 10+ years of experience working as a Test Analyst
  • 5+ years of experience working as a ETL QA Analyst (experience with Flat file (CSV) parsing, such as getting unique values, finding duplicates, data format validation etc.)
  • Proficiency with writing complex SQL queries and Excel
  • ETL knowledge (e.g. create TEMP table to load CSV to parse the loaded in the DB data)
  • Experience with Jira
Nice to Have:
  • Salesforce Knowledge
  • Regular Expressions
Soft Skills:
  • Strong communication skills – must be able to explain things clearly to project team members
  • Strong diagnostic, analysis, troubleshooting, problem-solving skills
  • Ability to analyze/interpret test results and provide recommendations to improve testing
Education
  • Post-Secondary Degree/Diploma in IT or Engineering
Best vs Average:
  • This is a fast-paced environment and candidates who will be able to join without too much additional training would be the best fit. Seeking candidates who are capable of working independently without too much handholding.
Candidate Review & Selection:
  • 1-2 rounds:
o 1st – Panel Interview (HM+ QA Lead + QA Manager + ETL Expert) – 45 mins – MS Teams Video (ETL/SQL technical questions, testing understanding of Data Processes)
o 2nd – Development Manager + Hiring Manager – 30 mins – MS Teams VideoJob Details11872Contract6 monthsToronto

ProViso Consulting