This included just technical questions. Some of them were coding challenge, some of them were scenario questions. There were a lot of questions. It spends almost one hour. For example about SQL question included - What is a subquery(and give an example) and an inline query
Tell me about your self .
- What is a view
- How do you add a column to a table
- What do you know about testing
- Have you heard of Agile methodology and SDLC
- Asked about a few window functions (rank(), dense_rank())
Interview questions [1]
Question 1
For example about SQL question included - What is a subquery(and give an example) and an inline query
- What are some aggregate functions
- Have you used any automation tools
- difference b/w delete, truncate, and drop
It’s goes well. Waiting for the update so hoping for good thing. Other than that everything good I felt. First round is Technical and followed by the manager round which is also quite good experience
Interview questions [1]
Question 1
Tell me about yourself ? What is your current project?
L3 interview:
Pretty inefficient process, with certain people having to wait 6+ hours, and I heard of one person who waited an entire day and had to come again the next day.
Interview itself was relatively standard,
stage 1: Asking leetcode mediums and expecting optimal solution, then moving to core cs concepts like oops and sql.
stage 2: Diving into projects, with questions on the tougher side, like specifics about the architecture of docker.
Interview questions [1]
Question 1
Sort an array containing elements from the set (0,1,2)
The interview was related to general software engineering questions. Design patters, unit and e2e testing, deplyment to cloud, frontend to backend comunication, team collaboration, requirements shaping, release process. The interview was conducted in a friendly manner.