Software Developer - Senior (Oracle/OLAP and OLTP)
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Job Role: Software Developer - Senior (Oracle (12c)/OLAP and OLTP)
Location : Toronto, ON/Onsite
Position Type : Contract Role
Start Date
2026-12-14
End Date
2028-03-07
5 Days Onsite
Ideal Candidate Rate: CAD 85-90 (Depending on the experience)
Must Have:
- Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
- Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
- Data Warehouse design and development, Database performance tuning, Automation
- Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
- Informatica for data extraction, transformation, and loading, initial setup and other data management purposes
- Cognos report design and development, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc. Other reporting tools would also be an asset, particularly Crystal Reports and Business Objects
Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.
More about this job
Responsibilities
Design and develop Oracle 12c OLAP and OLTP applications, including database objects, optimized queries, data warehouses, and automated processes. Translate business requirements into application designs and develop data integration and reporting solutions using Informatica and Cognos.
Requirements
The role requires strong Oracle 12c development experience, including PL/SQL, stored procedures, packages, functions, triggers, ref cursors, dynamic SQL, and DBMS packages. Candidates should also have advanced SQL, data architecture and modeling, data warehouse development, performance tuning, Informatica ETL, and Cognos reporting experience.
Skills
- Oracle 12c
- PL/SQL
- Advanced SQL
- Stored Procedures
- Database Design
- Data Modeling
- Data Warehouse Design
- Database Performance Tuning
- Informatica
- ETL
- Cognos
- Report Development
- Dashboard Creation
- Business Requirements Analysis
- Automation
Visa sponsorship
Not detected in the job text
Categories
- Software
- Technology
- Data & Analytics
Keywords
- Oracle 12c
- OLAP
- OLTP
- PL/SQL
- Stored Procedures
- Packages
- Functions
- Triggers
- Ref Cursors
- Dynamic SQL
- DBMS Packages
- Advanced SQL
- Query Optimization
- Data Architecture
- Database Design
- Data Modeling
- Data Warehousing
- Performance Tuning
- Automation
- Business Requirements
- Application Design
- Informatica
- ETL
- Cognos
- Framework Manager
- Query Studio
- Reports Studio
- Dashboards
- Crystal Reports
- Business Objects