Talent.com

Oracle consultant Jobs in Kingston, ON

Last updated: 1 day ago
  • Promoted
Specialized IT Consultant - Senior

Specialized IT Consultant - Senior

2iResourcingON, Canada
Full-time
If interested, please share your latest resume at.RQ08199 - Specialized IT Consultant – Senior.Ministry of Public and Business Service Delivery and Procurement. Candidate must be able to work 3 days...Show moreLast updated: 1 day ago
  • Promoted
Bilingual Consultant

Bilingual Consultant

Collective ResultsOntario, Canada, Canada
CA$100,000.00 yearly
Full-time
Are you passionate about driving meaningful change in the health and human services not-for-profit, public, and charitable sectors? Do you thrive in a collaborative environment where your bilingual...Show moreLast updated: 5 days ago
  • Promoted
ISA Consultant

ISA Consultant

Matchtech North AmericaOntario, Canada
Matchtech are supporting a key global client to recruit for a number of ISA Consultants at both Senior and Principal Level to support railway projects across the globe. Our client has won a number o...Show moreLast updated: 18 days ago
  • Promoted
Senior Management Consultant

Senior Management Consultant

Coreio Inc.ON, Canada
Full-time
Toronto-based IT services provider that delivers IT Infrastructure and Operations solutions for enterprise-scale companies across North America. We build on our 35-plus year history as a strategic p...Show moreLast updated: 1 day ago
  • Promoted
Business Analyst Consultant

Business Analyst Consultant

Equitable Life of CanadaWaterloo, Region of Waterloo, Canada
Full-time +1
At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and colla...Show moreLast updated: 2 days ago
  • Promoted
Business Analyst Consultant

Business Analyst Consultant

ImpactLifeWaterloo, Region of Waterloo, Canada
Full-time +1
At Equitable, we realize that your work life is not just about performing a job; it's about being part of a workplace that helps you grow and reach your full potential. Within our friendly and colla...Show moreLast updated: 2 days ago
Oracle OTM Developer / Designer

Oracle OTM Developer / Designer

Juventus ConsultingOntario
This contract opportunity is for 5 months, the end client is in BC, with locations in Memphis, TN.Per Diem expenses range from 60 to 100 USD, depending on travel location.Some remote work is possib...Show moreLast updated: 30+ days ago
  • Promoted
Consultant Solicitor

Consultant Solicitor

Taylor RoseKingston, ON, Canada
Full-time
This range is provided by Taylor Rose.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Enjoy a career without limits, earning up to 75% of your b...Show moreLast updated: 17 days ago
  • Promoted
Business Consultant

Business Consultant

IFG International Financial Group LtdON, Canada
Temporary
Our client, a Top 5 Bank in Canada is looking to hire a.This role is currently hybrid, 1-2 days a month in office in Toronto. This person is responsible for providing objective advice, expertise and...Show moreLast updated: 18 days ago
  • Promoted
Product Development Consultant

Product Development Consultant

Toronto Police Widows & Orphans FundOntario, Canada, Canada
Full-time
SummaryThe Product Development Consultant will lead the development of a new life insurance product and market, and building the Fund’s Business Case for regulatory approval.The role will include c...Show moreLast updated: 2 days ago
  • Promoted
Managing Consultant

Managing Consultant

People CorporationWaterloo, Region of Waterloo, Canada
Full-time
We are seeking a Managing Consultant to join our team in the Waterloo region.The Managing Consultant’s primary responsibility will be to retain and grow relationships for an assigned block of group...Show moreLast updated: 30+ days ago
  • Promoted
Senior Underwriting Consultant

Senior Underwriting Consultant

DesjardinsOntario, Canada
Full-time
Are you an experienced underwriter at a Senior, Consultant, and High Net worth level.You will analyze, assess risks, and authorize life, critical illness, and disability insurance files where appro...Show moreLast updated: 10 days ago
Oracle Technical Pre-Sales Consultant - Oracle Cloud HCM & ERP – Senior Sales Consultant – Canada

Oracle Technical Pre-Sales Consultant - Oracle Cloud HCM & ERP – Senior Sales Consultant – Canada

OracleON, Canada
CA$77,500.00–CA$144,000.00 yearly
As a Technical Pre-Sales Consultant - Oracle Cloud HCM & ERP – Senior Sales Consultant (Advanced Technology Sales Consultant), you will work as a member of a pre-sales team to solve business and te...Show moreLast updated: 30+ days ago
  • Promoted
RQ08570 Technology Architect

RQ08570 Technology Architect

Randstad CanadaGolden Horseshoe, ON, Canada
Full-time
We are seeking a Technology Architect to lead and implement large-scale system design and solution planning, emphasizing maximum availability architectures, hybrid / on-premises / cloud approaches, and...Show moreLast updated: 3 days ago
  • Promoted
Senior Solution Consultant

Senior Solution Consultant

