QA Test Analyst - ETL x2
Contractor
contractor
17 Jan 2024
Toronto
Verified by Turrior
Content + Source + Freshness • 12 Dec 2025 • 95% confidence
75 / 100
Offer value
This position is valuable for individuals looking to work on ETL processes, although less competitive than other roles in terms of skill requirements.
- Focus on ETL testing with quite a specific skill set
- Opportunity to develop strong data analysis skills
- Stable job environment with a clear project structure
- Requires significant experience (10+ years)
Pros
- Immediate need for experienced professionals in ETL testing
- Exposure to data validation and defect tracking
- Collaborative atmosphere with dedicated QA and development teams
Cons
- Limited growth potential outside of ETL-specific testing
- May not appeal to those seeking cutting-edge technology roles
- Contractual nature may affect job security
Who it's for
Mid-Level • On-site
Good fit
- QA Test Analysts with strong ETL and SQL experience
- Professionals wishing to specialize in data processes
- Candidates comfortable in moderately structured teams
Not recommended for
- Newcomers to QA who lack relevant experience
- Individuals uninterested in data-related work
- Candidates who desire high-level innovative tech projects
Motivation fit
Interest in data management and quality assuranceMotivated to improve processes in ETL environmentsDesire to work in a structured project setting
Key skills
ETL testing and validationComplex SQL query writingDefect documentation and trackingData analysis and problem-solving
Score: 75/100 AI verified analysis
About the job
QA Test Analyst - ETL x2
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:
1. 10+ years of experience working as a Test Analyst
2. 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.)
3. Proficiency with writing complex SQL queries and Excel
4. ETL knowledge (e.g. create TEMP table to load CSV to parse the loaded in the DB data)
5. 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.
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:
1. 10+ years of experience working as a Test Analyst
2. 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.)
3. Proficiency with writing complex SQL queries and Excel
4. ETL knowledge (e.g. create TEMP table to load CSV to parse the loaded in the DB data)
5. 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.
