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

S.i. Systems
Toronto
$100K a year (estimated)
Full-time

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

Initial contract until end of year - 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
  • 5 days ago
Related jobs
S.i. Systems
Toronto, Ontario

The primary focus of the team is reacting to any/all anomalies that are presented through a variety of monitoring tools for the Bank’s mission critical network. Tier 1 level support role and please make sure candidates are aware of the following and fine with them:. Operations Support Group (Network...

Promoted
Employment and Social Development Canada
Canada

Experience providing administrative support in a police environment and to senior management, extracting data and preparing statistical reports, record management support, and using various police and HR information systems. The Public Service of Canada promotes employment equity and encourages you ...

S.i. Systems
Toronto, Ontario

Interact with vendors and internal stakeholders for software improvement (documentations and process improvement) needed to incorporate into the planning for integration into the DERMs Platform . Senior Project Manager to interact with vendors and internal stakeholders for provide documentations and...

Care.com
Vaughan, Ontario

We are looking for one person who could assist our family with, mainly transporting the children to/from school, and also helping us out with daily routines, light cooking, housekeeping, and related tasks. We are a fantastic family: mom, one 7 year old boy and one 11 year old girl, and a cuddly Fren...

S.i. Systems
Toronto, Ontario

Maintains information in a database format to address budgeting, compliance and inventory, contracts and costs and assists in the development of reporting to address management requirements for information and composes relevant reports to support management decision-making;. Organizes, analyzes and ...

University of Toronto
Toronto, Ontario

While there is a lot of room for creativity in course delivery, instructors will be expected to follow the basic content and style used by the faculty members who normally teach the course, and must get approval from these faculty members or from the Associate Chair for any substantial changes to th...

On Behalf of the Employer- TWPG is recruiting for
Ontario, Canada

We provide equal employment opportunity for all applicant and Employee’s and do not discriminate on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, creed, sex, sexual orientation, gender identity, gender expression, age, record of offences, marital status, family st...

KPMG-Canada
Toronto, Ontario

Strong understanding of HCM, Time and Labour and Absence Management processes, policies, regulations, and compliance requirements specific to Oracle HCM, Time and Labour and Absence Management to provide effective functional support and assistance to end-users. Commitment to maintaining confidential...

Scotiabank
Toronto, Ontario

Provide timely IT support to the enquiries from regulators in Canada and US and internal business stakeholders to meet critical timelines. Work within a cross functional Agile team to analyse and troubleshoot technical issues and production support tickets and deliver solutions for the same. Work cl...

The Home Depot Canada
Mississauga, Ontario

This includes changing and/ or servicing all material handling equipment (MHE) batteries, maintaining and running the floor scrubber, operating the baler/compactor and performing light utility and maintenance activities for the facility. Scope of Role: General DC Maintenance functions such as but no...