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.