Discover

The Opportunity

Fredericton, NB
Information Technology
Experienced
Full-time

We offer the opportunity to work with Canada's largest Information Technology Outsourcing and Management Consulting Company with a true global presence in a fast-paced and energetic atmosphere where your personal and professional growth is accelerated by your desire and sense of commitment. CGI's continuous growth is a testament to the confidence clients place in them and to the dedication of their professionals. At CGI, all employees are called members because they feel a powerful sense of ownership and accountability. Members at CGI are building their own company ? in 100+ offices worldwide. CGI has the global resources, expertise, stability and dedicated professionals needed to achieve results for clients ? and for members; that's why an astounding 90 percent of them are CGI shareholders. 

We're expanding in Atlantic Canada and we need your skills, enthusiasm, and dedication as part of our team. 

 

Required qualifications to be successful in this role 
? Strong , hands on and Proven Data Warehouse (DW) development/testing experience (MUST have) 

? Solid hands on QA test experience with DW/relational database including designing , creating and executing complex SQL queries, manipulating test data, validating stored procedures, jobs, triggers and replication 

? Hands-on experience with SQL and querying multi-dimensional databases testing 

? Reconciliation and Data Validation using SQL 

? Solid understanding of databases and systems and the ability to communicate effectively across groups 

? Ability to work in a fast pace environment with deadlines 

? Self Starter, with strong confidence level. 

? Flexible in thought and creative in approach to testing. 


Basic Qualifications: 

? 5 years as Data warehouse developer or tester ( Must have) 

? 3+ years QA/Testing Lifecycle 

? 3+ years DB related testing 

? 2+ years HP Quality Center/ ALM 

? Natezza and Financial domain knowledge is an asset 

? Hadoop experience is a bonus 

? Risk or Capital Market related experience is an asset 

Required Level of Education: 

? Bachelor's Degree in Computer Science or Diploma in IT with equivalent IT experience 

What you'll do

Responsibilities

Your future duties and responsibilities
? Review and understand BRD/SRD
? Create SIT test cases/test data /Test execution
? Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test case
? Validates data by running queries in the database and verify the results match the expectations
? Analyzes and troubleshoots erroneous results, determines the root causes, logs the defects in HP Quality Center/ALM and enables defect management, including working with the development team on the resolution of Software related defects
? Works closely with software development team (Business Analysts, Developers and QA) to ensure timely and effective testing effort.
? Creating requirements traceability matrix (RTM) for the releases.

What you'll need

Qualifications

Experience: 1 to 6 years experience in a similar role.

We're looking for

Core Skills

Queries Quality Center Test Data Software Testing SQL

A little bit about us

CGI

At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com

Are you interested?

Work With Us

At CGI, we're a team of builders. We call our employees members because all who join CGI are building their own company - one that has grown to 65,000 professionals located in 40 countries. Founded in 1976, CGI is a leading IT and business process services firm committed to helping clients succeed. We have the global resources, expertise, stability and dedicated professionals needed to achieve results for our clients - and for our members. Come grow with us. Learn more at www.cgi.com.
This is a great opportunity to join a winning team. CGI offers a competitive compensation package with opportunities for growth and professional development. Benefits for full-time, permanent members start on the first day of employment and include a paid time-off program and profit participation and stock purchase plans.