RQ07422 - Software Developer - ETL - Senior

3 weeks ago


Toronto, Canada Maarut Inc Full time
Job Description

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.


RequirementsExperience and Skill Set Requirements

Informatica (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).

 

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.


Must haves:

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

Nice to Have:

  • AWS experience
  • Experience -Using Informatica on-cloud (IDMC)



  • Software Developer

    3 weeks ago


    Toronto, Canada Global Pharma Tek Full time

    Title: Software Developer - ETL – Senior Duration: Business Days Location: Jarvis St, Toronto, Toronto, Ontario (Hybrid) General Skills:  Experience in programming and analysis; specialized software package support at the specified experience level  ...


  • Toronto, Canada Global Pharma Tek Full time

    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 of data migration activities such as data profiling, data mapping, developing...


  • Toronto, Canada Global Pharma Tek Full time

    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 any technical glitch can be quickly addressed Support the branch in data...

  • Software Developer

    3 weeks ago


    Toronto, Canada Computer Consultants International, Inc. Full time

    HYBRID position at Toronto, OntarioMust haves:7+ years of Data migration in terms of digital transformation, ETL experience in migrating data from legacy applications to modernized solutionsExperience working in ETL tools such as Azure Data Factory, Informatica, etc.Experience in migrating document attachments from legacy solution to a new modernized...

  • ETL Developer

    4 weeks ago


    Toronto, Canada GTT, LLC Full time

    ETL Developer Job Responsibilities The ETL Developer will design, develop, and implement the ingestion framework from Oracle data source to Azure Data Lake - initial load and incremental ETL. Tools used are:Azure Data Factory (good knowledge required) to maintain the pipeline from Oracle to Azure Data LakeAzure Databricks/PySpark (good Python/PySpark...

  • ETL Developer

    3 weeks ago


    Toronto, Canada Maarut Inc Full time

    Job...

  • ETL Developer

    3 weeks ago


    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...


  • Toronto, Canada Foilcon Full time

    HM Note: This hybrid role is three (3) days in officeDescription: • 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 solutionDELIVERABLES:• Provide best practice migration solutions and oversee all facilities of the data and...

  • ETL Developer

    1 day ago


    Toronto, Canada Procom Full time

    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 DescriptionThis Senior Consultant/Developer will operate (run processes), maintain (small code changes) and develop changes (medium to major changes) to the portfolio of products...

  • ETL Cloud Developer

    3 weeks ago


    Toronto, Canada CB Canada Full time

    The opportunityReporting 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 supports global asset investment portfolios. Our new cloud-based ELT/ETL/AWS/AIS...

  • Data Engineer

    3 weeks ago


    Toronto, Canada hireVouch Full time

    Data Engineer**Reports to:** Senior Manager Decision Support and Data Insights Job Summary:We are seeking a highly skilled and motivated Data Engineer to join our team. The ideal candidate will have a strong background in developing ETL processes, managing a cost model in a SQL database, conducting code reviews, overseeing development processes, and...

  • ETL Developer

    19 hours ago


    Old Toronto, Canada Zortechsolutions Full time

    Role: ETL DeveloperLocation: Toronto, ONDuration: Full TimeJob DescriptionSkills and Responsibilities: ETL data warehouse- MS SSIS/SSRS- IBM Netezza, MS SQL server/Sybase database Hadoop (Hive SQL and Pentaho ETL design) AWS Cloud services (Spark, Redshift and EMR) Knowledge in lending systems and functional knowledge on the same Knowledge in MDM systems for...

  • Software Developer

    3 weeks ago


    Toronto, Canada Computer Consultants International, Inc. Full time

    HYBRID position at Toronto, OntarioMust haves:10+ years Informatica Hands-On Working ExperienceDesign, build and tune ETL/ELT solutions on-premises (Informatica Powercenter)AWS experienceExperience -Using Informatica on-cloud (IDMC)


  • Toronto, Canada Iris Software Inc. Full time

    Iris's Fortune 100 direct client is looking for QA Engineer with Automation and Data(ETL/SQL) . Please find below Job description and share me your updated resume at Rajneesh.bhardwaj01@Irissoftware.comRole : QA Engineer with Automation and Data(ETL/SQL)Key Skills : Automation and Data(ETL/SQL)ResponsibilitiesSelenium, Automation Should be Good With...

  • ETL Developer

    1 week ago


    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service TorontoMin. 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 and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    1 week ago


    Toronto, Canada Atlantis IT Group Full time

    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 and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    1 week ago


    Toronto, Canada Atlantis IT Group Full time

    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 and JavaAs a technical expert, provide comprehensive, in-depth consulting and...

  • ETL Developer

    1 week ago


    Toronto, Canada Atlantis IT Group Full time

    ETL Developer with Financial Service TorontoMin. 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 and JavaAs a technical expert, provide comprehensive, in-depth consulting and...


  • Toronto, Canada Clever Devices Ltd. Full time

    As THE leader in transit technology, Clever Devices' vision is to make meaningful contributions to worldwide mobility. Our goal is to be the leading provider of exciting technology that improves the quality of mobility in communities around the world. We are continuing to grow, and are looking for a Senior Software Developer. Clever Devices is growing and as...


  • Toronto, Ontario, Canada Clever Devices Ltd. Full time

    As THE leader in transit technology, Clever Devices' vision is to make meaningful contributions to worldwide mobility. Our goal is to be the leading provider of exciting technology that improves the quality of mobility in communities around the world. We are continuing to grow, and are looking for a Senior Software Developer. Clever Devices is growing and as...