Posted 2 days ago
Senior Oracle PL/SQL Developer – Healthcare Data & Integration
@ ThoughtStorm
Toronto, Ontario
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
| Seniority | Senior |
| Department | Software development |
| Experience | 10+ years |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
Summary and details written by AI from the posting; the employer’s posting is the authority.
ThoughtStorm
| Field | Value |
|---|---|
| Open jobs on Jobsy | 34 |
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
Journal
Only you can see this. Kept on this device, and in your account when you sign in.