I applied online. I interviewed at W Energy Software (Bengaluru) in Apr 2023
Interview
The screening started with aptitude test and then 3 rounds of interviews which was quite straightforward, with a focus on my projects, internships, and some academic technical and managerial questions.
Interview questions [1]
Question 1
What is the difference between Clustered and Non-clustered index?
What is a Subquery? What are its types?
The technical round was mainly based on coding questions. During the interview round, they asked me about both theoretical concepts and practical applications. The overall experience was average difficulty level.
Interview questions [1]
Question 1
How to change a table name in SQL?
How to create a database in SQL?
How can I see all tables in SQL?
Very straight forward. First round was the initial coding test with all technicality followed by Hiring manager round interview, CTO round and HR director round. Overall, each process took approximately 30 mins.
Interview questions [1]
Question 1
What are the subsets of SQL?
What is a UNIQUE constraint?
I applied online. I interviewed at W Energy Software (Bengaluru) in Sept 2023
Interview
During the interview process, I had to answer 20 questions (10 verbal and 10 quantitative) in 35 minutes. This was called an aptitude test. After that, on each given dates, I engaged in discussions with various key personnel, including the hiring manager for 30-45 minutes), the Chief Technology Officer (CTO) for 30-45 minutes, and finally the HR round for 30 minutes).
Interview questions [1]
Question 1
What are the NVL and the NVL2 functions in SQL? How do they differ?
What is the difference between the WHERE and HAVING clauses?
