Data Warehouse Developer

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

Position Description

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 Data Warehouse/ODI Developer to execute ETL and OLAP processes with superior problem solving skills in order to support our data warehouse team. This role requires extracting, transforming and loading data using ETL/OLAP tools. As well, the role will be involved in future ODI development work.

Your future duties and responsibilities

Extract, Transform and Load (ETL): Extract data from multiple sources and load it into a central data warehouse using ELT tools, monitor processing progress and errors, review the PL/SQL packages/procedures to identify and resolve any issues, and run SQL queries to monitor the data quality
Online Analytical Processing (OLAP): Execute and maintain scripts and chains using Oracle Scheduler to populate data marts, review error logs, check data quality, and perform data migration
Data quality assessment, problem solving, and client communication
Oracle Data Integrator (ODI) Development: Develop data transformation mappings (read data from a variety of data sources and migrate/load data into Oracle databases)
Configure management processes for ODI development artifacts and use all ODI tools including Topology, Security Manager, Designer, and Operator to create, modify, and manage ODI configurations and mappings

Required qualifications to be successful in this role

Proven experience as a data analyst with excellent problem solving skills
Ability to analyze data to create ETL mappings and associated artifacts using ODI
Proven experience with Data Warehouse ETL operations
Minimum five years of related work experience with a background in RDBMS
Minimum three years of experience with ODI
Minimum five years of ETL architecture design experience within data warehousing environments governed by applying appropriate methodologies and ETL standards
Experience creating integration and data warehouse technical specifications
Conceptual, logical, and physical data modeling through the use of data modeling tools
Strong and effective written and verbal communication skills

Preferred:
Data Warehouse Analyst with development experience in ODI technologies
ODI developer certification

Education:
Bachelor’s degree or equivalent is required

Skills

  • Data Analysis
  • Oracle OWB (Warehouse Builder)
  • ETL
  • SQL/PL SQL
  • Oracle ODI (Data Integration)

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.