Jobs
>
Chester-le-Street

    Informatica Developer - Street, United Kingdom - Cleo Consulting

    Cleo Consulting
    Cleo Consulting Street, United Kingdom

    1 week ago

    Default job background
    Description
    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.
  • Gentoo

    Senior SQL Database Administrator

    3 days ago

    Gentoo Sunderland, United Kingdom

    **About the role**: · Gentoo is a values-led, charitable organisation that provides more than 60,000 people in Sunderland with a place they can call home. We have a clear vision and a social purpose. We believe that everyone has the right to live in a good quality home that they ...

  • Nigel Wright Recruitment

    sql dba

    1 week ago

    Nigel Wright Recruitment Sunderland, United Kingdom

    Job Description · The Company · We are currently recruiting for a Lead SQL Database Administrator for our client based at their head office in Sunderland. The business has invested significantly in technology over recent years and this is set to continue as they look to develop n ...

  • Nigel Wright Recruitment

    sql dba

    1 week ago

    Nigel Wright Recruitment Sunderland, Tyne and Wear, United Kingdom

    The Company · We are currently recruiting for a Lead SQL Database Administrator for our client based at their head office in Sunderland. The business has invested significantly in technology over recent years and this is set to continue as they look to develop new applications a ...

  • Nigel Wright Recruitment

    Database Administrator SQL DBA

    1 week ago

    Nigel Wright Recruitment Sunderland, Tyne and Wear, United Kingdom

    We are currently recruiting for a Lead SQL Database Administrator for our client based at their head office in Sunderland. The business has invested significantly in technology over recent years and this is set to continue as they look to develop new applications and business int ...

  • Nigel Wright Recruitment

    Database Administrator SQL DBA

    1 week ago

    Nigel Wright Recruitment Sunderland, Tyne and Wear, United Kingdom

    The CompanyWe are currently recruiting for a Lead SQL Database Administrator for our client based at their head office in Sunderland. The business has invested significantly in technology over recent years and this is set to continue as they look to develop new applications and b ...

  • Nigel Wright Recruitment

    sql dba

    1 week ago

    Nigel Wright Recruitment Sunderland, Tyne and Wear, United Kingdom

    The CompanyWe are currently recruiting for a Lead SQL Database Administrator for our client based at their head office in Sunderland. The business has invested significantly in technology over recent years and this is set to continue as they look to develop new applications and b ...