Data Test Analyst

CGI; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading company in the tech industry is seeking a Data Test Engineer for their Toronto office. In this hybrid role, you will be responsible for ensuring the quality and testing of data integration and ETL processes. The ideal candidate will possess strong technical capabilities with experience in SQL, data warehousing, and QA automation tools. You will play a critical role in maintaining data quality and governance while contributing to complex projects involving large datasets and cloud technologies.

Qualifications

• 5+ years in Software Quality Assurance and Data Warehouse Testing.
• Strong SQL and ETL skills required.
• Experience with cloud technologies and data integration preferred.

Responsibilities

• Test multiple phases of medium to large projects.
• Develop and execute test plans for data validation.
• Transform business logic into SQL or PL/SQL queries.

Skills

Problem-solving

Analytical skills

SQL

ETL development

Data warehouse architecture

Attention to detail

Tools

Informatica Power Center

Python

Jira

AWS

Snowflake

Hadoop

MongoDB

Job description

This role is hybrid and requires you to be in our downtown Toronto office 2-3 times per week - subject to change at any time.

Your future duties and responsibilities :

About the Job Role : As a Data Test Engineer, you must have strong technical capabilities and good knowledge of coding languages commonly used in ETL development, such as Python, SQL, and XML, as well as Data warehousing concepts. You should have knowledge of troubleshooting bugs and errors and finding solutions in ETL development. Familiarity with data warehouse architecture techniques like ODS, DM, EDW, and ROLAP is also needed. Extensive experience in solving complex technical problems and troubleshooting is essential.

Key Responsibilities :

• 5+ years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.
• Experience in writing complex SQL queries and determining testing types (e.g., data validation, regression), evaluating requirement testability, and creating comprehensive test plans supporting business and technological solutions.
• Experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and their application in testing.
• Clear understanding of data warehouse and data mart testing.
• Techniques for identification and test data preparation.
• Ability to transform complex business logic into SQL or PL/SQL queries.
• Thorough knowledge of Software Test Life Cycle, Test Case Life Cycle, and Defect Life Cycle.
• Creating requirements traceability matrix (RTM).
• Proficiency in test case preparation and execution.
• Experience with QA automation testing tools using Python.
• Extensive exposure to ETL testing with high-level SQL skills.
• Experience working with large data sets and understanding Data Quality Frameworks.
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation.
• Defect tracking experience (e.g., Jira, ALM).
• Experience tuning SQL queries, stored procedures, and views for performance.
• Attention to detail with an analytical mindset.
• Knowledge of data models and entity relationship diagrams.

Required qualifications to be successful in this role :

• Ability to multi-task and adapt quickly to changes while maintaining urgency.
• Experience with Cloud Snowflake and AWS (S3), including Postgres DB, SQL Database, Hadoop Data Lake, and MongoDB.
• Experience using ETL tools like Informatica Power Center & BDM.
• Experience developing data extraction, transformation, and load programs for various data repositories.
• Experience with data integration, cleansing, and analytics.
• Knowledge of data modeling and design principles for data marts and warehouses.
• Excellent problem-solving and analytical skills.
• Strong learning ability and ability to guide team members.
• Self-starter with ownership and responsibility.
• Ability to work independently and within a team.
• Good team player committed to high-quality output.