Position: Sr. Data Test Analyst

Location: Toronto, Canada

Work Model: Hybrid

Top Capability skills required

1. Customer MDM
2. SnowFlake
3. Hadoop

Key Responsibilities:

• 5+ Years of Software Quality Assurance experience on enterprise level applications which includes
• Data Warehouse Testing.
• Experience in writing complex SQL queries, Experience in writing complex SQL queries, ability to
• determine the types of testing that must be conducted (i.e., data validation, regression, etc.),
• including evaluating the testability of requirements and create a comprehensive test plan that
• supports the business and technological solutions being delivered.
• Should have experience testing multiple test phases in medium to large projects.
• Understanding of information governance principles and how they could apply in a testing capacity.
• Should have adequate experience and clear understanding of data warehouse and data mart testing.
• 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, Defect Life Cycle etc.
• Creating requirements traceability matrix (RTM)
• Proficiency with Test Case Preparation and Execution.
• QA Automation Test tools expertise using Python.
• Extensive exposure to ETL testing with high-level of SQL skills is required.
• Should have exposure to large data sets and understand Data Quality Framework.
• Experience in data analysis, including profiling, auditing, balancing, and reconciliation, in an
• Information technology operating environment.
• Defect tracking experience (i.e., Jira, ALM, etc.)
• Experience in tuning SQL queries, Stored Procedures, Views, etc. for performance improvements Should be detail oriented with analytical mind set.
• Knowledge of data models and entity relationship diagrams.
• Must have the ability to multi-task and adapt quickly to changes while maintaining urgency incompleting assigned tasks.

Requirements:

• Experience with Cloud Snowflake and AWS(S3) including PostgreSQL DB, SQL Database, Hadoop Data Lake, and Mongo DB
• Must have experience in using ETL Tool informatica Power Center & BDM
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
• Experience with data integration, data cleansing, and data analytics
• Experience with data modeling and design principles for data marts and data warehouses
• Excellent problem solving and analytical skills, able to handle challenging situations and act appropriately.
• Excellent learning skills must learn and also guide other team members on their knowledge.
• Should be a self-starter; takes responsibility and ownership and is self-driven.
• Ability to work independently with minimal supervision as well as ability to work within a team.
• Good team player; commitment to high-quality output and service.