Talent.com

Oracle pl sql developer Jobs in Ottawa, ON

Last updated: 14 hours 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: 3 days ago
Junior Software Developer

Junior Software Developer

CB CanadaOttawa, Ontario, Canada
CA$43.00 hourly
Founded in 1967, ADGA is a privately owned and operated Canadian company.We employ over 700 highly skilled team members who apply their knowledge and expertise in service delivery of advanced techn...Show moreLast updated: 30+ days ago
System Analyst

System Analyst

Optimal Growth TechnologiesGatineau, QC, Canada
Full-time
The System Analyst will be a Business Applications Solutions team member, responsible for developing, maintaining, and supporting cloud-based solutions and client applications using various technol...Show moreLast updated: 30+ days ago
Reliability / Maintenance Engineer - PL#14134

Reliability / Maintenance Engineer - PL#14134

Peter Lucas Project Management Inc.Ottawa, ON, CA
Full-time
Quick Apply
Reliability and Maintenance Engineer.This critical role involves developing and implementing asset maintenance strategies, conducting root cause analysis, creating risk mitigation plans, and optimi...Show moreLast updated: 30+ days ago
  • Promoted
System Analyst

System Analyst

Brookfield RenewableGatineau, QC, Canada
Brookfield Renewable is one of the core businesses under Brookfield Corporation (“Brookfield”), one of the world’s leading alternative asset managers. Brookfield Renewable is one of the world’s larg...Show moreLast updated: 29 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
RQ08372 - Technology Architect - Senior

RQ08372 - Technology Architect - Senior

S M Software Solutions IncON, CA
Full-time
Quick Apply
We have received a new requirement from one of the ministries in Ontario.Please refer to the details provided below : We are unable to submit a candidate without below mandatory documents.Please ens...Show moreLast updated: 4 days ago
Senior Java Developer

Senior Java Developer

Canadian Institute for Health InformationOttawa
CA$77,390.00 yearly
At CIHI, we recognize what matters to our employees.Some of the benefits of working at CIHI include.HOOPP Pension Plan (Defined Benefits Pension). Generous vacation days for permanent and long-term ...Show moreLast updated: 30+ days ago
  • Promoted
Consultant Oracle Cloud EPM

Consultant Oracle Cloud EPM

IBM ComputingOttawa, ON, Canada
En tant que conseiller en applications intégrées pour IBM, soyez prêts à vous attaquer à de nombreuses directives essentielles à la mission de l'entreprise. Notre équipe s'attaque au problème de la ...Show moreLast updated: 30+ days ago
Bilingual (French / English) Oracle Apex Developer to create Oracle PL / SQL stored procedures and complete a migration of form6i applications to Apex.

Bilingual (French / English) Oracle Apex Developer to create Oracle PL / SQL stored procedures and complete a migration of form6i applications to Apex.

S.i. SystemsOttawa
CA$32.00–CA$37.00 hourly
Our Valued Public Sector Client is seeking an.Bilingual (French / English) Oracle Apex Developer to create Oracle PL / SQL stored procedures and complete a migration of form6i applications to Apex.Migr...Show moreLast updated: 30+ days ago
(Remote) Senior Software Engineer

(Remote) Senior Software Engineer

Systems & Software, Inc.Ontario, Canada
CA$125,000.00–CA$135,000.00 yearly
Remote
Full-time
Senior Software Engineer (Billing and Accounting).Join Harris' Systems & Software, a pioneering force in the Utility CIS arena, as a Senior Software Engineer. Our focus is on developing business app...Show moreLast updated: 30+ days ago
  • Promoted
Senior Programmer Analyst

Senior Programmer Analyst

ADGA Group Consultants IncOttawa, Ontario, Canada
Must develop test and implement program code object segments in accordance with the clients design conventions.Gather and analyze data by monitoring application performance.The performance data wil...Show moreLast updated: 19 days ago
Programmer / Analyst - Data Solution

Programmer / Analyst - Data Solution

Hydro OttawaOttawa, ON
CA$70,146.95–CA$105,220.44 yearly
Full-time
Please Note : If you are a current Hydro Ottawa employee with access to Workday, apply to this job via the Workday application. At Hydro Ottawa, we empower the lives of the people in the communities ...Show moreLast updated: 30+ days ago
Curam Software Specialist

Curam Software Specialist

49 SolutionsOttawa, ON, CA
Quick Apply
Solutions is on the lookout for a Senior Curam Software Specialist to for our client at Employment and Social Development Canada (ESDC), you will work closely with clients to design, develop, and i...Show moreLast updated: 30+ days ago
Findur Developer

Findur Developer

BrainhunterOttawa, Ontario
CA$65,000.00–CA$85,000.00 yearly
Findur / Endur Developer (#61769).Mindwire Systems is seeking the services of a Findur / Endur Developer for one of our Valued Clients. Working Environment : Remote (Must reside in Canada).Requirements a...Show moreLast updated: 30+ days ago
  • Promoted
  • New!
Epic Cogito BI Developer

Epic Cogito BI Developer

Quantum Technology Recruiting Inc. (QTR)Ottawa, ON, Canada
Full-time
Job Title : Epic Cogito BI Developer.We are seeking a highly skilled and experienced programming analyst or BI developer with expertise in Epic Cogito!. Develop, maintain, and optimize Cogito reports...Show moreLast updated: 14 hours ago
  • New!
Databricks ETL Developer / Data Engineer

Databricks ETL Developer / Data Engineer

Cleo ConsultingON, Canada
Full-time
Quick Apply
Assignment : RQ08659 - Software Developer - ETL - Senior Job Title : Databricks ETL Developer / Data Engineer Requi...Show moreLast updated: 19 hours ago
  • Promoted
Full Stack Developer

Full Stack Developer

Mindwire Systems LtdOttawa, ON, Canada
Full-time
Mindwire Systems is seeking the services of a.Requirements and Qualifications : .Full Stack Developer with five (5) years experience : . Data intensive web applications.To apply for this and other suita...Show moreLast updated: 4 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
Java Developer

Java Developer

StafflinkOttawa, ON
CA$65,000.00–CA$75,000.00 yearly
Hold or eligible for reliability clearance.Under the direction of the Assistant Director : .Support large and small project initiatives, including bug fixes. Develop and maintain Java full stack appli...Show moreLast updated: 30+ days ago
Specialized IT Consultant – Senior

Specialized IT Consultant – Senior

2iResourcingON, Canada
3 days 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