Job Description

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. * "Please ensure that your resume is updated and provided in Word format."

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

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

Job Title: RQ07422 - Software Developer - ETL - Senior
Client: Ministry of Health
Work Location: 5700 Yonge Street, 10th Floor, Toronto, Ontario, Hybrid
Estimated Start Date: 2024-05-22
Estimated End Date: 2025-03-07
#Business Days: 198.00
Extension: Probable after the initial mandate
Hours per day or Week: 7.25 hours per day
Security Level: CRJMCMust Haves
Informatica Hands-On Working Experience (10+ years)
Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter)
Nice to Haves
AWS experience
Experience -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 RequirementsInformatica (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 pointsDatabase/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 pointsGeneral 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 pointsPublic 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 pointsDescription
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

S M Software Solutions