Senior Oracle PL/SQL Developer – OLAP/OLTP & Data Warehouse

Russell Tobin

Toronto

On-site

CAD 110,000 - 117,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Russell Tobin & Associates is hiring on behalf of a public sector client for a Senior Oracle PL/SQL Developer in Toronto, Ontario. The contract runs for 305 business days with a possible extension and pays CAD 80–85 per hour.

The role requires extensive Oracle 12c OLAP/OLTP design and development, PL/SQL development, data warehouse design, and advanced SQL. You will work with business analysts to translate requirements into robust IT solutions and leverage Informatica and Cognos for ETL and

Qualifications

  • Design and development of Oracle 12c for OLAP/OLTP with PL/SQL, stored procedures, packages, functions and triggers.
  • Advanced SQL, data architecture, and data modeling for OLTP/OLAP databases.
  • Data Warehouse design, performance tuning, and automation.
  • Collaborate with business analysts to translate requirements into designs for business/IT needs.
  • Experience with Informatica for ETL and Cognos reporting tools (Query Studio/Reports Studio).
  • Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services.

Skills

Oracle PL/SQL
Advanced SQL
Data Warehouse design
Business analyst collaboration
SDLC / DevOps
Public sector/domain knowledge
System architecture
Leadership / mentoring
CI/CD
Web services/API (HL7/FHIR)

Tools

Informatica
Cognos (Framework Manager/Query Studio/Reports Studio)
Crystal Reports
Business Objects
Java
JSON / XML / REST

Job description

Russell Tobin & Associates is hiring on behalf of a public sector client for a Senior Oracle PL/SQL Developer in Toronto, Ontario. The contract runs for 305 business days with a possible extension and pays CAD 80–85 per hour.

The role requires extensive Oracle 12c OLAP/OLTP design and development, PL/SQL development, data warehouse design, and advanced SQL. You will work with business analysts to translate requirements into robust IT solutions and leverage Informatica and Cognos for ETL and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Software Developer - Senior (Oracle/OLAP and OLTP)
Software Developer - Senior (Oracle/OLAP and OLTP)

Bevertec • Toronto

On-site
CAD 117,000 - 124,000
Senior Oracle Database Developer
Senior Oracle Database Developer

Bevertec • Toronto

On-site
CAD 124,000 - 138,000
Senior Oracle PL/SQL Developer
Senior Oracle PL/SQL Developer

Russell Tobin • Toronto

On-site
CAD 110,000 - 117,000
CLDRSRC10457 - Oracle Developer/Consultant - Toronto
CLDRSRC10457 - Oracle Developer/Consultant - Toronto

Indotronix UK • Toronto

On-site
CAD 90,000 - 130,000
Senior PL/SQL, Cognos & Informatica Engineer (Hybrid)
Senior PL/SQL, Cognos & Informatica Engineer (Hybrid)

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
RQ08204 - Sr. Software Developer
RQ08204 - Sr. Software Developer

Rubicon Path • Toronto

Hybrid
CAD 90,000 - 120,000
Senior Oracle/MS SQL Database Developer – DW/ETL
Senior Oracle/MS SQL Database Developer – DW/ETL

Scotiabank • Toronto

On-site
CAD 80,000 - 100,000
Competitive Rewards program
Online courses and tuition assistance
Flexible vacation and personal days
+1
Senior Oracle PL/SQL Developer – Healthcare Data & Integration
Senior Oracle PL/SQL Developer – Healthcare Data & Integration

ThoughtStorm • Toronto

On-site
CAD 90,000 - 130,000
Senior SQL/Oracle DBA - Onsite Toronto (Contract)
Senior SQL/Oracle DBA - Onsite Toronto (Contract)

Bevertec • Toronto

On-site
CAD 110,208 - 117,096
Senior Cognos Developer | Power BI & Large-Scale Data
Senior Cognos Developer | Power BI & Large-Scale Data

Source Code • Toronto

On-site
CAD 110,000 - 160,000