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