OFSAA Data Integrator

Job summary

Design, develop, optimize, and support OFSAA data integration components, including SQL and PL/SQL programs, DIH workflows, and Unix/Linux batch automation. Manage data sourcing, ingestion, transformation, reconciliation, testing, deployment, documentation, and resolution of data-quality or production issues.

Job details

Position: OFSAA Data Integrator Location: Toronto – Hybrid Skills: 1. Strong hands-on experience in Oracle SQL and PL/SQL, with demonstrated ability to develop and troubleshoot complex database programs. 2. Practical PL/SQL development experience within an OFSAA application environment. 3. Proficiency in Unix/Linux shell scripting for batch automation and operational support. 4. Experience with high-volume data processing, performance tuning, data validation, and reconciliation. Job Description/ Responsibilities 1. Design, develop, optimize, 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. Optimize 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 Regards Patrick Fernandez Talent Acquisition Group - Strategic Recruitment Manager

What you’ll do

Design, develop, optimize, and support OFSAA data integration components, including SQL and PL/SQL programs, DIH workflows, and Unix/Linux batch automation. Manage data sourcing, ingestion, transformation, reconciliation, testing, deployment, documentation, and resolution of data-quality or production issues.

Requirements

Requires hands-on Oracle SQL and PL/SQL development, including practical experience in an OFSAA environment, along with Unix/Linux shell scripting skills. Candidates should have experience with high-volume data processing, performance tuning, data validation, and reconciliation.

Listed skills

• Data Validation · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Oracle SQL
• PL/SQL
• OFSAA
• OFSAA Data Integration Hub
• Unix/Linux Shell Scripting
• Data Integration
• Data Mapping
• Data Transformation
• Data Validation
• Data Reconciliation
• High-Volume Data Processing
• Performance Tuning
• Batch Processing
• Production Support
• Unit Testing
• System Integration Testing

Job areas

• Technology
• Data & Analytics
• Software

More jobs from Themesoft Inc.