RQ00476 Specialized IT Consultant – Senior

Must Haves:

• 5 years Experience with IBM InfoSphere Master Data Management Identity Hub Standard Edition (formerly Initiate)
• 5 years Experience of IBM WebSphere Application Server (WAS)
• 5 years Experience with ETL (Extract Transform Load) processes to support data from multiple sources into a single target system
• 5 years Experience Java development experience

Nice to Haves:

Practical experience with HL7 messaging Cloverleaf integration suite and IBM InfoSphere DataStage

Background Information

• The purpose of this request is to acquire a Sr. Specialized IT Consultant who will be 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 be responsible for the development of data-in and data-out API queries and data alignment activities which will contribute toward the overall Immunization Repository project.
• Immunization Repository is a cornerstone within MOHs one immunization record (Immunization Repository) priority and is in line with Ontarios desired immunization future state. This work will be one of the forthcoming projects in the Immunization Repository Optimization Program one of the key components of the Public Health Digital Platform (under Clinical Care Service delivery).

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 Senior Specialized IT 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 Specialized IT Consultant will support the foundation data alignment activities which will contribute toward the overall Immunization Repository project.

Desired Skills:

• Technical background including Java Development and application design experience
• 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
• Practical experience with HL7 messaging Cloverleaf integration suite and IBM InfoSphere DataStage
• Experience with SQL programming in relational databases
• 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.

Evaluation Criteria:

• 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
• Minimum 5 years experience working with ETL processes and remediation.: 20 Points
• Minimum 3 years experience working with Integration Engines in support of data exchange .: 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 Points
• Excellent communication skills written and verbal (articulate detail oriented and factual) and interpersonal (clarifying active listening) manage conflict or stressful situations .:15 Points
• Total evaluation criteria: 100 Points

Deliverables

Deliverables Include but are not limited to:

• 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 PCR
• 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 Ontario Health 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 Ontario Health 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.

• The term of this Engagement Assignment is 252 Business Days with an option to extend for up to an additional 250 days at Ontario Healths discretion. The Engagement Assignment may be extended for unused Business Days at Ontario Healths discretion.
• The resource will comply with Ontario Health policies and procedures.
• Ontario Health systems cannot be accessed from outside the province of Ontario and Ontario Health assets including laptops and related equipment cannot be removed from the province of Ontario without prior written approval from Ontario Health.

Knowledge Transfer Details:

• The resource will 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.
• The resource must provide all related documentation as part of knowledge transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director.
• The resource will work collaboratively with the Ontario Health team throughout the assignment and ensure key deliverables milestones and documentation are shared.
• A walkthrough of any demos development etc. will be required before the end of the engagement.