Offers “CGI”

Expires soon CGI

Intermediate Data Warehouse Developer

  • Victoria, Canada
  • Bachelor's Degree
  • IT development

Job description

Job Description

Intermediate Data Warehouse Developer

Position Description
Founded in 1976, CGI is one of the worlds largest IT and business consulting services firms. We help clients achieve their goals, including becoming customer-centric digital organizations, through high-end IT and business consulting, systems integration and outsourcing services combined with a unique client proximity model and global center of excellence network.

CGI is more than just an IT consulting company; we are a global organization offering a world of opportunities. Become part of a unique culture that gives you the freedom to innovate, to make decisions, to achieve your full potential, and to chart your own career.

CGI's Victoria team is looking for an intermediate 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

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.

Skills

·  ETL
·  Integration testing
·  Oracle BIEE
·  Oracle ODI (Data Integration)
·  Oracle OWB (Warehouse Builder)
·  SQL/PL SQL
·  Test Planning & Implementation

Reference

642466

Make every future a success.
  • Job directory
  • Business directory