Odaia Intelligence Inc.ON, Canada
Full-time +1
An Ancient Greek word referring to “tools of the trade.ODAIA is a remote first organization, all our positions are WFH.ODAIA helps pharma sales and marketing teams by using AI to understand and pre...Show moreLast updated: 1 day ago
Lifestyle Rental Consultant

Lifestyle Rental Consultant

The Skyline Group of CompaniesKingston, ON, CA
Quick Apply
As a result of our continued growth, Skyline is seeking an enthusiastic and energetic person to enhance the quality of our organization! We are looking for a motivated and sales-orientated candidat...Show moreLast updated: 22 days ago
  • Promoted
Program Coordinator Consultant

Program Coordinator Consultant

ClinChoiceON, Canada
Full-time
Program Coordinator Consultant.Are you interested in working directly for a single sponsor while having the security and additional career opportunities that working for a global CRO can bring? Our...Show moreLast updated: 4 days ago
QA 6264-22

QA 6264-22

FoilconLa Gran YajaToronto, Ontario, Canada
CA$43.00 hourly
HM Note : This hybrid role is three (3) days in the office.Help organization transform way of doing QA.Transform from a manual environment to automated test framework. Not just focused on execution -...Show moreLast updated: 30+ days ago
Oracle EBS Consultant

Oracle EBS Consultant

eTeamRemote, ON
CA$40.00–CA$45.00 hourly
Remote
Proficient in Oracle R Platform for Accounts Payable and Fixed Assets module.Good working experience with DB and integration knowledge with Oracle EBS. Proficient in SQL and relational modeling for ...Show moreLast updated: 30+ days ago
Digital Accessibility Consultant

Digital Accessibility Consultant

IntopiaON, CA
CA$100,000.00–CA$140,000.00 yearly
Remote
Full-time
Quick Apply
We are a digital consultancy with a difference.We believe everyone has a right to inclusive digital experiences.This is our purpose, our quest, the white rabbit we follow.We do what we love, with p...Show moreLast updated: 30+ days ago
Specialized IT Consultant - Senior

Specialized IT Consultant - Senior

2iResourcingON, Canada
1 day ago
Job type
  • Full-time
Job description

If interested, please share your latest resume at [email protected] / [email protected]

RQ08199 - Specialized IT Consultant – Senior

Client : Ministry of Public and Business Service Delivery and Procurement

Period : 12 months

Start Date : 2025-04-01

End Date : 2026-03-31

Working Hrs. : 7.25 Hrs. / day

Location : 777 Bay St

Hybrid : Candidate must be able to work 3 days onsite and 2 days remote.

Assignment Type : This position is currently listed as "Hybrid" as consultants may be required to work partly in the physical workplace and partly remotely. The details of this arrangement will be at the Hiring Manager's discretion.

Must Have :

  • Demonstrated development and solution design experience in an environment where Oracle, Informatica and Cognos are used together.
  • Demonstrated experience designing, developing, and implementing Informatica ETL solutions.
  • Demonstrates experience designing and developing BI Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.

Description

Evaluation Project Requirements Evaluation Breakdown

Technical Skills - 45%

  • Working knowledge of the entire Data Dictionary, data mapping.
  • Working knowledge of the Business Process Design Re-engineering for applications.
  • 5+ years of demonstrated experience and skills using Oracle Data Integrator and / or Informatica ETL tools.
  • Experience enhancing performance of ETL code and SQL Queries.
  • Experience developing ETL routines using Informatica and / or SSIS in a data warehousing environment or large data migration.
  • Experience Designing Data warehouse components and ETL Scripts.
  • Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
  • 5+ years of experience with Unix scripting.
  • Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
  • Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
  • Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
  • Experience in developing the Application Code package using MS Visual Source Safe. Demonstrated experience performing system testing, unit testing, and user acceptance testing.
  • Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
  • Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
  • Experience in leading development and modelling of applications, specifically hierarchical data model applications.
  • Core Skills - 35%

  • Experience performing the design of data warehouse and related components, including working knowledge of SQL Server, Oracle SQL, PL / SQL, and their optimization techniques.
  • Experience with systems design and development, and related methods, techniques, practices and standards.
  • Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
  • Experience documenting application designs and specifications, and drafting policies and procedures for ETL processes and Power BI-compatible formats.
  • Working knowledge of aggregate reporting and ETL processes, specifically using tools like Informatica, SSIS , and Fabric Data Factory.
  • Troubleshooting of production issues and creating fixes for any unplanned deployments.
  • Defect investigation, resolution and assignment to team members using defect / issue management tools, e.g. Client ALM or Client Service Manager.
  • Demonstrated experience in coordinating and planning for the modernization of large, complex multi-platform, multi-tier information technology systems, particularly in ETL design, data migration, and Fabric Data Factory integration.
  • Proven experience using a variety of methodologies to carry-out the software development lifecycle (e.g., Agile, waterfall, etc.).
  • Communication Skills - 15%

  • Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications.
  • Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives.
  • Public Sector Experience - 5%

  • Previous public sector experience in an organization of equivalent size.
  • J-18808-Ljbffr