QA Developer
Dentalcorp is Canada’s largest and fastest growing network of dental practices, committed to advancing the overall well-being of Canadians. The QA Developer role focuses on ensuring the accuracy and reliability of data that supports clinical, operational, and strategic decision-making through robust data validation and ETL processes.
Responsibilities
- Work closely with cross-functional teams, including ETL developers, data engineers, data analysts, and business users to better understand data migration processes, data requirements, and business rules
- Assist in developing and documenting test plans and test cases based on functional and technical specifications, ensuring comprehensive coverage of data migration workflows
- Participate in executing and automating test cases to validate the accuracy, completeness, and consistency of data throughout the data migration pipeline
- Assess data quality at various stages of the data migration process, identifying anomalies, discrepancies, and outliers
- Identify opportunities for process improvement and automation to enhance the efficiency and effectiveness of the ETL QA process
Skills
- Post-secondary degree in Computer Science, Information Technology, or a related field would be an asset
- Knowledge of ETL/ELT concepts and processes
- Understanding of SQL and experience in querying relational databases
- Familiarity with data quality tools and techniques
- Basic understanding of data warehousing concepts
- Strong analytical and problem-solving skills
- Excellent communication and collaboration skills
- Experience in writing complex SQL queries
- Experience in testing BI reports (Tableau)
- Experience with Agile methodologies (Scrum and Kanban) and frequent release cycles
- Experience with Atlassian Tools (JIRA & Confluence)
- Experience with Snowflake and MS-SQL Databases
- Experience with CI/CD (GitLab)
- Experience with programming/scripting languages (Python, NodeJS, Batch) or similar is a great asset
Benefits
- This role is 4 days on-site Monday to Thursday with Friday's work from home.
Company Overview