Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 hour ago
LC
Pharmacist - CPS
Loblaw Companies Limited
Moncton, NB
- Full-time
Reporting to the Supervisor, Production, the Pharmacist will support the overall operations of the Pharmacy, including providing communication to client pharmacies and coordinating with…
Added 1 hour ago
CI
Material Handler
Calian in Space & Technology
Saskatoon, SK
- Full-time
…inspect goods and accurately select and prepare components for production. You will fulfill manufacturing floor requirements, pick production orders, and update our electronic inventory…
Added 1 hour ago
LC
Supervisor, Production
Loblaw Companies Limited
Burnaby, BC
- Full-time
The Supervisor Production will assist the Pharmacy Operations Management Team in overseeing the day-to-day workflow process of their team within Operations and to ensure optimal customer…
Added 1 hour ago
IE
Manager, Supply Chain & Innovation
IMAX Enhanced | Streaming & Consumer Technology
Mississauga, ON
- Full-time
Supply Chain Analytics and Decision Support: Develop and standardize KPI’s, performance measures and analytical approaches that provide leadership with meaningful insight into Supply Chain…
Added 1 hour ago
LD
Staff Data Engineer
Loblaw Digital
Toronto, ON
- Full-time
Design and maintain data models that support analytics, reporting, experimentation, and measurement at scale.
Added 1 hour ago
LD
Creative Production Specialist (14 Month contract)
Loblaw Digital
Toronto, ON
- Full-time
Role Overview: The Creative Production Specialist is responsible for ensuring brand consistency across all campaigns and assets, meticulously managing digital assets, and maintaining…
Added 1 hour ago
P
Pharmacien(ne), rémunéré(e) à l’heure – PHX temps partiel Quarts de travail flexibles
Pharmaprix
Repentigny, QC
- Part-time
Participer à la production de rapports financiers, le cas échéant.
Added 1 hour ago
LC
Supervisor, Production
Loblaw Companies Limited
Richmond Hill, ON
- Full-time
The Supervisor Production will assist the Pharmacy Operations Management Team in overseeing the day-to-day workflow process of their team within Operations and to ensure optimal customer…
Added 1 hour ago
LD
Director, Software Engineering
Loblaw Digital
Toronto, ON
- Full-time
…growing team, to hold high standards in operation excellence and production…
Added 1 hour ago
NF
Pharmacy Technician Registered Full Time Day
No Frills
Fort Erie, ON
- Full-time
The role of the pharmacy technician is to aid the pharmacy in the production of prescriptions and provide optimal customer service. Participate actively in growing prescription and OTC…
Added 1 hour ago
P
Pharmacien(ne), rémunéré(e) à l’heure – PHX temps partiel Quarts de travail flexibles
Pharmaprix
Boucherville, QC
- Part-time
Participer à la production de rapports financiers, le cas échéant.
Added 1 hour ago
P
Pharmacien(ne), rémunéré(e) à l’heure – PHX temps plein Quarts de travail flexibles
Pharmaprix
Boucherville, QC
- Full-time
Participer à la production de rapports financiers, le cas échéant.
Added 1 hour ago
P
Pharmacien(ne), rémunéré(e) à l’heure – PHX temps plein Quarts de travail flexibles
Pharmaprix
Repentigny, QC
- Full-time
Participer à la production de rapports financiers, le cas échéant.
Added 1 hour ago
P
Pharmacien(ne), rémunéré(e) à l’heure – PHX temps plein jour
Pharmaprix
Montreal, QC · Pierrefonds, QC
- Full-time
Participer à la production de rapports financiers, le cas échéant.
Added 1 hour ago
LA
Manager, Agency Operations
Loblaw Agency
Toronto, ON
- Full-time
The Manager, Agency Operations will report to the Sr. Manager, Agency Operations and support our Shoppers Drug Mart brand portfolio.
Added 1 hour ago
SD
Director, Virtual Care Technology Applications
Shoppers Drug Mart Specialty Health Network
Toronto, ON
- Full-time
Partner with operations teams to improve application stability, resiliency, supportability, monitoring, incident response, and production performance.
Added 1 hour ago
LD
Director, Software Engineering
Loblaw Digital
Toronto, ON
- Full-time
…growing team, to hold high standards in operation excellence and production…
Added 1 hour ago
MP
Team Lead Pharmacist
MediSystem Pharmacy
Ottawa, ON
- Full-time
Establish/coordinate monthly and weekly production schedules and daily assignments of staff
Added 1 hour ago
UA
Automation Technician
UpScale Automation Inc.
Windsor, ON
- Full-time
…controls design, PLC programming, and on-site commissioning and production support. Our work spans a wide range of machine types and industries, which means every project brings something…
Added 1 hour ago
SD
Registered Pharmacy Technician - 15 Month Contract
Shoppers Drug Mart Specialty Health Network
Mississauga, ON
- Full-time
a thorough knowledge of Pharmacy Practices. The Registered Pharmacy Technician will be called upon to support
Added 1 hour ago
SD
Pharmacy Assistant
Shoppers Drug Mart Specialty Health Network
Mississauga, ON
- Full-time
Added 1 hour ago
LA
Freelance Content Creator Roster | Loblaw Agency Social Team
Loblaw Agency
Toronto, ON
- Part-time
As part of our freelance roster, you may be tapped to support different brands, briefs and cultural moments across the Loblaw enterprise, from planned content and recurring social formats…
Added 3 hours ago
SP
Warehouse Associate
SmartShield Packaging
Cambridge, ON
- Full-time
…receiving, organizing, and preparing materials and finished goods to support production and customer orders. Working closely with the production, procurement, and logistics teams, you’ll…
Added 3 hours ago
SP
Foam Production Associate
SmartShield Packaging
Cambridge, ON
- Full-time
Job Title: Foam Production Associate (Afternoon Shift)
Added 4 hours ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Under the direction of the designated IT Manager, the Application and Integration Technical Analyst is a technical lead responsible for system architecture, data strategy, and integration…

