A new requirement from one of the ministries in Ontario. Please refer to the details provided below:
We are unable to submit a candidate without below mandatory documents.

1. "Please ensure that your resume is updated and provided in Word format."

1. "To facilitate our evaluation process, please fill out the attached Skills Matrix and provide your references accordingly."

1. "We kindly request that you specify your expected hourly rate."

Job Title:RQ07422 - Software Developer - ETL - SeniorClient:Ministry of HealthWork Location:5700 Yonge Street, 10th Floor, Toronto, Ontario, HybridEstimated Start Date:2024-05-22Estimated End Date:2025-03-07#Business Days:198.00Extension:Probable after the initial mandateHours per day or Week: 7.25 hours per daySecurity Level:CRJMC
Must HavesInformatica Hands-On Working Experience (10+ years)Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter) Nice to HavesAWS experienceExperience -Using Informatica on-cloud (IDMC)
Note:
This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home. The details of this arrangement will be confirmed with the Hiring Manager.
Extension/Amendment Attestation: Extension(s) only allowed using unused days/funds left on contract. No additional funds will be added beyond maximum contract value and any extension options included in the original SOW.
Experience and Skill Set Requirements
Informatica (10+ years) and AWS (5+ years) experience

• Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter) and on-cloud (Informatica IDMC).
• Informatica transformations, mappings and workflows.
• Migrate ETL workloads form on-premises to public cloud (AWS).
• Scripting languages (Python, Linux shell).
• ETL processes automation and orchestration
• AWS services (S3, Athena, Lambda, Glue, AppFlow, Step Functions, CloudWatch etc).

50 points
Database/Data warehouse (10+ years)

• Relational database design and optimization experience.
• Security controls to safeguard sensitive data (PI and PHI).
• Query tunning.
• Dimensional data modelling for data warehousing.
• Advanced SQL and PLSQL (or equivalent).

30 points
General Skills

• Leadership skills with ability to identify areas for improvement and recommend solutions.
• Exceptional analytical, problem solving and decision-making skills.
• Strong interpersonal, verbal and written communication, and presentation skills.
• Proven troubleshooting and critical thinking experience.
• A motivated, flexible, detail-oriented and creative team player with perseverance, excellent organization and multi-tasking abilities, and a proven track record for meeting strict deadlines.

15 points
Public Sector/Healthcare Experience

• Knowledge of Public Sector Enterprise Architecture artifacts (or similar), processes and practices, and ability to produce technical documentation that comply with industry standard practices.
• Knowledge of industry standard such as Project Management Institute (PMI) and Public Sector I&IT project management methodologies.
• Knowledge and understanding of Ministry policy and IT project approval processes and requirements.
• Experience with large complex IT Health-related projects.

5 points
Description
Responsibilities:

• Assist with the design and configuration of the cloud infrastructure to optimally support IDMC.
• Mentor and support our ETL developers in their transition to IDMC.
• Help with the ETL code conversion from legacy Informatica PowerCenter to IDMC;
• Help with ETL processes optimization and propose and implement technical solutions whenever Powercenter code is not supported in IDMC;
• Be the main support point for any issues faced by the team which requires advanced IDMC knowledge.
• Provide knowledge transfer to other team members as needed.

Powered by JazzHR

M0xjTdRTPC