ETL Developer 0164-0618
ETL Developer 0164-0618
Posted on :
03-11-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
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 containerbased 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 and nbsp;Transferred Details:
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;The Candidate will ensure full and nbsp;knowledge and nbsp;transfer and nbsp;is provided to the Ontario Health team before end of engagement.
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;The candidate must provide installation design development and migration related documentation as part of and nbsp;Knowledge transfer.
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;The candidate will consult and collaborate with Ontario Healths Remedy SMEs prior to making any important design and build decisions.
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;The candidate will conduct code/configuration review with Ontario Health Remedy SMEs for any code/configuration built by the candidate.
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;All code configuration and documentation built by the candidate as part of this engagement is considered Ontario Health material.
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;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:
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;5 years experience with ETL (Extract Transform Load) processes to support data from multiple sources into a single target system
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;5 years experience with supporting the design of ETL workflow to support additional identifiers being added to the Provincial Client Registry and nbsp;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;5 years experience with and nbsp;Document ETL design workflows and process and nbsp;
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
