Position: OFSAA Data Integrator
Location: Toronto – Hybrid
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.
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.
- Follow established coding, version-control, deployment, security, and data-governance standards
Regards
Patrick Fernandez
Talent Acquisition Group - Strategic Recruitment Manager
