Tip 1: Practice aptitude questions to clear the first round with good speed.
Tip 2: Engage in non-technical work, including managerial roles.
Tip 3: Strengthen your proficiency in SQL.
Tip 1: Communication and problem-solving attitude are a must.
Tip 2: Ensure your experience reflects an all-around skill set.
It was mcq round for aptitude and coding round post that. Proctored test in the day.
Mixtures and Allegations
Tip 1: Practice.
Tip 2: Prioritize speed.
Tip 3: Ensure accuracy.
1.SQL query code based on join and window function ranking.
2.How will you remove duplicates from the data at the customer id and order id level
There were 2 tables order and customer which I joined on the customer id. Then I applied window function partitioning with order id and customer id and applied rank=1.
We were given a topic and 5 minutes to think about it.
It was an HR cum fitment round, which included puzzles and guesstimates.
How many red cars are there in Delhi?
Tip 1: Explain your approach.
Tip 2: Use approximate numbers for easier calculation.
Tip 3: Consider various scenarios.
1.Why do you want to join us?
2.Why should we hire you?
Tip 1: Read about the company’s vision.
Tip 2: Leverage your strengths.
Tip 3: Align both.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
How do you remove whitespace from the start of a string?