Snowflake Developer Interview at Infosys

Potential Interview Rounds would be the initial screening, which is typically a brief phone or video call to assess your basic qualifications, experience, and interest in the role. And then the technical round. Expect questions on SQL queries, DML, DDL, data loading, and performance tuning. And I guess last round would be HR to access your soft skills. All the best!

Tips: Brush up on Snowflake best practices, optimization techniques, and real-world use cases. Review your past projects and be ready to explain them. Be clear on your problem-solving approach during coding rounds.

I recently gave the Snowflake Developer interview at Infosys There were no screening round via phone call. All the communication happened via email or whatsapp. I only received the call for interview scheduling and not for initial screening kind of round. There were 2 rounds TR and MR round. In TR round I was asked first for the brief introduction, write SQL query for specific scenarios, snowflake structure, data warehousing, etl, elt, joins, a tough work you did in my job, time travel, Query Optimization Techniques. In MR round it started with basic introduction then some technical questions which were basics only about dwh concepts. And basic MR questions like how you deal with challenges, have you lead a team, how you will handle if you made a mistake and how you will explain this to client etc.