Senior ETL Cognos BI Systems Testing / QA Specialist

  • Company:
    Cynet Systems
  • Location:
  • Salary:
    negotiable / month
  • Job type:
  • Posted:
    3 days ago
  • Category:

Job Description:


Provides advice on the testing strategy, test plans, the selection of testing tools, and the identification of resources required for testing.
Plans and organizes testing efforts for large systems in Graphical User Interface (GUI) and non-Graphical User Interface (GUI) environments, including the execution of systems integration tests, specialized tests, and user acceptance testing (e.g., stress tests).
The Quality Assurance Specialist is responsible for the development of test plans, test scripts and test cases and executing these against the various components.
The tester will work with the testing lead and IT lead of each project as well as the project team members in the analysis, design, development, implementation and ongoing support of the required systems.

General Skills:

Experience in planning, organizing and implementing testing efforts at the specified experience level.
Knowledge of structured methodologies for the development, design, implementation and maintenance of applications.
Knowledge and experience in the use of Computer-Aided Software Engineering (CASE) tools and data query tools to aid in the development of test cases.
Knowledge and experience in the use of automated test tools and version control systems on one or more platforms.
Experience executing functional tests, non-functional tests and systems level integration tests.
Experience supporting user acceptance testing and participating in UAT activities.
Experience with quality assurance principles, practices, tools and structured methodologies.
Experience creating testing strategy documentation, test plans, test cases and test data for various types and phases of testing, including technical and business functional validation.
Experience in quality assurance and testing, including unit testing, integration testing, load testing, performance testing, etc.
Knowledge and experience in all phases of the Systems Development Life Cycle.
Excellent analytical, problem-solving and decision-making skills; organizational, creativity and perseverance skills; verbal and written communication skills; and interpersonal skills.
A team player with a track record for meeting deadlines.
Knowledge of one or more automated testing tools.

Desirable Skills:

Knowledge and experience in at least one programming language.
Experience in the use of information retrieval packages.
Knowledge and understanding of testing methods in an object-oriented environment.
Knowledge and understanding of Information Management principles, concepts, policies and practices.
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
Experience planning and organizing testing efforts for both large and small systems.
Experience coding automated test scripts to produce sets of automated test cases.
Experience testing Commercial Off-the Shelf Applications (COTS).
Responsibilities/Assignment Deliverables.

Required Knowledge / Skills:

The engagement will provide for a Systems Testing/QA Specialist to test programs and applications using a variety of tools, such as SQL queries, HP Application Lifecycle.
Management / HP (HP-ALM), Load Runner, and Team Foundation Server (TFS).

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

Implementing the automation of new and existing testing scripts using Quick Test Pro v10.0.
Leading the analysis, design, development and testing on assigned projects.
Creating test strategy test plan, test cases documentation and test scripts.
Executing functional, regression and performance testing based on the test scripts developed.
Lead all testing activities for front end BI reporting and back end data flow and transformations.
Reporting on the status of test execution and testing results, documenting defects.
Preparing for, supporting and participating in System Integration (SIT) testing, System.
Acceptance (SAT) testing and User Acceptance (UAT) testing.
Participating in project design and code walkthroughs.
Providing recommendations to Project Lead/Senior Project Managers as to the acceptance or rejection of any new or changed system components.
Planning, creating and implementing test data beds for testing.
Performing knowledge transfer to the Ministry staff.

Other Experience and Skills:

The Systems Testing/QA Specialist Level 3 must have a minimum of 10+ years of the following skills and experience:

All General Skills outlined in the “Task-Based I&IT Services” Agreement Systems Testing/QA Specialist, Level 3.
Testing a web application, including database, data warehouse, presentation layer and reports.
Analytical problem solving and decision making capabilities.
Executing different types of software testing processes and testing methodologies Using HP Quality Centre (HPQC) and Team Foundation Server (TFS) to document, track and report on testing progress.
SQL scripting, manual testing, testing automation (using a tool like Quick Test pro v10.0) and performance testing (using a tool like Loadrunner).
Experience testing Cognos BI reports, as well as back end data layers.
Experience testing data flow from source to target, including transformation and loading logic.
Experience testing in Power BI or other BI reporting tools.
Writing test scripts, test cases and test scenarios, testing web applications and reporting defects.
Working collaboratively with client organizations and with multiple teams representing various areas in delivering the project.
Creating test data for a complex system, based on business requirements.
Preparing for, conducting and supporting SIT, SAT and UAT testing.
Working with multiple teams representing various areas in delivering the project.
Ability to communicate clearly in both written and verbal formats, to both technical and non technical audiences.
Ability to produce deliverables on time and on schedule.

Knowledge of methodologies, processes and standards:

Based on the scope, the Systems Testing/QA Specialist Level-3 should possess:

In-depth understanding of the entire Software Testing processes.
Proficient with different types of software testing and testing methodologies.
Proficient in manual and automated testing.
Proficient with testing data flow and transformations, front-end reports and identifying data quality issues.


QA Skills (30%):

Demonstrates 10+ years of experience in System Testing.
Demonstrated experience with testing through the entire BI Software Testing cycle, both back-end and front-end testing.
Demonstrated experience with documenting test scenarios, testing results, testing artifacts and tickets.
Demonstrated experience in writing test scripts, test cases and test scenarios, testing web applications and reporting defects.
Demonstrated experience in testing for AODA compliance in web applications, using tools such as Compliance Sheriff,NVDA, etc.
Demonstrated experience with data analysis, data profiling, data migration as well as tabular and multidimensional models.

QA Methodologies and Tools (25%):

Demonstrated experience with the use of various types of software testing and testing methodologies in manual and automated testing.
Demonstrated experience with testing tools such as Quick Test pro v10.0 and HP quality Center to create automated test scripts.
Demonstrated experience with using tools such as HP Application Lifecycle.
Management / HP Quality Centre (HPQC).
Demonstrated experience identifying data quality issues.

Technical Skills (25%):

Demonstrated experience with testing BI applications such as Cognos, Microsoft Power BI.
Demonstrated experience in writing and testing complex SQL queries, Reports, Cube and or Dashboards.
Demonstrated experience with the use of complex SQLs queries to accelerate and automate testing methodologies.
Demonstrated experience with applications using ETL (e.g., Informatica, SSIS).
Demonstrated experience with testing for accurate data transformations and data flow from source to target.
Working knowledge and experience with testing within a Data Warehouse environment.

Soft Skills (10%):

Demonstrates the ability to work collaboratively with other groups to ensure optimal integration.
Demonstrated experience with leading a team of testers.
Demonstrated experience in liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders.
Strong verbal and written communication for day-to-day tasks, issue tracking, reporting and facilitating the resolution of issues and risks for all project activities.
Demonstrated experience with providing input into changes required to business and/or system requirements, change requests, project artefacts, as well as requirement gathering sessions.
Demonstrated experience in documenting, consulting and presenting for a diverse audience of stakeholders (both technical and non-technical).
Demonstrated experience in providing technical advice and guidance.

Public Sector Experience (10%):

Previous public sector experience in an organization of equivalent size or complexity to public sector client.