.png){kind=small}
_edited.png){kind=small}
Branch:
Electrical and Electronics Engineering
Placement Session:
2023-2024
Offer obtained:
FTE
Description of role:
Job location:
Eligible Branches:
Eligibility Criteria:
Selection Procedure:
Round 1 - OT
Round 2 - Technical interview (2 rounds)
Description of Online test:
OT - MCQs, 2 coding questions
MCQs were asked from SQL queries, DBMS and OOPS
2 coding questions were from sliding window concept
Description of Technical Interview:
Round 1 - Coding, SQL queries
Q - Design a data structure to return the most recent and most used element from a data buffer, insert and delete operation?
Q - Design a data structure to implement lift operation? Input will be given as an array of floor numbers.
Q - Write an SQL query to display posts of a given user from a social media database?
Q - Write an SQL query to get the number of likes of a given post?
Round 2 - Projects, SQL
The interviewer stressed on the SQL project. We have to explain the schema and queries clearly.
Q - Design schema for e-commerce website? And some queries were asked?
Q - Write c++ code to implement SELECT query and what is the efficient data structure for this particular application?
Description of HR Round:
Preparation Strategy:
Resources:
DSA
Practice - leetcode, gfg sde sheet
Resources - Aditya Verma, striver youtube playlists
DBMS
Practice - leetcode 50 SQL
Resources - Sanchit Jain, giraffe academy youtube
Oops - javapoint
Additional info for our viewers: