HashedIn by Deloitte interview questions

HashedIn by Deloitte – Campus Recruitment Experience (SDE & SDET) HashedIn by Deloitte visited our campus for SDE and SDET roles. I applied, and my resume was shortlisted for the online assessment. Online Assessment Total candidates: ~700 Candidates shortlisted for interviews: 66 The test consisted of 3 coding questions: Easy Medium Hard I successfully solved the Easy and Medium problems. In the Hard problem, I passed several test cases but not all. Based on my performance, I was shortlisted for the interview rounds. Day 2 – Interview Process Round 1 – Technical (Coding + Database + SQL) This round primarily focused on coding skills and database concepts. Questions asked: 1. Database Design Design a database for a Facebook-like website. Write relevant SQL queries based on the schema. 2. SQL Question Find the 75th, 76th, and 77th lowest salaries from a table. 3. Coding Problems Minimum Window Substring String decoding problem: Input: 3[a2[bc]] Output: abcbcabcbcabcbc I performed above average and was advanced to the next round. Round 2 – Database Design (In-Depth) This round focused entirely on system design and database concepts. Main Task: Design a complete Movie Booking System including: Fully normalized database schema E-R Diagram Relationships between entities Constraints and optimizations The interviewer: Reviewed my design in depth Suggested improvements Asked SQL queries based on my schema Discussed normalization decisions Asked detailed questions about my internships and projects Reviewed my resume line-by-line There was no coding in this round. Round 3 – HR Discussion Two panelists conducted this round. The discussion included: Behavioral questions Situational questions Company-related questions Cultural fit assessment Career aspirations Final Outcome From our campus: 10 students were selected 8 for SDE 2 for SDET