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

S.i. Systems
Montreal
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 plus de 30 jours
Emplois reliés
S.i. Systems
Montréal, Québec

Develop detailed documentation for monitoring processes and setups, and provide knowledge transfer to internal staff to ensure effective use and maintenance of the monitoring tools. As the successful candidate, you will work with other application and operational experts to ensure the highest level ...

Tiger Analytics
Montréal, Québec

You will collaborate closely with data scientists, analysts, and other stakeholders to ensure efficient data flow and support data-driven decision making across the organization. As a Data Engineer, you will be responsible for designing, building, and maintaining data pipelines, data integration pro...

S.i. Systems
Montréal, Québec

The Learning Designer creates innovative, digital, adaptive and engaging solutions aligned to the best practices and standards for design delivery. The Learning Designer challenges the status quo with forward thinking and collaborates to meet the needs of our team within digital learning solutions. ...

Deloitte
Montréal, Québec

The Office of the General Counsel is a national, high performing group of professionals providing legal advice to the Deloitte Canada firm and our business leaders. We bring together people with unique experiences and talents, and we are the place to develop a lasting network of friends, peers, and ...

S.i. Systems
Montréal, Québec

Gather and formally document the object inventory, capturing details including data sources and data requirements to fulfill internal and external audit requirements. Intermediate ETL Developer to design, implement, and continuously expand data pipelines by performing extraction, transformation, and...

Randstad Canada
Montréal, Québec

In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's...

Treasury Board of Canada Secretariat
Boucherville, Québec

The job opportunity you have selected requires the Public Service Commission (PSC) to transfer you to the hiring organization's Web site or a service provider Web site they have selected to advertise this process. Select the link below to be transferred from the PSC's GC Jobs Web site and be directe...

KPMG
Canada, Canada

Are you a talented leader with a proven track record for motivating teams and delivering exceptional client service? Our Enterprise Solutions Oracle team is looking for a professional like you with the skills and drive to make a real difference. Building on the success of our practice, we are seekin...

Aritzia
Canada, Canada

As the (Senior) Analytics Engineer, you will support and enable the business, apply data modeling expertise, and become the data domain go-to person. The mission of the Analytics Department is to provide the business with actionable and accurate information to enable data-driven decision-making. Thi...

KPMG
Canada, Canada

Commitment to maintaining confidentiality and integrity of Oracle SCM and Procurement data and information, adhering to data security and privacy regulations and best practices. Strong understanding of SCM and Procurement processes, policies, regulations, and compliance requirements specific to Orac...