OFSAA Data Integrator
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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
More about this job
Responsibilities
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.
Skills
- 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
Visa sponsorship
Not detected in the job text
Hiring contact
Patrick Fernandez
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Oracle SQL
- PL/SQL
- OFSAA
- Data Integration Hub
- DIH
- Unix
- Linux
- Shell Scripting
- Data Integration
- Data Sourcing
- Source-to-Target Mapping
- Transformation Logic
- Interface Design
- Batch Automation
- Data Ingestion
- Data Staging
- Data Reconciliation
- Data Validation
- Data Quality
- High-Volume Data Processing
- Performance Tuning
- Production Support
- Unit Testing
- System Integration Testing
- Version Control
- Data Governance