Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 1 month ago
OT
Network Engineer III
Opti9 Technologies
Remote, Canada
- $115,000 to $145,000 CAD / year
- Full-time
- Remote
Added 1 month ago
S
Regional Sales Manager
SSAB
Montreal, QC
- Full-time
Experience in drawings, working with templates, and basic understanding and interest of CAD and nesting software
Added 1 month ago
W
Staff Vehicle Program Manager
Waabi
Toronto, ON
- Full-time
Breadth across actuation and autonomy system integration (sensors, compute, embedded, and software) and the judgment to weigh trade-offs between them.
Added 1 month ago
Concepteur(trice) mécanique senior / Senior Mechanical Designer
Primero Group
Quebec, QC
Added 1 month ago
F
Documentation & Enablement Specialist
FISPAN
Vancouver, BC
- Full-time
Added 1 month ago
SC
Team Manager - Application Development
Staples Canada
Richmond Hill, ON
- Full-time
Post-secondary education in Computer Science or equivalent working experience in software development.
Added 1 month ago
C++ Software Engineer Intern (UFC - Vancouver - Summer 2027 - 8-months)
Electronic Arts
Vancouver, BC
We're looking for a C++ Software Engineer Intern to join our UFC team for an 8-month internship beginning in May 2027. Reporting to a Senior Software Engineer and paired with an engineering…
Added 1 month ago
C++ Generalist Software Engineer Co-op (FC - Vancouver - Summer 2027 - 8-Months - Undergrad)
Electronic Arts
Vancouver, BC
We are considering hybrid (3-days per week) and onsite flexible work options
Added 1 month ago
S
SQL Developer
SMARTFOX
Canada
- Full-time
SQL Developer I - 0-2 years : Queries, reports, and well-scoped database changes, learning our data model with a dedicated mentor and code review
Added 1 month ago
A
Machine Learning Operations Developer, AI/ML Platfor
Autodesk
Montreal, QC
- Full-time
Autodesk, a global leader in 3D design, engineering, manufacturing, and entertainment software, is seeking an MLOps Developer to join our AI/ML Platform team. This role will contribute to…
Added 1 month ago
AL
Civil Engineer (Geotechnical)
AGAT Laboratories
Calgary, AB
- Full-time
Familiarity with geotechnical lab software and quality control systems
Added 1 month ago
OH
Bilingual Care Coordinator, Temporary Full-Time, Congregate Care Team East, Labelle
Ontario Health atHome
Ottawa, ON
- Full-time
Added 1 month ago
C
Senior Specialist Engineer Bridge Design
CN
AB · Edmonton, AB
- Full-time
Use CADD software, Microsoft Office Software, and structural analysis software to necessary to complete designs and design checks
Added 1 month ago
A
Machine Learning Operations Developer, AI/ML Platfor
Autodesk
Toronto, ON
- Full-time
Autodesk, a global leader in 3D design, engineering, manufacturing, and entertainment software, is seeking an MLOps Developer to join our AI/ML Platform team. This role will contribute to…
Added 1 month ago
G
PL/SQL - OFSAA Data Integrator
Galent
Toronto, ON
- Contract
Added 1 month ago
AT
Senior Python Developer
Altis Technology
Toronto, ON · Greater Toronto Area, Canada
- $135,000 to $155,000 CAD / year
- Full-time
We are assisting our reputable client in the geoscience industry with the search for a Senior Back End Developer (C++/Python).
Added 1 month ago
SF
Fund Accountant (BC)
SGGG Fund Services Inc.
Richmond, BC
- Full-time
…administration. Using Diamond, our proprietary fund administration software, SGGG-FSI’s over 400 employees provide full-service fund administration to clients from our headquarters in…
Added 1 month ago
RE
Operations Assistant
Roe Environmental
North Vancouver, BC
- Other
Proficiency with standard office software (e.g., Excel, Word, Outlook) and comfort learning new digital tools.
Added 1 month ago
CL
Resident Experience Manager - CLC
Campus Living Centres
Hamilton, ON
- Full-time
Travel Outside of Location: Must hold a valid driver’s license and be willing to travel across the
Added 1 month ago
AI
Automation Engineer- CMDB/Asset Management, Python, REST APIs
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Calgary, AB
- Full-time
Onsite - 5 days in office (8:00 AM – 05:00 PM MST) · Top 3 Must Have Skills:
Added 1 month ago
Beauty Advisor - Seasonal PT - the Cosmetics Company Store - Vancouver, BC
ELC Beauty LLC
Vancouver, BC
Previous experience with retail point-of-sale software
Added 1 month ago
EB
Seasonal Beauty Advisor - Estée Lauder Companies (NB) - Part Time - Company Store - Winnipeg, MB
ELC Beauty LLC
Winnipeg, MB
- Part-time
Previous experience with retail point-of-sale software
Added 1 month ago
Beauty Advisor - Seasonal PT - The Cosmetic Company Store - Premium Outlet - Edmonton, AB
ELC Beauty LLC
AB · Edmonton, AB
Previous experience with retail point-of-sale software
Added 1 month ago
Social Worker Bachelors (Crisis Intervention)
Health Sciences North
ON · Sudbury, ON
16. Demonstrated excellent computer skills with proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and patient information systems.
Added 1 month ago
Social Worker Bachelors (Crisis Intervention)
Health Sciences North
ON · Sudbury, ON
16. Demonstrated excellent computer skills with proficiency in Microsoft Office software (e.g. Word, Excel, Power Point and Outlook) and patient information systems.

Galent

PL/SQL - OFSAA Data Integrator

Toronto, ON, Canada

Contract

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type: Contract
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 on LinkedIn 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

Work requirements

Jobs in Canada