Specialized IT Consultant - Senior

Must haves:

• Strong understanding of Master Data Management processes and principles
  
• Experience with IBM InfoSphere Master Data Management Identity Hub Standard Edition (formerly Initiate)
  
• version 11.x
  
• Excellent knowledge of IBM WebSphere Application Server (WAS)
  
• Practical experience with HL7 messaging Cloverleaf integration suite and IBM InfoSphere DataStage
  
• Experience with SQL programming in relational databases
  
• Knowledge of ETL processes
  
• 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 containerbased development (e.g. Docker Kubernetes OpenShift)
  
• Extensive experience in troubleshooting and remediation
  

Deliverables:

• The objective of this procurement is to approve staff augmentation via Flextrack contingent resources to provide application development deployment configuration integration and customization services for the Identity Access and Privacy (IAP) applications (e.g. Provincial Client Registry (PCR) and Provincial Provider Registry (PPR)). The primary skills required are for IBM InfoSphere Master Data Management (MDM) and ETL (Extract Transform Load).
  
• This procurement will enable the agency to enhance the products and address operational issues. Product enhancements include new features and interfaces required to address additional consumers and contributors as well as improvements to existing functions to serve existing clients better
  

Deliverables include but are not limited to:

The operational issues fall into the categories of continuous improvement and break/fix. The continuous improvement work includes automation of maintenance tasks such as database archiving or partitioning of large tables to manage performance and response times. Examples include:

• Completion of the common interface to provide a consistent interface between MDM and FHIR interfaces
  
• 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 PPR
  
• Add data validation rules to the common interface
  
• Document ETL workflows process and remediation steps.
  
• 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)
  
  

Responsibilities:

• Support the documentation of ETL processes and documentation
  
• Update the custom HL7v2 PubSub Service to alert subscribers to changes in the Service Catalog
  
• PPR performance improvements to response time and capacity
  
• Documentation of the developed solutions including developers guide build book deployment guide and support procedures
  
• Develop a health check to validate PPR services that can be automated and run by eHealth Ontario Technical Operations Centre
  
• Establish process and procedure for capture review and mediate application or interface errors
  
• Develop Publish/Subscribe capabilities to notify consuming systems of data changes in PPR leveraging Apache Kafka
  
• Consultant will require access to PHI to support registries database
  
• Provide Application Support as required
  

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.
  
  

Requirements

MUST

• Knowledge of ETL processes experience with CDC Data Stage
  
• Strong understanding of Master Data Management processes and principles ability to provide operational type support writing queries.
  
• Document operation procedure for any design/code they may do.
  
• Excellent knowledge of IBM WebSphere Application Server (WAS)
  
• Practical experience with HL7 messaging Cloverleaf integration suite and IBM InfoSphere DataStage