Tip 1 : Do easy and a bit if medium leetcode and start applying. Make sure one question is never failed twice. (lazy advice)
Do top 150 leetcode questions for preparing DSA
Tip 2 : for high level design read System Design by Alex Xu, in your free time start reading Designing data intensive applications
Tip 3 : Prepare to present your work really well. Think of all the questions interviewer can ask and present clearly without blaoting.
Tip 1 : Keep it under one page if exp is under 5 years.
Tip 2 : Add impact using numbers. Eg Dollars saved/ earned, users gained or execution time improvements etc
Machine coding round taken at 9am in morning.
Two interviewers, very calm and nice to me making me comfortable.
Shared my screen and coded on IDE in Java.
First 15 minutes Discussion on design and then coding
All my features ran and i used all of time.
Design a SQL like database with basic capabilities of Insertion deletion and search. Column based constraints also asked.
Started with using maps.
Gave a columinar database design and not a row based(standard) design.
Created classes of entities, a service class for execution methods.
Used column type as string and maintained an allowed types enum and put validations based on that. Used generics.
Asked about my projects and asked questions based on that.
Asked about design decisions, went in deep of how queus are used to make things async, Relational vs Non relational dbs
Explain how will you scale these services.
Follow up: Where will you use a queue.
Internally how queues work?
Tip 1 : Read up Designing data intensive applications
Tip 2 : Basic running parts: Load balancer, consistent hashing, Relational vs non relational databases
Tip 3 : Remember EVERYTHING has a trade off. Be ready to discuss this
Hiring Manager round.
Just discuss my previous projects
Discussed in detail where things went wrong, how coukd they have been handled well. Other design discussions
Tip 1 : Have Clarity about what you have worked on
Tip 2 : Think of various combinations how things could have been done better, accept your shortcomings

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What is recursion?