ETL Test Engineer

Galent; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company is seeking a Talent Acquisition Specialist with a focus on IT and non-IT recruitment in Canada. The ideal candidate will have extensive experience in Software Quality Assurance, particularly in data warehouse testing, and will be responsible for ensuring high-quality outputs in testing processes. The role requires strong analytical skills and proficiency in SQL and various QA tools. Join a dynamic team that values innovation and quality in the tech industry.

Qualifications

• 5+ years of Software Quality Assurance experience.
• Experience in writing complex SQL queries and creating test plans.
• Proficiency in QA automation tools.

Responsibilities

• Testing enterprise-level applications including Data Warehouse Testing.
• Creating requirements traceability matrices and executing test cases.
• Experience with data warehouse and data mart testing.

Skills

MDM

SnowFlake

Hadoop

Tools

Python

SQL

Jira

Informatica PowerCenter

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from Galent

Talent Acquisition Specialist - United States | Canada - IT & NON IT Recruitment

Top Capability skills required

• MDM
• SnowFlake
• Hadoop

Key Responsibilities:

• 5+ Years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.
• Experience in writing complex SQL queries, 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.
• Experience with data warehouse and data mart testing.
• Techniques for identifying and preparing test data.
• Ability to translate 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 matrices (RTM).
• Proficiency in test case preparation and execution.
• Experience with QA automation tools using Python.
• Extensive exposure to ETL testing with high-level SQL skills.
• Experience working with large data sets and understanding Data Quality Framework.
• Skills in data analysis, including profiling, auditing, balancing, and reconciliation.
• Defect tracking experience (e.g., Jira, ALM).
• Experience tuning SQL queries, stored procedures, views for performance.
• Attention to detail with an analytical mindset.
• Knowledge of data models and entity relationship diagrams.
• Ability to multitask, adapt quickly, and maintain urgency.

Requirements:

• Experience with Cloud Snowflake, AWS (S3), PostgreSQL, SQL Database, Hadoop Data Lake, and MongoDB.
• Experience with ETL tools like Informatica PowerCenter & BDM.
• Proficiency in developing data extraction, transformation, and load programs for diverse data repositories.
• Experience in data integration, cleansing, and analytics.
• Knowledge of data modeling and design principles for data marts and warehouses.
• Strong problem-solving and analytical skills.
• Willingness to learn and mentor others.
• Self-starter with ownership and responsibility.
• Ability to work independently and in teams.
• Commitment to high-quality output.

Seniority level

• Associate

Employment type

• Full-time

Job function

• Information Technology

Industries

• Technology, Information and Internet

Referrals increase your chances of interviewing at Galent by 2x