Galent

PL/SQL - OFSAA Data Integrator

Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 8, 2026
Posting language: English
Posted: Oct 9, 2026

Original job description

Role : PL/SQL - OFSAA Data Integrator

Location : Toronto, ON (Hybrid)

Top skills required for this role:

Strong hands-on experience in Oracle SQL and PL/SQL, with demonstrated ability to develop and troubleshoot complex database programs.
Practical PL/SQL development experience within an OFSAA application environment.
Proficiency in Unix/Linux shell scripting for batch automation and operational support.
Experience with high-volume data processing, performance tuning, data validation, and reconciliation.

Job Description/ Responsibilities

Design, develop, optimize, and support complex SQL and PL/SQL components for OFSAA data integration and processing.
Develop and maintain packages, procedures, functions, triggers, and data-processing routines within the OFSAA ecosystem.
Build, configure, and support data integration workflows using OFSAA Data Integration Hub (DIH).
Perform data sourcing from upstream systems, including source analysis, source-to-target mapping, transformation logic, and interface design.
Develop and maintain Unix/Linux shell scripts for file handling, batch processing, scheduling, monitoring, and automation.
Support data ingestion, staging, transformation, reconciliation, and loading into OFSAA data models.
Analyze and resolve data-quality issues, load failures, performance bottlenecks, and production incidents.
Optimize SQL queries and PL/SQL programs to improve batch performance and processing efficiency.
Collaborate with business analysts, functional teams, upstream application teams, and infrastructure teams to clarify requirements and resolve integration dependencies.
Prepare and maintain technical design documents, mapping specifications, deployment instructions, operational procedures, and support documentation.
Participate in unit testing, system integration testing, defect resolution, release implementation, and post-production validation.
1Follow established coding, version-control, deployment, security, and data-governance standards

Nice to have:

Hands-on experience with OFSAA Data Integration Hub (DIH), data sourcing, and integration processes.
Good knowledge of OFSAA data flows, staging areas, data models, batch execution, and processing frameworks.
Years of Experience More than 7 years of experience. The ideal candidate should have deep PL/SQL expertise, effective shell-scripting skills, and the ability to independently manage DIH and data-sourcing activities. The candidate should be comfortable working with multiple stakeholders, handling complex datasets, and supporting business-critical batch and production processes.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law. https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf

Apply About employer

More about this job

Responsibilities

Design, develop, optimize, and support SQL and PL/SQL components and OFSAA DIH workflows for data sourcing, transformation, staging, reconciliation, and loading. Maintain shell-scripted batch operations, resolve data and production issues, collaborate with stakeholders, and support testing, releases, documentation, and operational standards.

Requirements

More than seven years of experience is required, with strong hands-on Oracle SQL and PL/SQL expertise, including development in an OFSAA environment. Candidates should also have Unix/Linux shell-scripting skills and experience with high-volume data processing, performance tuning, validation, reconciliation, and preferably OFSAA DIH and data-sourcing processes.

Skills

Oracle SQL
PL/SQL
OFSAA
OFSAA Data Integration Hub (DIH)
Unix/Linux Shell Scripting
Data Integration
Data Sourcing
Source-to-Target Mapping
Data Transformation
High-Volume Data Processing
SQL Performance Tuning
Data Validation
Data Reconciliation
Batch Automation
Production Support
Data Quality

Visa sponsorship

Not detected in the job text

Keywords

Oracle SQL
PL/SQL
OFSAA
OFSAA Data Integration Hub (DIH)
Unix/Linux
Shell Scripting
Data Integration
Data Sourcing
Source-to-Target Mapping
Transformation Logic
Interface Design
High-Volume Data Processing
Performance Tuning
Data Validation
Data Reconciliation
Data Quality
Batch Processing
Batch Automation
Data Ingestion
Staging Areas
OFSAA Data Models
Production Support
Unit Testing
System Integration Testing
Version Control
Data Governance
Technical Documentation
Toronto

Report this job