Sr. Data Test Analyst

Galent; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading company in recruitment is seeking a Talent Acquisition Lead in Toronto. The role involves overseeing software quality assurance for enterprise-level applications, requiring expertise in SQL, data warehouse testing, and cloud technologies. Ideal candidates will have strong analytical skills and experience with QA automation tools.

Qualifications

• 5+ years of experience in Software Quality Assurance.
• Strong SQL skills for complex queries and data validation.
• Experience with data warehouse and ETL tools.

Responsibilities

• Writing complex SQL queries and evaluating test requirements.
• Testing multiple phases in medium to large projects.
• Creating comprehensive test plans and requirements traceability matrices.

Skills

Customer MDM

SnowFlake

Hadoop

SQL

Data analysis

ETL testing

QA Automation

Problem-solving

Tools

Informatica PowerCenter

AWS (S3)

PostgreSQL

SQL Database

MongoDB

Job description

Direct message the job poster from Galent

Talent Acquisition Lead @Galent (Formerly Diamondpick Inc) | Expert in Recruitment- US | Canada

Location: Toronto, Canada

Work Model: Hybrid

Top Capability skills required

• Customer MDM
• SnowFlake
• Hadoop

Key Responsibilities:

• 5+ Years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.
• Writing complex SQL queries and determining the types of testing required (e.g., data validation, regression).
• Evaluating the testability of requirements and creating comprehensive test plans that support business and technological solutions.
• Testing multiple phases in medium to large projects.
• Understanding information governance principles and their application in testing.
• Experience with data warehouse and data mart testing.
• Identification and preparation of test data techniques.
• Transforming complex business logic into SQL or PL/SQL queries.
• Knowledge of Software Test Life Cycle, Test Case Life Cycle, Defect Life Cycle.
• Creating requirements traceability matrices (RTM).
• Proficiency in Test Case Preparation and Execution.
• Experience with QA Automation tools using Python.
• Exposure to ETL testing with high SQL skills, handling large data sets, and understanding Data Quality Framework.
• Data analysis skills including profiling, auditing, balancing, and reconciliation.
• Defect tracking experience (e.g., Jira, ALM).
• SQL query tuning, stored procedures, views for performance improvements.
• Knowledge of data models and entity relationship diagrams.
• Ability to multi-task, adapt quickly, and maintain urgency in completing tasks.

Requirements:

• Experience with Cloud Snowflake, AWS (S3), PostgreSQL, SQL Database, Hadoop Data Lake, and MongoDB.
• Experience with ETL tools like Informatica PowerCenter & BDM.
• Developing data extraction, transformation, and load programs for structured and semi-structured data.
• Data integration, cleansing, and analytics experience.
• Data modeling and design principles for data marts and warehouses.
• Strong problem-solving and analytical skills; self-starter with ownership mentality.
• Ability to work independently and as part of a team.
• Commitment to high-quality output and service.