Round 1
Questions:
- Gil, Shallow copy, deep copy, multithreading in Python, system design, tiny URL shortening, Python internals.
- gRPC vs RPC vs REST.
- Authentication vs authorization (RBAC).
- Encryption vs hashing.
- File SHA1 sum.
- Argon hash.
- Cookies? How to set etc. in a web browser.
- JWT token.
- System design (R2).
- Flattening the JSON (R3).
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 2
Questions:
- Algorithm questions - Variation of https://leetcode.com/problems/two-sum/description/.
- Doubly Linked List application.
- Explain the 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 types?
- What are different types of joins in SQL?
- Cross join vs self join.
- ACID properties.
- SQL vs NoSQL.
- Normalization and its types.
- Why do we need denormalization?
- Process and threads.
- Multitasking vs Multiprogramming.
- OSI model.
- TCP/IP model.
- DNS server.
- Puzzle.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Round 3 (50 min Hiring Manager Interview)
Questions:
- Detailed questions from projects.
- What is authentication and how will you implement it?
- Explain lifecycle methods and hooks in React.js.
- Explain CSS properties and box model.
- What is middleware, views in Django?
- HTTP request methods.
- What are cookies?
- What happens when you search anything on the browser? (Backend process).
- Design a database schema for a vehicle distribution system. (In-depth discussion).
- Algorithm Question - Find all the anagram pairs in the given set of strings. (Optimized solution was required).
- Few HR questions.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.
Additional Topics Discussed
- Web Concepts - REST API, Request/Response Cycle.
- Servers - Web Servers, App Server.
- HTTP Methods - frameworks - FastAPI/SanicAPI (Basics).
- Python: Data Types, asyncio library, Async/Await (Go through examples and differences in 100 APIs with and without async/await).
- GIL.
- Aiohttp.
- Caching - Redis/CDN, Read through, Write through.
- Database: Schema Design (e.g., Parking [LLD], Booking System [LLD]), Indexing, Having/Group by.
- Generator, decorator, GIL, middleware, indexing, async/await, REST API, second highest salary in SQL, data partitioning.
- Can we write data in a GET API? Answer is yes. The GET method itself is nothing; it’s just a convention. The API will function as per the code written.
- Disadvantage of indexing.
- Suppose you want to remove try and catch from your APIs and still want to use try and catch. What you can do? Answer is to use middleware.
Candidate's Approach
No approach provided.
Interviewer's Feedback
No feedback provided.