Search jobs > Toronto, ON > Data analyst

Test Analyst (ETL)Data warehousing @ Markham - long Term

Atlantis IT group
Toronto, ON, Canada
Full-time
Quick Apply

Role name : Test Analyst (ETL)Data warehousing

Location : Markham, ON

Duration : long Term

Role Description :

Test Analyst (ETL)Data warehousing, ETL Testing, Good SQL 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

Competencies : Data Warehouse BI Testing, Data Warehouse

Thanks & Regards,

Harshaja

Apptoza Inc.

Email : [email protected]

Phone# : 647-953-1625

4 days ago
Related jobs
Atlantis IT group
Toronto, Ontario

Role name: Test Analyst (ETL)Data warehousing</p> <p style="margin-left:36px">Location :Markham, ON</p> <p style="margin-left:36px">Duration : long Term</p> <p style="margin-left:36px">Role Description:</p> <p style="mar...

S.i. Systems
Toronto, Ontario

Applications Operations Services & Quality Engineering (AOSQE) is looking for a Senior Software Development Engineer in Test (Data/ETL Testing) with a proven track record of leading testing activities to join the Data Testing Chapter. QA Analyst to create and execute automation tests for Data/ETL pr...

Atlantis IT group
Toronto, Ontario

Role - Financial / Business Analyst</p> <p>Location - Toronto, ON - Hybrid</p> <p>Duration - Long Term</p> <p>1. Conduct UAT including designing tests, develop detailed test cases and test plans, documenting and sharing results. Strong Analytical and data mining s...

S.i. Systems
Toronto, Ontario

Applications Operations Services & Quality Engineering (AOSQE) is looking for a Senior Software Development Engineer in Test (Data/ETL Testing) with a proven track record of leading testing activities to join the Data Testing Chapter. QA Analyst to create and execute automation tests for Data/ETL pr...

Scotiabank
Toronto, Ontario

From root cause and business requirements analysis, aided by strong data and technical system analysis, to solutioning, development, testing, and release to production, the incumbent will ensure timely resolution of high priority Production Support tickets. Strong hands-on experience with data analy...

Scotiabank
Toronto, Ontario

Strong hands-on experience with data analysis and ETL (SQL, Python, Kafka, Jupyter, Java, XML, and JSON). Change request delivery – requirements gathering, design, implementation, and testing as part of new regulatory initiatives. Support of advanced issue triage and ad-hoc data analysis and reporti...

City of Markham Ontario
Markham, Ontario

Working with departmental staff across the organization to identify and implement GIS and Data solutions (applications, data products, analysis work) that improve business processes, effectiveness and support decision making. Assist in the development and implementation of data standards and process...

Mon Sheong Foundation
Markham, Ontario

Completion of a course/ certification program on long-term care management recognized by the Ontario Ministry of Health and Long-Term Care or eligible and willing to seek qualification. Administrator (Markham Long Term Care Centre). To ensure the Home meets or exceeds all requirements of the LTCHA, ...

Project X
Toronto, Ontario

Proficiency in data modeling, database design, and data warehousing. Qualifications: 5+ years of experience in a Data Architect role or similar position with a focus on data management, data governance, and architecture design. We are passionate about building long-term relationships with our client...

CGI
Toronto, Ontario

About the Job Role: As a Data Test Engineer must have strong technical capabilities and good knowledge of the coding languages commonly used in ETL development, such as Python, SQL and XML and Data warehousing Concepts. Should have adequate experience and clear understanding of data warehouse and da...