Job Title - Systems Testing/QA Specialist – Senior

Duration: 1 year

Start Date – 2022-04-01

End Date – 2023-03-31

Location - Toronto

Must Haves:

Knowledge and experience designing and developing N-Tier Client-Server and Internet App Demonstrated experience testing BI solutions (e.g., Cognos and Microsoft Power BI).

AODA testing experience

Experience in testing data warehouses, data marts, ETL processes, web applications, and business intelligence reports.

Description:

A note on Assignment Type: This position is currently listed as "Onsite"; however, the consultant will be remote due to COVID-19 related Work from Home (WFH) direction. Once the I&IT cluster staff are required to return to the office, the resource under this request will be required to work onsite as well.

Required Knowledge / Skills:

Key deliverables to be performed by the Systems Testing/QA Specialist include, but are not limited to, the following:

Support the end-to-end testing strategy to ensure the business requirements are met and the system performs as expected without impact to current business processing;

Analyze business requirements documentation including use cases and non-functional requirements;

Create test strategies and test suites, including test plans, cases and summary reports;

 Analyze test data requirements and create appropriate test data to support the test cases;

Execute system and user acceptance tests adhering to OPS standards;

Verify actual results meet expected results;

Examine test databases using database access tools; e.g., SQL. Analyze and log test results;

Document and monitor resolution of system variances using an automated problem management system;

Provide recommendations to the Project Lead / Sr. Project Manager as to the acceptance or rejection of any new or changed system components;

Provide weekly project status report that reflects progress on tasks, changes based on approved change orders, issues/risks that require management attention and planned activities for the next period;

Use the Cluster tool for internal defect quality management and follow up on defects;

Plan and execute system iteration and regression tests;

Develop presentations for various audiences, as required;

Work with the business and IT areas to complete any activities required to accomplish above and other deliverables as required during the assignment;

Strong experience with testing in a Data Warehouse environment; Strong experience with testing BI applications (e.g. Cognos), running standard reports, creating ad hoc queries, etc.;

Strong experience with applications using ETL (e.g., Informatica) and testing for accurate transformations from source to target;



Other Experience and Skills:

The Systems Testing/QA Specialist must have the following skills and experience:

Demonstrated analytical problem solving and decision-making capabilities;

Demonstrated experience with Test Automation tool in particular Quick Test pro v10.0,

HPQC/HPALM and TFS together to document, track, and record testing processes; Extensive experience in writing test scripts, test cases and test scenarios, testing web applications and reporting defects;

Proficiency with desktop tools (Visio, MS Office, MS Project, MS Outlook);

Strong technical skills in SQL, Databases, and XML;

Demonstrated working experience in dealing with multiple teams representing various areas in delivering the project;

Demonstrated understanding of AODA

Demonstrated working experience testing for WCAB compliance in web applications, experience using screen reader (JAWS) for testing and HiSoftware Compliance Sheriff Tool.

Demonstrated capacity to work collaboratively with client organizations;

A team player with a track record for meeting strict deadlines; and

Demonstrated working experience in an agile and waterfall environment Demonstrated experience producing deliverables on time and on schedule Knowledge of methodologies, processes and standards:

Based on the scope, the Systems Testing/QA Specialist must be proficient in:

Desktop tools (Visio, MS Office, MS Project, MS Outlook);

Proficient with different types of software testing and testing methodologies; and Proficient in manual and automated testing.

Knowledge Transfer

Transfer From Systems Testing/QA Specialist - Senior to Designated CSC Resource

When Knowledge Will Be Transferred:

Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry.

What Knowledge Will Be Transferred:

All deliverables, including design/supporting/release/training documents must be checked into designated version control repositories (for example, SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example, SharePoint site, HPQC, TFS, etc.)

Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walk-through of all documentation as part of the final knowledge transfer activities.

How Knowledge Will Be Transferred:

Knowledge will be transferred through 1 on 1 sessions, emails, document updates and document review with the team.

 Skills

Experience and Skill Set Requirements

Core Skills - 30%

Experience supporting a framework that enables the quick development and deployment of customized online data collection applications used by 5000+ end users within the broader public sector to report on policy, program, achievement and financial data.

Experience in testing accessible web applications compliance level WCAG level AA, preferable and reporting defects, preferable experience using screen reader (Jaws) for testing and Compliance Sherriff tool.

Experience in testing environments built on 3/N-tier web applications using Oracle and/ or SQL Server DBs.

Experience developing all test material - test cases, test scripts, test data, defects, status reports, etc.

Demonstrated experience with Test Automation tool in particular Quick Test pro v10.0, HP quality Center.

Demonstrated experience with both manual and automated testing.

Experience with regression testing.

Experience with System Integration and User Acceptance Testing cycles.

Experience with the use of various testing tools, for example HPQC and Bugzilla.

Experience planning test cycles and strategies and related documentation.

Experience using SQL for testing; Demonstrated experience executing testing as part of the Software Development Life Cycle (SDLC), including experience testing through all of the Software Testing Life Cycle phases.

Demonstrated experience working in an agile and waterfall environment.

Demonstrated experience working as part of a team.

Demonstrated experience problem solving and decision making.

Business Intelligence and Data Warehouse Testing Experience - 30%

Experience in testing data warehouses, data marts, ETL processes, web applications, and business intelligence reports.

Demonstrated experience testing BI solutions (e.g., Cognos and Microsoft Power BI).

Demonstrated experience working with applications using ETL (e.g. Informatica).

Technical Skills - 20%

Proficiency with desktop tools (Visio, MS Office, MS Project, MS Outlook).

Strong technical skills in SQL, Databases, XML.

Demonstrated experience profiling and testing data stored within Databases, XML, CSV, JSON, and Excel files.

Demonstrated experience analyzing and testing data warehouses, data marts, and data extracts.

Demonstrated experience developing and testing presentation layer and business intelligence reports.

Knowledge and experience with .NET framework (4.0+), ASP dot NET  testing, MVC, Entity framework, business entities, WCF, WFF, MS Dynamics, and LINQ, preferable experience in implementing projects tracking solutions with Workflow engine + accessibility.

ASP dot NET testing with C#, Web forms, jscript for multi-browser support CSS with full WCAB AA compliance in web applications, preferable experience using screen reader (JAWS) for testing and High Compliance Sherriff tool.

Communication Skills - 15%

Demonstrated analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills.

Experience in dealing with multiple teams representing various areas in delivering the project

Demonstrated capacity to work collaboratively with client organizations.

A team player with a track record for meeting strict deadlines.

Public Sector Experience - 5%

 Experience working within the Public Sector, particularly within the education ministries, would be an asset.

If you are available, please send your resume to simmi.mittal@2iresourcing.ca OR  refer someone interested