ETL Developer 7422-0114

4 weeks ago

Toronto, Canada Foilcon Full time

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)

  • ETL Developer

    4 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job...

  • ETL Developer

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

  • ETL Developer

    5 days 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...

  • ETL Developer

    1 week 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...

  • ETL Developer

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

  • ETL Developer

    4 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionJob...

  • ETL Developer

    1 month ago

    Toronto, Canada Tata Consultancy Services Full time

    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 achieved this status. Our organizational structure is domain-led and designed to...

  • ETL Developer

    1 month ago

    Toronto, Canada Tata Consultancy Services Full time

    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 achieved this status. Our organizational structure is domain-led and designed to...

  • ETL Developer

    1 month ago

    Toronto, Canada Tata Consultancy Services Full time

    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 have achieved this status. Our organizational structure is domain-led and designed...

  • ETL Developer

    4 weeks ago

    Toronto, Canada Tata Consultancy Services Full time

    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 achieved this status. Our organizational structure is domain-led and designed to...

  • ETL BI Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Resource ProfileThis 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 data integration and reporting tooling such as IBM Infosphere Information Server...

  • ETL Developer

    7 days 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 Developer

    1 week 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 Developer

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

  • Database Developer

    4 weeks ago

    Toronto, Canada CB Canada Full time

    Database Developer - SQL, ETL On behalf of our client in the Banking Sector, PROCOM is looking for a Database Developer - SQL, ETL. Database Developer - SQL, ETL – Job Description Reviews, analyzes, and modifies programming systems including encoding, testing, debugging and documenting programs Familiar with a variety of the field's concepts, practices,...

  • ETL BI Developer

    3 weeks ago

    Toronto, Canada Maarut Inc Full time

    Job DescriptionResource ProfileThis 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 data integration and reporting tooling such as IBM Infosphere...

  • ETL Developer

    6 days ago

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

  • Software Developer

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

  • Intern, Junior ETL Developer

    4 weeks ago

    Toronto, Ontario, Canada dentalcorp Full time

    This is a full time short-term internship opportunity starting May 2024 until August 2024.Application Deadline is April 16th, 2024Who you areYou are a service-oriented individual who is excited to be a part of a fast-growing organization that enables the best to be even better. You love working in a collaborative team environment, but also enjoy your...

  • ETL Cloud Developer

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