Round 1
Online Assessment Test(45 min):
MCQ + Coding Problems(2 Coding)
Round 2 (1Hr F2F interview)
Algorithm questions - Variation of https://leetcode.com/problems/two-sum/description/
Doubly Linked List application
Explain 4 pillars of OOP
Difference between runtime and compile time polymorphism
SQL queries - using both subqueries and joins
Relationship between tables - one to one, many to many
What is indexing and its type?
What are different type of joins in SQL
Cross join vs self join
ACID properties
SQL vs NoSql
Normalization and its type
Why do we need denormalization?
Process and threads
Multitasking Vs Multiprogramming
OSI model
Tcp/IP model
DNS server
Puzzle
Round 3 ( 50 min Hiring manager Interview)
Detailed questions from projects.
What is authentication and how will you implement it?
Explain Life cycle methods and Hooks in React.js
Explain CSS properties and box model
What is middleware, views in Django?
HTTP request method
What are cookies?
What happens when you search anything on the browser? (Backend process)
Design a database schema for Vehicle distribution system. (In depth discussion)
Algorithm Ques - Find all the anagram pairs in the given set of strings. (Optimized solution was required)
Few HR questions
Verdict - Selected