Jobs
>
Toronto

    ETL Developer 7422-0114 - Toronto, Canada - Foilcon

    Foilcon
    Default job background
    Contract Corp-to-Corp
    Description

    HM Note: This hybrid role is three (3) days in office

    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.

    Skills

    Experience and Skill Set Requirements

    Informatica (10+ years) and AWS (5+ years) experience: 50 points

    · 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).

    Database/Data warehouse (10+ years): 30 points

    · 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: 15 points

    · 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: 5 points

    · 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.

    Must haves:

    1. Informatica Hands-On Working Experience (10+ years)
    2. Design, build and tune ETL/ELT solutions on-premises (Informatica Powercenter)

    Nice to Have:

    1. AWS experience
    2. Experience -Using Informatica on-cloud (IDMC)

  • Maarut Inc

    ETL BI Developer

    5 days ago


    Maarut Inc Toronto, Canada

    Resource Profile · This requirement is for a ETL and BI Developer to work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and ...

  • Procom

    ETL Developer

    6 days ago


    Procom Toronto, Canada

    ETL Developer - Informatica DEI On behalf of our client in the Healthcare Sector, PROCOM is looking for an ETL Developer - Informatica DEI. ETL Developer - Informatica DEI - Job Description · This Senior Consultant/Developer will operate (run processes), maintain (small code chan ...

  • Atlantis IT Group

    ETL Developer

    2 weeks ago


    Atlantis IT Group Toronto, Canada

    ETL Developer with Financial Service · Toronto · Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domainMin. 10+ years of years of experience in developing automated scripts using SQL, VB Script a ...

  • Tata Consultancy Services

    ETL Developer

    1 week ago


    Tata Consultancy Services Toronto, Canada

    About TCSTCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to have ...

  • Tata Consultancy Services

    ETL Developer

    1 week ago


    Tata Consultancy Services Toronto, Canada

    About TCS · TCS operates on a global scale, with a diverse talent base of more than 600,000 associates representing 153 nationalities across 55 countries. TCS has been recognized as a Global Top Employer by the Top Employers Institute - one of only eight companies worldwide to ha ...

  • Nexus Systems Group Inc.

    ETL Developer

    1 day ago


    Nexus Systems Group Inc. Old Toronto, Canada

    ETL Developer · Typical Day in Role: · • Write well designed, testable, efficient code by using best software development practices · • Gather and refine specifications and requirements based on technical needs · • Direct day-to-day activities in a manner consistent with our risk ...


  • Scotiabank Toronto, Canada

    The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and technology initiatives. Along with providing thought leadership, navigating us through production issues and investigations, and bein ...

  • CB Canada

    ETL Cloud Developer

    1 week ago


    CB Canada Toronto, Canada

    The opportunity · Reporting to the Vice President of Enterprise Applications and working on the integration team, we are looking for an ETL Cloud Developer. You will play a vital role in designing, developing and supporting a new real estate cloud-based data platform that support ...


  • Global Pharma Tek Toronto, Canada Contract

    Title: Software Developer - ETL Senior · Location: Toronto, ON (Hybrid) · Duration: Business Days + Possible extension · Job Description: Full life-cycle data conversion experience with enterprise systems, including deployment experience. · Experience working with all steps o ...


  • Atlantis IT group Toronto, Canada Full time

    · Role Description: Undergraduate Degree or Technical Certificate. A minimum of 5 years experience with large SQL data marts. Expert relational database experience, Canditate should demonstrat ability to navigate through massive volumes of data to deliver effective and efficient ...


  • Tata Consultancy Services Toronto, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...


  • Global Pharma Tek Toronto, Canada Contract

    Position: Senior ETL Software Developer · Location: Toronto, ON (Hybrid) · Duration: Business Days · Job Description: · Responsibilities: Support the branch in developing and implementing the technical solutions needed as well as providing operational support ensuring that a ...


  • Tata Consultancy Services Toronto, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...


  • Atlantis IT group Toronto, Canada Full time

    Role: Competencies: BPS : SQL Basic, Foundation : JavaScript · Experience (Years): 8-10 Min. 10+ years of experience in Financial Services client with atleast 5+ years of experience in Asset Servicing or Capital markets domain'Min. 10+ years of years of experience in developing a ...


  • Fossbytes Media Pvt Ltd Old Toronto, Canada

    Requisition ID: 184466 · Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture. · The Sr. ETL Engineer is responsible for design and development of ETL solutions to integrate with our Salesforce platform for complex business and te ...


  • Foilcon Toronto, Canada Contract Corp-to-Corp

    HM Note: This hybrid role is three (3) days in office · Description: · • A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy application to a new solution · DELIVERABLES: ...


  • Randstad Canada North York, Canada Freelance

    Our client, a leader in the Healthcare industry, is looking for a Senior ETL developer for doing product updates, operations and maintenance on a series of ETL products. · This Senior Developer must be knowledgeable and experienced in the following technologies to be able to sup ...


  • EBF Toronto, Canada

    on behalf of our client on Public Sector. we are looking for contract **Business Intelligence Specialist - ETL Developer** · Description · **General Responsibilities** · - Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and i ...


  • AlphaForce Technology Solutions Toronto, Canada

    **Position: Business Intelligence Specialist - Senior** · **Location: 315 Front Street, Toronto, ON** · **Security Level: CRJMC** · **Must haves**: · - 7+ years in ETL tools such as Microsoft SSIS, stored procedures (Must Have) · - 2+ Azure Data Lake and Data Warehouse, and build ...


  • Foilcon Toronto, Canada

    **Description**: · **General Responsibilities** · - Design, develop and implement ingestion framework from Oracle source to Azure Data Lake - initial load and incremental ETL. Used tools are: · - Azure Data Factory (expert knowledge) to maintain pipeline from Oracle to Azure Data ...