Snowflake Developer

Role - Snowflake Developer

Location - Montreal, QC

Relevant Experience

(in Yrs) More than 5 years' experience.

• Strong proficiency in SQL, SnowSQL, and ETL tools (SSIS).
• Experience with data orchestration tools such as Apache Airflow.
• Familiarity with reporting tools including Tableau, SSRS, and ThoughtSpot.
• Experience with Spark SQL and Azure.
• Knowledge of Agile methodologies and experience in Agile project environments.
• Ability to design and develop reusable Airflow DAGs using PySpark.
• Experience in creating dashboards and visualizations for business reporting.
• Excellent problem-solving skills and ability to work independently and collaboratively.
• Strong communication skills and experience in client-facing roles across global locations.

Experience Required

• 12+ years of experience in data warehousing and business intelligence.
• 5+ years of hands-on experience with Snowflake and AZURE cloud services.
• Strong proficiency in SQL, SnowSQL, and ETL tools (SSIS).
• Experience with data orchestration tools such as Apache Airflow.
• Familiarity with reporting tools including Tableau, SSRS, and ThoughtSpot.
• Excellent problem-solving skills and ability to work independently and collaboratively.
• Strong communication skills and experience in client-facing roles across global locations.

Roles & Responsibilities

• Design and develop robust ETL frameworks and data pipelines using Snowflake and AZURE S3.
• Implement data ingestion and transformation processes using Snowflake's COPY command and SnowSQL.
• Develop and maintain stored procedures, scripts, and reusable components for data processing.
• Python or PySpark / Scala (Microservices).
• Collaborate with platform teams to set up and configure Snowflake environments.
• Integrate Snowflake with orchestration tools such as Apache Airflow (MWAA).
• Design and implement data migration strategies from on-premise databases to cloud environments.
• Create and manage clone objects for zero-copy cloning and testing environments.
• Support business intelligence reporting through tools like Tableau and ThoughtSpot.
• Optimize data collection procedures and ensure data quality and consistency.
• Participate in Agile development processes using Scrum and Kanban methodologies.

Key words to search in resume

Snowflake DB, DW Infra & Snow pipeline, PL SQL, ETL, DW, DM, Automation and Scripting.

Prescreening Questionnaire

• Experience in Snowflake development.
• Skilled in ETL tools like Informatica, TalenD and other tools like Tableau, SSRS, and ThoughtSpot.
• DQ, DM, PL SQL, automation and scripting.
• Experience with Unix and Windows systems.