Senior Consultant | Senior Database Tester
Fermé
PQA has been going strong since 1997! As Canada's largest and most established independent software testing company, we insist on working with 'quality' people who share our passion for doing the job right! We are obsessed with quality and testing, and have built a team of people who believe quality is the most important deliverable.
We take pride in our commitment to the communities across Canada in which we are located because we know there is more to life than work. Our team members enjoy opportunities for continuous learning and they work with leading-edge companies, technologies, and tools.
The Senior Database Tester will perform Data Migration activities including mapping Redesign Database to Legacy Database; validate data quality and Data validation. They will also perform testing on ETL's and other data transforms. Prepared the functional test cases using test design techniques data validation concepts Equivalence partitioning, boundary value analysis.
We are growing in Vancouver, BC and Calgary, AB and are currently looking for experienced Senior Database Testers to help us do that! Preference will be given to those who are already based in Vancouver and/or in Calgary. Remote applicants must be following PST and/or MST time zone.
- Create a Data Quality Assurance Plan that identifies the test strategy and test cases for ensuring data quality across multiple systems. To complete the test executions, the plan will need to identify automated processes.
- Responsible for identifying data quality flaws, the sources of those flaws, potential mitigations, and the constraints associated with those mitigations.
- Identify and report metrics for monitoring data quality. Create automated data quality metrics monitors and reports.
- Perform System testing, Integration testing, Functional testing, Regression testing and Smoke Tests.
- Verify the quality of data pipeline development before deploying it to production environments.
- Write SQL scripts to extract the data and apply transformations to perform backend testing on datasets. Bulk comparison of data from source and target to identify differences and assure quality.
- Work/communicate directly with project stakeholders including Business and external Vendors and discuss defects, priority of testing activities
- Computer Science degree, Engineering degree, or equivalent work experience
- 8+ years of experience as a Software Quality Assurance Analyst including experience in Test case/Test data design, Test execution, Test reporting
- 3+ years of experience validating data via ETL, SQL and automation tools
- Experience in ETL testing, expertise on writing queries in DB2, MS SQL, MySQL, Oracle DB and Azure Databricks
- Functional testing experience mainly on MS SQL, , and API based systems
Work/communicate directly with project stakeholders including Business and external Vendors and discuss defects, priority of testing activities
Excellent analytical and problem-solving skills, with the ability to propose practical solutions to complex problems
Assertive and can help drive better quality practices
Rigorous, attention to detail to map data systems
Flexibility, self-motivation and the ability to give and receive feedback at all levels
Adaptable and willing to work through challenges with a positive attitude
Results oriented with effective time management skills
Strong communication and organizational skills
Ability to build collaborative working relationships in a team-oriented environment
At PQA Testing, we encourage our employees' personal career growth. We have plans in place to make sure that each employee is connected with a mentor to help guide them through their professional development, offer regular lunch & learns, and give our employees chances to attend industry conferences.
PQA respectfully acknowledges that our offices are located on treaty territories, unceded First Nations and Inuit territories, and part of Métis homelands. We honour their long history of welcoming many Nations to the beautiful Turtle Island and we actively work towards reconciliation between Métis, Inuit, and First Nation peoples and non-Indigenous people on this Land.
We contribute to proactive employment practices to promote inclusivity and diversity to those especially marginalized populations such as women, persons with disabilities, members of visible minorities, First Nations, Métis, and Inuit peoples, and all other groups protected under the Human Rights Code.
We are committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require accommodation during any aspect of the recruitment process and we will work with you to address your needs.
JOBID: 22T007
