Senior Data Warehouse Developer (Oracle)

Category: Development/Engineering
City: Victoria, British Columbia, Canada
Position ID: J0219-1761
Employment Type: Full Time

Position Description

CGI in Canada
Canadian roots, global reach

Founded in Canada in 1976, CGI has evolved into the country’s largest IT services provider, serving as a long-term, committed partner to clients in Canada and in more than 40 countries around the world. With more than 12,000 professionals across Canada, we work where our clients do business, providing local responsiveness and accountability that ensure the highest level of service and support.

CGI's Victoria team is looking for a Senior data warehouse developer/architect to develop and support Oracle Data Integrator (ODI) Extract/Transform/Load (ETL) mappings. This role requires carrying out a wide variety of advanced operations involving extracting, transforming, loading, administrative, statistical, and other data.

Your future duties and responsibilities

In this role you will guide a small team performing ODI development work and building ODI framework components.

You'll develop complex data transformation maps (read data from variety of data sources and migrate/load data into Oracle databases).

You'll apply your extensive experience using and defining configuration management processes for ODI development artifacts and utilize all ODI tools including Topology, Security Manager, Designer and Operator to create/modify/manage ODI configurations and mappings.

Required qualifications to be successful in this role

Subject matter expertise with ODI and Oracle Warehouse Builder ETL operations and Data Warehousing areas with a thorough understanding of Oracle Technologies, Data Modeling, Star Schema design and Oracle Applications Architecture (12c)
Experience developing and executing unit and integration test plans
The ability to analyze data for creating ETL Mappings and associated artifacts using ODI


Expert knowledge of complex Data Warehouse ETL operations
6+ years’ experience with Oracle relational Databases, Data Warehouses, Data Modeling, and Star Schema design
Expert knowledge of Oracle ODI Release 12c
6+ years SQL experience, preferably Oracle PL-SQL
Strong experience in designing technical architecture, configuring all components of ODI, Data transformation and associated development and security activities
Experience working directly with end users is preferred
Thorough knowledge of systems design, management principles and new systems design techniques
Ability to guide and coordinate the work of others
Ability to communicate effectively both written and verbal
Ability to interface with CGI Clients, Project Managers and other Leaders to communicate project status, issue and resolutions


Expertise in Oracle Business Intelligence Enterprise Edition (OBIEE) is an asset so the candidate can assist with the presentation tier as well;
Experience of converting legacy Data Warehouse systems in ODI technologies


A Bachelor’s degree or equivalent is required


  • Test Planning & Implementation
  • Oracle BIEE
  • Oracle OWB (Warehouse Builder)
  • ETL
  • Oracle ODI (Data Integration)
  • Integration testing

What you can expect from us

Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at

No unsolicited agency referrals please.

CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.