Apply now

Posted 2 days ago

Senior Oracle PL/SQL Developer – Healthcare Data & Integration

@ ThoughtStorm

Toronto, Ontario

Contract10+ years experience
Apply now
SIGNALS

Overview

ThoughtStorm is hiring a Senior Oracle PL/SQL Developer on a long-term contract running December 2026 to March 2028. The role centres on Oracle database development, data warehouse design and ETL with Informatica, Cognos reporting, and healthcare integration (HL7/FHIR, provincial immunization systems). Experience with Oracle 12c, query tuning and Agile delivery is required.

Responsibilities:

  • Develop and tune Oracle PL/SQL code and database objects
  • Design and build data warehouse and ETL solutions
  • Build Cognos reports and integrations via REST APIs and web services
  • Translate business requirements into technical designs

Requirements summary:

  • 10+ years Oracle database development
  • Advanced SQL and query optimization expertise
  • Informatica ETL and Cognos reporting experience
  • Healthcare IT and HL7/FHIR experience highly desirable

Tools & skills

Source and dates

Source type not verified · apify-linkedin

Employer posting date
2026-11-12
First seen by our source
2026-11-14
Source record updated
2026-11-14

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentSoftware development
Experience10+ years
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high

Summary and details written by AI from the posting; the employer’s posting is the authority.

ThoughtStorm

FieldValue
Open jobs on Jobsy34
Job description

We are hiring a Senior Oracle PL/SQL Developer for a long-term opportunity.

  • 10+ years of experience in Oracle database development, particularly Oracle 12c, PL/SQL, Stored Procedures, Packages, Functions, Triggers, Ref Cursors and Dynamic SQL.
  • Strong expertise in Advanced SQL, Query Optimization, Database Design, Data Modeling, and OLTP/OLAP applications.
  • Hands-on experience in Data Warehouse Design & Development, Database Performance Tuning, and Automation.
  • Strong experience with Informatica ETL, data extraction, transformation, and loading.
  • Experience with Cognos Reporting, Framework Manager, Query Studio, and Reports Studio.
  • Knowledge of Unix/Linux Shell Scripting, Java, JSON, XML, REST APIs, and Web Services.
  • Experience in Healthcare IT, Clinical Systems Integration, HL7/FHIR, and Provincial Immunization Systems is highly desirable.
  • Strong understanding of SDLC, Agile methodologies, DevOps, Continuous Integration, and technical documentation.
  • Ability to translate business requirements into technical designs and deliver solutions for complex, mission-critical applications.

Contract: December 2026 – March 2028

Similar jobs

  • Spécialiste, Marchandisage – Commerce électronique

    Toronto, ON
    Full Time

    The Home Depot Canada

    1+ YOESi, en plus de cela, vous êtes de nature curieuse et souhaitez acquérir de nouvelles connaissances, envisagez de commencer ou de faire progresser votre carrière chez Home Depot; Support marketing submissions including…

    Merchandising, Electronics, Data management, SAP, Onboarding, Accounts payable

    MERCHANDISING SPECIALIST ONLINE

    Toronto, ON
    Full Time

    The Home Depot Canada

    1+ YOESupport marketing submissions including compliance with market/provincial promo requirements; Participate, as required, in strategic projects and innovation efforts to drive department growth and efficiency via data…

    Merchandising, Data management, SAP, Onboarding, Accounts payable, Pricing strategies

  • Senior Cybersecurity Specialist

    Toronto, ON
    Full Time

    Legislative Assembly of Ontario / Assemblée législative de l’Ontario

    5+ YOECandidates need 5 to 10 years of progressive cybersecurity experience, including vulnerability assessment, penetration testing, incident response and cloud security. A university degree in IT or cybersecurity and a CISSP or systems administrator qualification are also required.

    Visitor Representative

    Toronto, ON
    Full Time

    Legislative Assembly of Ontario / Assemblée législative de l’Ontario

    Candidates need fluent written and spoken English, significant customer service experience and strong public speaking and interpersonal skills. Knowledge of the Ontario Legislature and government, plus computer and office software skills, is required. French and other languages are an asset.

    Office software applications

    Designer (Interior)

    Toronto, ON
    Full Time

    Legislative Assembly of Ontario / Assemblée législative de l’Ontario

    3+ YOECandidates need a diploma or degree in interior design or equivalent and at least three years of related experience, preferably in heritage buildings. Strong AutoCAD, drafting, project management and communication skills are required.

    AutoCAD, SketchUp, Microsoft Office, Microsoft Project

  • Applications Engineer - Project Management

    Toronto, ON
    Full Time

    Vishay Precision Group, Inc. (VPG)

    3+ YOECandidates need a background in electrical, electronics or mechatronics engineering or an equivalent technologist diploma, with 3 to 7 years in industrial environments. Strong hands-on skills with PLCs, sensors, industrial networks and project tools are required, along with a valid G-class driver's license and the ability to travel internationally.

    AutoCAD, SolidWorks, MS Project, ERP, PDM, PLC

  • Building Supervisor

    Toronto, ON
    Part Time

    Soulpepper Theatre Company

    Candidates need an entry-level ability to supervise building operations, plus willingness to do light custodial work, lift and move furniture, and work at heights when needed. Safety training such as WHMIS and first aid is expected, and courtesy with staff and the public is required.

    dollies

  • Canadian Public Sector Engagement Delivery Leader

    Toronto, ON
    Full Time

    Salesforce Partner Canada

    10+ YOECandidates need 10+ years of project and program management in consulting, including 7+ years managing Salesforce engagements preferred and public sector experience. Strong leadership, client communication, budget management (at least $15M) and the ability to lead teams of up to 75+ people are required.

    Salesforce

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.