OFSAA Data Integration Specialist

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