Data Test Analyst-Snowflake,MDM,ETL,Hadoop

Infinity Solutions; Ontario; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company in Ontario is seeking a Software Quality Assurance professional with over 5 years of experience in enterprise-level applications. The ideal candidate will have expertise in SQL, data warehouse testing, and QA automation tools. Responsibilities include evaluating test requirements, creating comprehensive test plans, and conducting various testing phases. The role requires strong analytical skills, the ability to work independently and within a team, and a commitment to high-quality output.

Qualifications

• 5+ years in Software Quality Assurance.
• Experience with Cloud Snowflake and AWS.
• Proficiency in test case preparation and execution.

Responsibilities

• Evaluate testability of requirements and create test plans.
• Conduct data validation and regression testing.
• Develop ETL programs for various data repositories.

Skills

SQL

Data Validation

Regression Testing

Data Warehouse Testing

ETL Testing

Analytical Skills

Tools

Jira

Informatica PowerCenter

AWS

Python

Job description

5+ Years of Software Quality Assurance experience on enterprise-level applications, including Data Warehouse Testing.

Experience in writing complex SQL queries and determining the types of testing required (e.g., data validation, regression). Ability to evaluate the testability of requirements and create 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.

Knowledge of identification and test data preparation techniques.

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.

Experience creating requirements traceability matrices (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 Framework.

Experience in data analysis, including profiling, auditing, balancing, and reconciliation.

Defect tracking experience (e.g., Jira, ALM).

Experience tuning SQL queries, stored procedures, views, etc., for performance improvements.

Detail-oriented with an analytical mindset.

Knowledge of data models and entity-relationship diagrams.

Ability to multi-task, adapt quickly to changes, and maintain urgency in completing tasks.

Requirements:

Experience with Cloud Snowflake and AWS (S3), including PostgreSQL, SQL Database, Hadoop Data Lake, and MongoDB.

Experience using ETL tools like Informatica PowerCenter & BDM.

Experience developing data extraction, transformation, and load (ETL) 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, capable of handling challenging situations.

Strong learning ability to acquire and share knowledge with team members.

Self-starter with responsibility, ownership, and self-motivation.

Ability to work independently and within a team, committed to high-quality output.