Informatica Developer

3 weeks ago

Street, United Kingdom Cleo Consulting Full time
Assignment: RQ07422 SoftwareDeveloper ETL Senior
Start Date:
EndDate:
Office Location: 5700 Yonge Street 10th FloorToronto ON M2M 4K5
Organization: Health ServicesCluster
Ministry: Ministry of Health
#Business Days: 198.00
Title: Software DeveloperETL
Hybrid: Office 3 days a week and 2 days fromhome Must haves:
  • Informatica HandsOn Working Experience (10years)
  • Design build and tune ETL/ELT solutionsonpremises (Informatica Powercenter)
Nice to Have:
  • AWS experience
  • Experience UsingInformatica oncloud (IDMC)
Description
Responsibilities:
  • Assistwith the design and configuration of the cloud infrastructure tooptimally support IDMC.
  • Mentor and support ourETL developers in their transition to IDMC.
  • Help with the ETL code conversion from legacy InformaticaPowerCenter to IDMC;
  • Help with ETL processesoptimization and propose and implement technical solutions wheneverPowercenter code is not supported in IDMC;
  • Bethe main support point for any issues faced by the team whichrequires advanced IDMC knowledge.
  • Provideknowledge transfer to other team members as needed.
Experience and Skill SetRequirements
Informatica (10 years) and AWS (5 years)experience 50 points
Design build and tuneETL/ELT solutions onpremises (Informatica Powercenter) and oncloud(Informatica IDMC).
Informatica transformations mappingsand workflows.
Migrate ETL workloads form onpremises topublic cloud (AWS).
Scripting languages (Python Linuxshell).
ETL processes automation andorchestration
AWS services (S3 Athena Lambda GlueAppFlow Step Functions CloudWatch etc). Database/Data warehouse (10 years)30 points
Relational database design andoptimization experience.
Security controls to safeguardsensitive data (PI and PHI).
Query tunning.
Dimensional data modelling for data warehousing.
Advanced SQL and PLSQL (or equivalent). General Skills 15points
Leadership skills with ability toidentify areas for improvement and recommend solutions.
Exceptional analytical problem solving and decisionmakingskills.
Strong interpersonal verbal and writtencommunication and presentation skills.
Proventroubleshooting and critical thinking experience.
Amotivated flexible detailoriented and creative team player withperseverance excellent organization and multitasking abilities anda proven track record for meeting strict deadlines. PublicSector/Healthcare Experience 5 points
Knowledge of Public Sector Enterprise Architecture artifacts (orsimilar) processes and practices and ability to produce technicaldocumentation that comply with industry standardpractices.
Knowledge of industry standard such asProject Management Institute (PMI) and Public Sector I&ITproject management methodologies.
Knowledge andunderstanding of Ministry policy and IT project approval processesand requirements.
Experience with large complex ITHealthrelated projects.