Snowflake Data Engineer / ETL Developer (Python & Teradata)

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Mississauga; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

Astra-North Infoteck Inc. is searching for an experienced Snowflake Data Engineer / ETL Developer based in Canada. The ideal candidate will possess 8–10 years of experience in Snowflake, Python, ETL, SQL, and Teradata, with strong database development skills.

This role requires collaborating with Agile teams to design and optimize ETL pipelines, ensuring high-quality data solutions. Candidates with exposure to eCommerce, Retail, or CPG domains will find this position particularly valuable.

Qualifications

• 8–10 years of experience in Data Engineering or ETL Development.
• Hands-on experience with Python and Snowflake.
• Advanced SQL development skills are essential.

Responsibilities

• Design, develop, and optimize ETL pipelines using Snowflake and Python.
• Develop and maintain scalable data solutions on the Snowflake platform.
• Collaborate with Agile teams to deliver high-quality data solutions.

Skills

Snowflake expertise

Python development

ETL development

SQL development

Teradata knowledge

Agile/Scrum experience

Job description

Snowflake Data Engineer / ETL Developer (Python & Teradata)

Location: Markham, ON (Hybrid)

Job Summary

We are seeking an experienced Snowflake Data Engineer / ETL Developer with 8–10 years of experience in Snowflake, Python, ETL, SQL, and Teradata. The ideal candidate will have strong database development skills, hands‑on ETL experience, and exposure to eCommerce, Retail, or CPG domains while working in Agile environments.

Key Responsibilities

• Design, develop, and optimize ETL pipelines using Snowflake, Python, and SQL.
• Develop and maintain scalable data solutions on the Snowflake platform.
• Write complex SQL, PL/SQL, and T‑SQL queries and stored procedures.
• Work extensively with Teradata and relational database systems.
• Collaborate with cross-functional Agile teams to deliver high-quality data solutions.
• Analyze business requirements and translate them into technical designs.
• Optimize database performance and ensure data quality and integrity.
• Support data migration, integration, and transformation initiatives.
• Troubleshoot production issues and implement performance improvements.

Required Skills

• 8–10 years of experience in Data Engineering or ETL Development.
• Strong expertise in Snowflake.
• Hands‑on experience with Python development.
• Extensive experience in ETL development.
• Advanced SQL development skills.
• Strong knowledge of Teradata and RDBMS concepts.
• Experience with PL/SQL and T‑SQL.
• Experience working in Agile/Scrum environments.
• Exposure to eCommerce, Retail, or CPG domains.
• Excellent analytical, problem‑solving, and communication skills.