HM Note: This hybrid role is one (1) day in office
Description
Must haves:
-
Experience with IBM InfoSphere Master Data Management Identity Hub Standard Edition (formerly Initiate)
-
Excellent knowledge of IBM WebSphere Application Server (WAS)
-
Experience with ETL (Extract, Transform, Load) processes to support data from multiple sources into a single target system
-
Java development experience
-
Practical experience with HL7 messaging, Cloverleaf integration suite and IBM InfoSphere DataStage
-
Experience with SQL programming in relational databases
-
A strong knowledge of Health care systems
-
Strong understanding of Software Development Life Cycle (SDLC), Quality Assurance requirements, and software
-
Development control and release procedures
-
Experience with distributed messaging and streaming data solutions (e.g., Kafka)
-
Experience with container-based development (e.g., Docker, Kubernetes, OpenShift)
-
Extensive experience in troubleshooting and remediation
-
Knowledge of Immunization workflows and associated business processes within pharmacies, hospitals and health records, an asset
-
Past experience with jurisdictional public health programs (example: Immunizations) will be of significant benefit
Responsibilities:
The Consultant is responsible for ensuring alignment between the Provincial Client Registry (PCR) and client identifiers associated with Immunization data submitted by the ministry. The Senior Specialist will support the foundation data alignment activities which will contribute toward the overall Immunization Repository project.
Desired Skills:
-
Working with others to share expertise and achieve outcomes that benefit the organization, demonstrating strong communication skills to others on the team through active listening, summarizing, and facilitating. Articulates approach in succinct manner.
-
Ensures the timely delivery of support, effectively adapting to tight deadlines and sudden changes in priorities to accomplish objectives. Plans for possibilities and contingencies, identifying opportunities and problems to ensure that best results are achieved. Recognizes and makes best use of the diverse skills, abilities, experiences of team members to achieve best outcomes.
-
Demonstrating the unique skills required of the job; staying current with changing job skills to positively impact operational efficiency and the effectiveness of services provided. Insight of the Provincial Registries is an asset.
-
Technical background including Java Development and application design experience
-
Experience operating in highly political environments and across various organizational cultures.
-
Working knowledge of privacy policies and legislative processes – Health Protection and Promotion Act (HPPA), Freedom of Information and Protection of Privacy Act (FIPPA) and Personal Health. Information Protection Act (PHIPA) and associated Health Information Custodian (HIC) requirements
-
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
Criteria Details:
-
Minimum 5 years' experience with IBM InfoSphere Master Data Management. Standard edition experience preferred: 20 Points
-
Minimum 5 years' experiences integrating system and supporting web services via Java Development: 20 Points
-
Experience working with ETL processes and remediation: 20 Points
-
Excellent communication skills, written and verbal (articulate, detail oriented and factual) and interpersonal (clarifying, active listening), manage conflict or stressful situations: 15 Points
-
Experience working collaboratively with business partners and stakeholders to understand and analyze current state, provide recommended approach, and develop factual and concise deliverables: 10
- Experience working with Integration Engines in support of data exchange: 15 Points
Deliverables
Deliverables Include:
-
Update common interface to reflect changes to data model
-
Update common interface to support FHIR queries such as Search by Location, Practitioner Role, Health Care Service, or End Point
-
Develop interfaces for add and update transactions for the Provincial Client Registry (PCR)
-
Add data validation rules to the common interface
-
Support the design of ETL workflow to support additional identifiers being added to the Provincial Client Registry
-
Document ETL design, workflows and process
-
Update error handling to enhance messages and establish common error responses (e.g., change error code for a member not found response from http 500 error to an eHealth Ontario agreed upon alternative)
-
Ensure full knowledge transfer is provided to the Ontario Health team before end of engagement. Some of this might occur at the end of the engagement but will also be shared as information is obtained/consolidated. Key deliverables will be shared with team, using an approved format.
-
Provide all related documentation as part of Knowledge transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director.
-
Work collaboratively with OH team throughout the assignment and ensure key deliverables, milestones, and documentation are shared.
-
Conduct a walkthrough of any demos, development, etc. will be required before end of engagement, as required.
Knowledge Transferred Details:
- The Candidate will ensure full knowledge transfer is provided to the Ontario Health team before end of engagement.
- The candidate must provide installation, design, development, and migration related documentation as part of Knowledge transfer.
- The candidate will consult and collaborate with Ontario Health's Remedy SMEs prior to making any important design and build decisions.
- The candidate will conduct code/configuration review with Ontario Health Remedy SMEs for any code/configuration built by the candidate.
- All code, configuration, and documentation built by the candidate as part of this engagement is considered Ontario Health material.
- The candidate must complete all Knowledge Transfer at the latest two weeks before the end of the contract and it must be signed off by Ontario Health manager.
Must Haves:
- 5+ years' experience with ETL (Extract, Transform, Load) processes to support data from multiple sources into a single target system
- 5+ years' experience with supporting the design of ETL workflow to support additional identifiers being added to the Provincial Client Registry
- 5+ years' experience with Document ETL design, workflows and process
