PL/SQL - OFSAA Data Integrator (Intermediate-Senior)

- Toronto - Hybrid
C$60-68

What are the top 3 skills required for this role?

- Robust 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
1. Design, develop, Eligible to workimize, and support complex SQL and PL/SQL components for OFSAA data integration and processing.
2. Develop and maintain packages, procedures, functions, triggers, and data-processing routines within the OFSAA ecosystem.
3. Build, configure, and support data integration workflows using OFSAA Data Integration Hub (DIH).
4. Perform data sourcing from upstream systems, including source analysis, source-to-target mapping, transformation logic, and interface design.
5. Develop and maintain Unix/Linux shell scripts for file handling, batch processing, scheduling, monitoring, and automation.
6. Support data ingestion, staging, transformation, reconciliation, and loading into OFSAA data models.
7. Analyze and resolve data-quality issues, load failures, performance bottlenecks, and production incidents.
8. Eligible to workimize SQL queries and PL/SQL programs to improve batch performance and processing efficiency.
9. Collaborate with business analysts, functional teams, upstream application teams, and infrastructure teams to clarify requirements and resolve integration dependencies.
10.



Prepare and maintain technical design documents, mapping specifications, deployment instructions, operational procedures, and support documentation.
11. Participate in unit testing, system integration testing, defect resolution, release implementation, and post-production validation.
12. Follow established coding, version-control, deployment, security, and data-governance standards

Additional Information:
Team size, direct reports, key deliverables, unique selling points, additional qualifications, team culture etc.
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 Consultantly 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.

Disclaimer: Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may at any time.
Security Notice: Our official website is We do not operate or authorize any other websites representing Diverse Lynx LLC.

📌 PL/SQL - OFSAA Data Integrator (Toronto)
🏢 Diverse Lynx
📍 Toronto