ETL QA Analyst

Full Time
  • Full Time
  • Toronto

Finance Professionals Inc.


Location: Hybrid (Downtown, Toronto)

Duration: 6 months

Our client, a leading financial institution in Downtown Toronto is looking for a Sr. ETL QA Analyst to test system modifications for areas such as database impacts, software scenarios, or usability. The successful candidate will have the opportunity to work with one of the Top 5 Banks in Canada.

  • Typical Day in role:Develop, execute test plans, scenarios, scripts or procedures
  • 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
  • Must-Have Skills:10+ years of experience working as a Test Analyst
  • 5+ years of experience working as an 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 Skills:Salesforce Knowledge
  • Regular Expressions
  • Soft Skills Required: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


To apply, please visit the following URL: