ETL QA (SQL, Data Testing, UI)

Astra North Infoteck Inc.

Job Location:

Toronto - Canada

Monthly Salary: K 10 - 10

Experience Required: 5years

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

Job 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 pipelinesdepending 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).

Required Skills:

Experience (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: Bachelors 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 -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.

Job Description: Role: QA Tester - ETL/ Data TestingHybrid: 2 days in office weeklyLocation: Toronto ONPrimary Skills: 1. ETL Data testing2. Strong SQL expertise3. Create and execute UI test cases exploratory tests and regression tests.Responsibilities:ETL/Data TestingAnalyze and understand source-...