Sr. Software Developer (Oracle, SQL, Unix / Linux, Java, HL7 / FHIR)
5700 Yonge Street, Toronto (Yonge Street & Finch Avenue, close to Finch Subway Station)
Hybrid (3 days onsite, 2 days remote)
Contract (9 months)
Must-Haves :
15+ years of experience with :
- 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.
- Demonstrated ability to create normalized database schemas utilizing data modeling discipline.
- Understanding of normalization, de-normalization, and the difference between the two. Ability to create schemas for both OLTP and OLAP databases.
- Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
- Data Warehouse design and development, Database performance tuning, Automation
- Unix / Linux Shell Scripting
- 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
- Knowledge of Java, JSON, XML, API calls, HL7 / FHIR, Restful web services '