Themesoft Inc.

Position
: OFSAA Data Integrator
Location
: Toronto – Hybrid
Skills
:
<ol>
<li>Strong hands-on experience in Oracle SQL and PL/SQL, with demonstrated ability to develop and troubleshoot complex database programs.
</li>
<li>Practical PL/SQL development experience within an OFSAA application environment.
</li>
<li>Proficiency in Unix/Linux shell scripting for batch automation and operational support.
</li>
<li>Experience with high-volume data processing, performance tuning, data validation, and reconciliation.
</li>
</ol>
Job Description/ Responsibilities
<ol>
<li>Design, develop, optimize, and support complex SQL and PL/SQL components for OFSAA data integration and processing.
</li>
<li>Develop and maintain packages, procedures, functions, triggers, and data-processing routines within the OFSAA ecosystem.
</li>
<li>Build, configure, and support data integration workflows using OFSAA Data Integration Hub (DIH).
</li>
<li>Perform data sourcing from upstream systems, including source analysis, source-to-target mapping, transformation logic, and interface design.
</li>
<li>Develop and maintain Unix/Linux shell scripts for file handling, batch processing, scheduling, monitoring, and automation.
</li>
<li>Support data ingestion, staging, transformation, reconciliation, and loading into OFSAA data models.
</li>
<li>Analyze and resolve data-quality issues, load failures, performance bottlenecks, and production incidents.
</li>
<li>Optimize SQL queries and PL/SQL programs to improve batch performance and processing efficiency.
</li>
<li>Collaborate with business analysts, functional teams, upstream application teams, and infrastructure teams to clarify requirements and resolve integration dependencies.
</li>
<li>Prepare and maintain technical design documents, mapping specifications, deployment instructions, operational procedures, and support documentation.
</li>
<li>Participate in unit testing, system integration testing, defect resolution, release implementation, and post-production validation.
</li>
<li>Follow established coding, version-control, deployment, security, and data-governance standards
</li>
</ol>
Regards
Patrick Fernandez
Talent Acquisition Group - Strategic Recruitment Manager

OFSAA Data Integrator

OFSAA Data Integrator

This job is no longer available

Talents

Recruiters

About