Senior Snowflake and IICS Developer to support multiple ETL projects for the data migration of Oracle database to Snowflake. - 853
S.i. Systems
Toronto, ON-
Number of positions available : 1
- Salary To be discussed
-
Contract job
- Published on November 21st, 2024
-
Starting date : 1 position to fill as soon as possible
Description
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
Requirements
undetermined
undetermined
undetermined
undetermined
Other S.i. Systems's offers that may interest you