RQ00476 - Specialized IT Consultant - Senior

Job 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 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
  

Requirements

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.
  

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