Zenon Analytics Interview Experience for SDE (On-Campus)

There were 3 rounds

Round 1

• Questions on SQL, No SQL, when they are used in different conditions
• MongoDB joins, find and update functions, SQL Query-related questions
• Message Queue, what it is, and when it is used
• DSA Question same as https://www.geeksforgeeks.org/dsa/program-to-convert-a-given-number-to-words-set-2/
• Questions on OOPS - Polymorphism, why we need run time polymorphism

Round 2

• DSA Question - Given two sorted arrays print all the operations that are needed to convert array 1 to array 2. We can perform Add or remove of numbers in array 1. 
• Tree traversals
• Find the valid BST - First asked using inorder traversal and a separated array and then asked without using a separate array.
• Design a database for students and their branch in a college - write the query to find the number of students in each branch.
• What is the order in which all SQL commands are executed?

Round 3 was HR