Job DescriptionJob Description: Role: QA Tester - ETL/ Data Testing
Hybrid: 2 days in office weekly
Location: Toronto, ON
Primary Skills:
1. ETL , Data testing
2. Strong SQL expertise
3. Create and execute UI test cases, exploratory tests, and regression tests.
Responsibilities:
ETL/Data Testing
Analyze and understand source-to-target mappings, data models, and ETL workflows.
Validate data extraction, transformation, and loading across databases, data lakes, and downstream systems.
Write complex SQL queries to perform data reconciliation, profiling, and validation.
Perform schema validation, data integrity checks, and transformation logic verification.
Test batch processes, schedules, and data pipelines (Informatica, DataStage, SSIS, Azure/AWS pipelines—depending on stack).
Validate error handling, exceptions, and audit logs in ETL flows.
Front-End / UI Testing
Test responsive web applications for functionality, usability, accessibility, and performance.
Validate API integrations and front-end to back-end data consistency.
Perform cross-browser and cross-device testing.
Create and execute UI test cases, exploratory tests, and regression tests.
Work with browser dev tools to inspect network calls, console errors, and DOM events.
QA Responsibilities
Create detailed test plans, test cases, and traceability matrices.
Collaborate with developers, BAs, architects, and product owners.
Participate in daily stand-ups, sprint planning, and UAT support.
Log, track, and validate defects in Jira/Azure DevOps.
Ensure compliance with data quality, security, and regulatory standards (e.g., PII handling).
RequirementsExperience (Years): 4-6 Essential Skills: • Work with project teams throughout the organization to design, implement, and manage CDN infrastructure using Akamai, to ensure high availability, performance, and scalability for customer facing applications and business processes. • Handle multiple priorities and assignments with excellence and precision. • Be a part of a 24/7/365 organization (some after hours support is expected as part of normal on-call rotation). • Directly support line of business development teams, provide guidance to them on implementation and changes for customer facing applications • Develop and maintain security protocols and measures to protect CDN infrastructure from cyber threats. • Monitor and analyze network performance, identifying and resolving issues to optimize content delivery of critical applications. • Collaborate with cross-functional teams to integrate Akamai CDN solutions with existing systems and applications. • Collaborate with information security teams to implement DDoS protection strategies and other security measures in the CDN. • Provide technical support and guidance to clients and internal teams regarding CDN and security best practices. • Work closely with vendor and professional service teams on delivery related activities and strategy. Qualifications: • Bachelor’s degree in Computer Science, Information Technology, or a related field. OR similar work experience. • Strong understanding of network protocols (HTTP/HTTPS, DNS, TCP/IP). • Proven experience as a CDN Engineer or similar role, with a strong focus on cybersecurity. • In-depth knowledge of Content Delivery Network technologies, including caching, load balancing, and content optimization. • Excellent problem-solving skills and attention to detail. • Strong communication and teamwork abilities. • Experience supporting 24/7/365 customer facing applications at enterprise scale. • Awareness and experience with cybersecurity tools and practices, such as firewalls, intrusion detection/prevention systems, and encryption. • Proficiency in scripting and automation (e.g., Python, Bash) a plus. • Relevant certifications (e.g., CISSP, CEH) are a plus but not required.