Snowflake Interview Experience for Data Science (On-Campus) for Internship

I wanted to share my incredible experience with the #campushiring process at Snowflake, where I interviewed for the Data Engineer role. The process was efficient and enlightening, and I’m grateful for the opportunity.

Process Highlights: Registration and Shortlisting: The journey began with the opening of registrations. Snowflake’s team efficiently shortlisted candidates based on resumes for direct interviews.

Two Interview Rounds: The process consisted of two interview rounds, each designed to assess different aspects of a candidate’s skills and knowledge.

Technical Round 1 (20 min): 8 resumes were shortlisted, including mine.

Questions asked:

• Introduce myself
• I shared details about my projects and the challenges I tackled.
• Discussed my familiarity with tech stacks.
• Few basic OOP questions.

Technical Round 2 (45 min): 4 candidates, including me, proceeded to this round.

It Was A Detailed technical interview:

• Introduced myself and elaborated on my projects.

Started with detailed SQL theory and practical questions:

• Differentiated between DB and Data Warehouse.
• Why a DB isn’t a Data Warehouse.
• Discussed various constraints with real-world use cases.
• Explain the primary key, candidate key, and super key distinctions.
• Detailed the types of joins and their output differences.

Next, table-based queries were told to be written

Tables Structure:

• Craft a query to find the 3rd highest salary.
• Formulate a query to identify the department with the most active projects.
• A query for employee names with their departments who are involved in one or more projects.
• Briefly compared Java and Python.

Outcome: Although not selected for the next round, I gained valuable experience.