QA Test Analyst - ETL
Contractor
contractor
26 Mar 2024
Toronto
Verified by Turrior
Content + Source + Freshness • 12 Dec 2025 • 95% confidence
75 / 100
Offer value
Similar to the previous role, this position offers opportunities in ETL testing but with more emphasis on problem-solving skills.
- Excellent entry point into ETL and data testing
- Focus on data problem-solving and analysis
- Stable work environment with set project timelines
- Demands significant experience (10+ years)
Pros
- Focused on ETL testing which is a key aspect of data quality management
- Documents process improvements and helps define best practices
- Cooperative environment with other analysts and developers
Cons
- Slightly lower compensation compared to other QA positions
- May not appeal to individuals looking for innovative tech roles
- Risk of repetitive tasks in data processing
Who it's for
Mid-Level • On-site
Good fit
- Mid-level QA Analysts with ETL experience
- Data-focused professionals seeking stable roles
- Candidates desiring a collaborative work environment
Not recommended for
- Entry-level QA candidates without testing experience
- Those uninterested in data analysis
- Professionals seeking dynamic, innovative tech roles
Motivation fit
Desire to enhance quality assurance processesInterest in data validation challenges within software testingMotivation to work closely with development teams
Key skills
Proficiency in SQL and ETL toolsAbility to manage defect tracking systemsData validation and analysis skillsStrong communication abilities
Score: 75/100 AI verified analysis
About the job
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
• 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
