Software Developer – Senior

Job title: Software Developer – Senior

Company: LanceSoft

Job description: Title: Software Developer – Senior
Location: Toronto, Ontario (Hybrid)
Duration: 10 Months with Possible extensionSkills
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.[TF1]

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

Expected salary:

Location: Toronto, ON

Job date: Fri, 30 May 2025 05:28:44 GMT

Apply for the job now!