Enable job alerts via email!

Software Developer 8560-3009

Foilcon

Toronto

Hybrid

CAD 50,000 - 70,000

Full time

30+ days ago

Generate a tailored resume in minutes

Land an interview and earn more. Learn more

Job summary

A leading company in IT Services and Consulting is seeking a Software Developer to work on innovative solutions in public sector healthcare. This role requires extensive experience in Oracle, SQL, and UI design, focusing on developing and maintaining sophisticated applications. The successful candidate will work on a hybrid schedule, contributing to impactful projects that improve healthcare delivery systems across Ontario.

Qualifications

10+ years of experience in Oracle development for OLAP and OLTP applications.
Demonstrated advanced SQL skills and database design experience.
Strong understanding of User Interface design principles across various platforms.

Responsibilities

Develop, test, and debug applications for various healthcare platforms.
Provide software expertise in various computing platforms and operating systems.
Collaborate with Quality Assurance for code testing and debugging.

Skills

Oracle

SQL

Unix/Linux Shell Scripting

Data Warehouse

User Interface (UI) Design

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica

Cognos

Join to apply for the Software Developer 8560-3009 role at Foilcon

2 days ago Be among the first 25 applicants

Join to apply for the Software Developer 8560-3009 role at Foilcon

Get AI-powered advice on this job and more exclusive features.

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.

Description

Responsibilities:

Develop coding, testing, and debugging to support existing extensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PR Upload
Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
Translate technical specifications for sustainment and upgrade into working, tested applications
Undertake proof of technology with test data to simulate application load and performance tuning related applications
Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Provide impact analysis, effort estimate and solution design/development for supported solutions due to DHIR solution upgrades, software upgrades or any new requirements (e.g. Panorama 4.4 upgrades, PHU merge and more)
Provide application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
Maintain Development environments and continue continuous Integration (CI) practice
Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users
Ensure availability of the DHIR extensions/tools for use by all Ontarians.

Skills

Experience and Skill Set Requirements

Public Sector Experience: 5 points

Experience working with federal/provincial/broader public-sector healthcare providers
Knowledge of the provincial immunization system and Public Sector large complex IT Health related projects or equivalent
Experience with integration of Clinical IT Systems such as Client and Provider Registries
Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices
Knowledge of industry standard such as Project Management Institute (PMI)
Experience adopting and adhering to Public Sector Unified I&IT Project Methodology, Public Sector Enterprise Architecture and Public Sector Gating process, and Public Sector Standard Systems Development Methodologies.

Technical Skills: 45 Points

10+ 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
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
Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services
Knowledge of the provincial immunization system.

âCore Skills and Experience: 20 Points

10+ years of experience with:

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
Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications
Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions
Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
Designing, developing and implementing applications that work across modern browsers and various platforms, and mobile devices
Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices
Technical analysis, program code, detailed programming and reports specifications, program design, writing and/or generating code, and conducting tests
Developing and maintaining system design models, technical documentation and specifications
Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
Developing medical and clinical based systems
Web performance optimization
Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
Conducting technical analysis, trouble-shooting, and issue resolutions for production operational support of reports, and other components and utilities
Knowledge of recognized accessibility laws, regulations, and standards (e.g., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing
Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports
Experience with Software Development Lifecycle (SDLC)
Continuous Integration (CI) practice and DEVOPS methodologies and technologies
Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.

âGeneral Skills: 30 Points

Demonstrated strong leadership and people management skills
Exceptional analytical, problem solving and decision-making skills
Demonstrated strong interpersonal, verbal and written communication, and presentation skills
Proven troubleshooting and critical thinking experience
Demonstrated ability to apply strong listening skills to facilitate issue resolution
Effective consulting skills to engage with all stakeholders with proven track record for building strong working relationships
Excellent customer service skills, including tact and diplomacy to ensure client needs are managed effectively
A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

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

Seniority level