Senior Snowflake and IICS Developer to support multiple ETL projects for the data migration of Oracle database to Snowflake. - 853

S.i. Systems
Toronto
Temporaire

Our valued client is actively seeking a Senior Snowflake and IICS Developer to support multiple ETL projects for the data migration of Oracle database to Snowflake.

7 month Contract - strong potential for extension. Work environment is hybrid (2 days onsite) in Montreal or Toronto.

Responsibilities

  • Responsible for utilizing SnowSQL and Python scripting to assist in the migration process, demonstrating proactive, driven, and capable of managing multiple projects simultaneously.
  • Collaborate with the project team to understand requirements and objectives for migration of Oracle to Snowflake.
  • Develop and implement Snowflake solutions, including data modeling, ETL processes, and data warehousing.
  • Write and optimize SQL queries and stored procedures in Snowflake to ensure optimal performance and efficiency.
  • Create and maintain Python scripts to automate tasks related to data migration and processing.
  • Assist in troubleshooting and resolving technical issues that arise during the migration process.

Must-have Skills

  • Snowflake database experience, scripting with SQL (ideally SnowSQL)
  • IICS (Informatica Intelligent Cloud Services) development experience in ETL
  • AWS cloud experience

Nice-to-have Skills

  • Python
  • French language skills
  • CI / CD Pipeline
  • Il y a 23 jours
Emplois reliés
S.i. Systems
Toronto, Ontario

Role Mandate: As a Analyst on the Distribution Strategy team, you will support the development and execution of strategic initiatives aimed at optimizing the distribution of mutual funds, ETFs, and other investment products. Reporting to the Head of Distribution Strategy, you will work closely with ...

University of Toronto
Toronto, Ontario

Home to over 40 departments and institutes, the University of Toronto's Temerty Faculty of Medicine lies at the heart of the Toronto Academic Health Science Network and is a global leader in ground-breaking research and education, spanning clinical medicine, basic science and the rehabilitation scie...

S.i. Systems
Toronto, Ontario

Follow and control the project evolution and communicate the progress made, in line with corporate policies and standards; effectively facilitate meetings and create presentations related to milestones, issue resolution, project status; conduct overall project/program reporting; identify problem sit...

EY
Toronto, Ontario

Our Total Rewards package includes a comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, a great vacation policy plus firm paid days that allow you to enjoy longer long weekends throughout the year, statutory holidays and paid personal days (based on pr...

S.i. Systems
Toronto, Ontario

SMP/E and system utilities, ACF2, RACF, IO Gen (HCD), Assembler Language knowledge and ability to develop, maintain and deploy Assembler code, BMC & IBM Scheduler software, TSO, ISPF, understanding of problem & change, management (eESM experience is an asset), Install and support program products, i...

Aritzia
Vaughan, Ontario

Proven skills, education, and/or applicable certifications in: Excellent SQL skills with the ability to create efficient & tune data modelsStrong business modelling skills: going from expressed requirements to an actual data modelVaried design options of reshaping data tablesModern cloud data platfo...

The Toronto-Dominion Bank (Canada)
Markham, Ontario

Whether you have a passion for helping customers and want to expand your experience, or you want to coach and inspire your colleagues, there are many different career paths within our organization at TD – and we’re committed to helping you identify opportunities that support your goals. It is critic...

University of Toronto
Toronto, Ontario

We pride ourselves on the high number of UTemp employees who are able to make the transition from short-term casual employment to appointed positions within the University of Toronto. The UTemp team handles each project with a unique hands-on approach to ensure we find the best candidate for the job...

City of Toronto
Toronto, Ontario

Leads, facilitates and contributes to the design, creation, development and sustainment of corporate standards for the division, including formalized project management and methodology, data warehousing architecture, data modeling, metadata, change management, and application development and migrati...

BMO
Canada, Canada

Uses data mining and extracting usable data from valuable data sources to assess feasibility of AI/ML solutions for improved processing and usage of organization data. Plays an active role in the futuristic display of data, and advancement of innovative data strategies to understand consumer trends ...