Snowflake Interview Experience | On-Campus 2020

Recently Snowflake Inc. visited our college The Vishwakarma Institute of Technology, Pune for a Software Engineer Intern role + FTE. The entire process was virtual on the Zoom meeting. The selection process consists of a total of 2 rounds. Eligible Branches were CSE, IT, ECE. 

• Eligibility Criteria: CGPA of 7.00.

Round 1 (Online Test): The online test was conducted on the Hackerrank platform. It consists of 2 coding questions

1. Removing string that is an anagram of an earlier string.
2. 2nd question was of medium level. (I don’t remember)
3. 2 database queries (medium level)
4. MCQs from OS, ML, Cloud Computing, and some aptitude questions.

After this round, 42 students were selected for an interview.

Round 2 (Virtual Interview): There were 4 panelists for an interview. The interview was conducted at a Zoom meeting. First, all interviewer introduces there self and then asked me to introduce myself. I introduce myself and mentioned my interest in application development, so one of the interviewers started asking me questions on SDLC.

1. Do you know SDLC? Explain it.
2. Types of testing.
3. In which type integration testing comes.

Technical Interview: Then the technical interviewer started asking me questions

1. Explain ACID properties.
2. Relations in database
3. Is many to many relations feasible if not what can we do?
4. Normalization
5. Types of Indexing
6. Data structures in Java
7. How we can implement priority queue?

It was mostly on DBMS as Snowflake is a data warehouse company.

Then one interviewer who works in the cybersecurity domain started asking me questions. He asked me 4-5 questions but I don’t know anything about cybersecurity so answered don’t know about this domain, so he said I have no questions for you and handed it over to HR.

HR interview:

1. Which is your dream job?
2. On which domain you would like to work? (I mentioned Backend technologies)
3. Would you like to work in an operational domain?
4. Do you know SaaS? Example
5. And some situational based questions.

They didn’t ask me do you have any questions? But I asked them lastly 🙂 That’s it finally the results announced, and I was selected 🙂

Note: Be confident about your answers and calm throughout the process. If you don’t know the answer to any question then tell them honestly.

Stay positive and give your best. All the best 🙂