Data Warehouse Developer

Category: Development/Engineering
City: Victoria, British Columbia, Canada
Position ID: J0219-1760
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 developer for developing and supporting Oracle Data Integrator (ODI) Extract/Transform/Load (ETL) mappings. This role requires extracting, transforming, loading, administrative, statistical, and other data.

Your future duties and responsibilities

In this role, you will perform ODI development work and build 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 will leverage your experience using configuration management processes for ODI development artifacts and be able to use 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

Experience developing and executing unit and integration test plans
The ability to analyze data for creating ETL Mappings and associated artifacts using ODI

Qualifications

Knowledge of Data Warehouse ETL operations
Working knowledge of Oracle relational Databases, Data Modeling and Oracle ODI Release
12c
3+ years SQL experience, preferably Oracle PL/SQL
Experience working directly with end users is preferred
Working knowledge of systems design, management principles and new systems design techniques
Ability to communicate effectively both written and verbal
Ability to interface with CGI Clients and Project Managers

Preferred:

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

Education:

Bachelor’s degree or equivalent is required

Skills

  • Test Planning & Implementation
  • Oracle BIEE
  • Oracle OWB (Warehouse Builder)
  • ETL
  • SQL/PL SQL
  • 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 www.cgi.com.

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.