Senior ETL/DW Tester
Fredericton, NB, CA
4d ago

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 ResponsibilitiesYour 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. QualificationsExperience : 1 to 6 years experience in a similar role.
  • SkillsQueries, Quality Center, Test Data, Software, Testing, SQLArrayAbout CGIAt 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

    Report this job

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Application form