senior etl quality assurance lead - fully on-site.

Advantages
• Opportunity to lead QA efforts for a high-profile integration project.
• Work with cutting-edge ETL technologies and BI tools like Power BI and Qlik.
• Collaborate closely with BI developers to ensure data accuracy and performance in dashboards and reports.
• Shape data integrity and consistency through master data testing and validation.
• Implement and improve QA processes with automation tools and frameworks, enhancing efficiency and accuracy.

Responsibilities
1. ETL Testing:
a. Validate ETL processes to ensure accurate data extraction, transformation, and loading.
b. Develop and execute comprehensive test plans and test cases for ETL processes.
c. Identify, document, and track defects in the ETL processes and work closely with development teams to resolve issues.

2. Dashboard Testing:
a. Conduct end-to-end testing of dashboards and reports primarily in Power BI and Qlik.
b. Verify data accuracy, consistency, and performance in dashboards and reports.
c. Collaborate with BI developers to ensure that dashboard functionalities meet user requirements.

3. Master Data Testing:
a. Test and validate master data management processes to ensure data integrity and consistency.
b. Perform data profiling and data quality assessments.
c. Ensure that master data aligns with business rules and standards.

4. Data Warehouse Testing:
a. Validate data warehouse design and architecture to ensure scalability and performance.
b. Conduct comprehensive testing on data integration and data migration processes.
c. Ensure that data warehouse solutions meet business requirements and performance benchmarks.

5. Automation and Tool Utilization:
a. Implement test automation scripts and frameworks to enhance testing efficiency.
b. Utilize testing tools and frameworks to perform manual and automated testing.
c. Stay updated with the latest QA tools and methodologies to continuously improve the QA processes.

6. Documentation and Reporting:
a. Create detailed test plans, test cases, and test scripts.
b. Document and communicate test results, issues, and defects to stakeholders.
c. Generate comprehensive test reports and dashboards for executive review.

Qualifications
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
- Minimum 10 Years of Data Management and BI development and testing,
- Minimum 3 years of SDLC or testing team management experience,
- Large complex system integration projects experiences
- Proven track record in ETL, dashboard, master data, and data warehouse testing.
- Technical Skills:
- Deep understanding of ETL technologies and processes.
- Expertise in testing dashboards and reports, particularly in Power BI and Qlik.
- Strong knowledge of master data management and data quality principles.
- Proficiency in data warehouse concepts, design, and testing.
- Tools and Technologies:
- Hands-on experience with testing tools and frameworks (e.g., ADO, JIRA, Qtest, Tosca)
- Proficiency in SQL for data validation and testing.
- Familiarity with automation tools and scripting languages.

Soft Skills:
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills.
- Ability to work independently and as part of a team.
- Attention to detail and commitment to quality.



Summary
If you're eager to leverage your expertise in software development to tackle meaningful challenges and contribute to revolutionary projects, then apply now via this job ad or reach out to your Randstad Digital representative immediately!

P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!

We look forward to supporting you in your job search!

Good luck!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.