Please apply ONLY if you have Public Service Experience in CanadaExperience 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 orchestrationAWS services (S3, Athena, Lambda, Glue, AppFlow, Step Functions, CloudWatch etc).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).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.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."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".