• Canada
  • Save Job
  • 8 - 10 Years
  • Posted : above 1 month

Job Description:

Data Warehouse Technical Specialist - 19020509


Job Purpose
Oracle Developer with strong analytical and technical ability with 6-8 years of experience in Oracle (PL SQL, Stored Procedures, Query performance tuning) Able to work independently, good communication skills and ability to lead a team

Job Background/context
Proven experience in working on large scale Data Warehouse using Oracle and ETL tools such as Talend

Key Responsibilities
Candidate should be hands on and have a strong analytical and technical ability with 8 - 10 years of experience in Oracle Development in the Data Warehousing domain
Strong communication skills are a key
The position is based in Mississauga, ON and is required to manage day to day delivery work, ensure adherence to process and quality, and identify project/program delivery risks and works on risk mitigation
Requires good analytical skills in order to filter, prioritize and validate potentially complex material from multiple sources and applies skills and knowledge of the business to develop creative solutions to meet client and business needs
The candidate will be required to work with complex and variable issues with substantial potential impact, weighing various alternatives and balancing potentially conflicting needs
Development Value The candidate will work with the state of the art and complex data warehousing applications The candidate will work closely with partner systems and also gain in-depth knowledge of the Client Profitability and Client Revenue domains



Experience in Oracle, PL/SQL Development and Data Warehousing

Experience using one or more programming languages Java proficiency would be a definite asset

Experience in UNIX and shell scripting

Self-starter who is a quick learner of new tools and technologies

Ability to work both independently, with other team members, and across teams

Takes ownership of the work items

Able to work in a fast-paced environment where priority changes occur often

Able to work with distributed teams spread across multiple time zones

Quick learner of new tools and technologies

Required Skills

Substantial experience in Oracle Development (Physical data modelling, PL/SQL programming, Query performance tuning)

Required Oracle

o Physical Data Modelling (creation of Tablespaces, Tables, Indexes, Users and Grants)

o Development (PL/SQL, Stored Procedures, Functions, Packages, Triggers, Materialized Views etc)

o Data Warehousing (Star Schema, ETL and BI)

o Performance Tuning (Well versed with analysing query plans)

Strongly Desired Sybase (IQ) knowledge will be a deciding factor
Desired Familiarity with Cognos will be a plus!


Bachelors degree in Computer Science or equivalent


Able to research and solve complex technical issues in a timely manner
Able to work as a strong team player and individual contributor in a distributed team, with the ability to mentor junior team members where necessary
Strong written and oral communication skills

Citi Canada is an equal opportunity employer Accordingly, we will make accommodations to respond to the needs of people with disabilities (including, without limitation, physical and mental health disabilities) during the recruitment process and otherwise in accordance with law Individuals who view themselves as Aboriginals, members of visible minority or racialized communities, and people with disabilities are encouraged to apply

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Banking
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 11th Jan 2020

Key Skills:

Company Profile:




Company Turnover

Company Size

Why not try out our free online tutorials and gain an edge?

People who search this job also searched for the following Keywords

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status