Apptad - Systems Testing/QA Specialist - Senior [DE-365]

28 Jan

Apptad

Old Toronto

28 Jan

Apptad

Old Toronto

Job Title: Apptad - Systems Testing/QA Specialist - Senior
Job Location: Toronto (Hybrid)
Job Duration: Long-Term Contract One of our Government clients is looking for a Senior Systems Testing/QA Specialist
Job Description

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.

Must haves:

- Experience in testing large volume online data collection applications used by 5000+ internal and external end users on multiple areas
- Test Automation tools scripting experience eg Quick Test pro v10.0/UFT, HP Quality Center(HPQC), Azure DevOps
- Data warehouse, data marts, ETL processes and BI solutions testing experience (e.g., Cognos, Microsoft Power BI, Informatica)
- Experience using SQL scripting for testing environments built on 3/N-tier web applications using Oracle and/ or SQL Server DBs;
- Demonstrated AODA testing experience with full WCAG AA compliance in-web applications, screen readers experience (eg Jaws, NVDA)

Selection Criteria

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 Unified Functional Testing (UFT), 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 Azure DevOps, HP Quality Center (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%

- Demonstrated an in-depth understanding of data warehousing concepts, architecture, and best practices.
- Experience in testing BI solutions like Cognos and Power BI
- Demonstrated hands-on experience with developing and optimizing ETL processes.
- Experience with tools such as Informatica or SSIS.

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.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.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.