OFSAA Data Integration Specialist

Toronto, ON
Hybrid
Posted Oct 13, 2026
1 position

Opens LinkedIn

Employment type: Contract
Experience level: Senior · 8+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Design, develop, optimize, and support SQL and PL/SQL components, OFSAA Data Integration Hub workflows, and Unix/Linux scripts for data ingestion, transformation, reconciliation, and batch processing. Resolve data-quality and production issues, improve performance, collaborate across technical and business teams, and support testing, releases, and technical documentation.

Job details

Role: OFSAA Data Integration Specialist Location: Toronto ( Hybrid) Mode: Contract Experience: 8+yrs Required Skills: 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. 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. Follow 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. Regards Praveen Kumar Talent Acquisition Group – Strategic Recruitment Manager praveen.r@themesoft.com| Themesoft Inc

What you’ll do

Requirements

Requires 8+ years of experience, strong hands-on Oracle SQL and PL/SQL skills, and practical PL/SQL development experience in an OFSAA environment. Candidates should also have Unix/Linux shell scripting experience and familiarity with high-volume data processing, performance tuning, validation, and reconciliation; OFSAA DIH experience is noted as a plus.