Tip 1 : Focus on DS and Algorithms
Tip 2 : Focus on System Design
Tip 3 : Should be able to explain your previous company projects and current project in detail (technically)
Tip 1 : keep your resume short
Tip 2 : Mention about your projects and experience nicely
DS Algo and SQL questions
Input: 'list' = [1, 2, 3, 4], 'k' = 2
Output: 2 1 4 3
Explanation:
We have to reverse the given list 'k' at a time, which is 2 in this case. So we reverse the first 2 elements then the next 2 elements, giving us 2->1->4->3.
All the node values will be distinct.
First I made a reverse linkedList function
Then I made a recursive function which will split the linkedList into desired buckets and call the reverse functions on it.
Then you have play a little bit with pointers and adjust them to get desired output
Find the second largest quantity item from a table where item and quantity are present
Tip 1 : select * from table order by quantity desc offset 1 limit 1
Describe the project I put on in my resume
Tip 1 : you should be explain the project in detail
Tip 2 : you should be able to answer the question like why you used a particular DB or tech stack.
Tip 3 : You should have confidence and clarity in what you have done and why you have done
System Design Round
Design HLD and LLD for a authentication system which should be highly available and should be able to handle around 2 lakh requests. a minute.
Tip 1 : Should be good with fundamentals like LLD and HLD
Tip 2 : Ask questions like the scale of system, requirements, etc
Tip 3 : You should have a logical approach
It was a technical managerial round.
I was asked about my projects and some python django and react related questions (as I mentioned these in my resume)
Explain the architecture of the Questionnaire Manager (My previous company's project)
Tip 1 : You should know why you used the given tech stack and database
Tip 2 : You should be able to answer questions like why not to use other tech stack
Tip 3 : You should be able to explain your project nicely
Django ORM specific question
Explain select related and prefetch related queries in diango
Tip 1 : Just be good with the tech stack you mentioned in your resume
Tip 2 : it is a tech stack specific question so will differ based on resume.
Explain Tear down in Unit tests with an example
Tip 1 : it is a question related to fundamentals of unit tests
Tip 2 : it will differ based on your resume.
Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What does the SQL function NOW() return?