i
FNZ
Filter interviews by
Clear (1)
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
Codility Test General C# and SQL
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu
Top trending discussions
I applied via Approached by Company and was interviewed in Jul 2023. There were 3 interview rounds.
Arrays, LinkedList basic dsa questions
To find the 2nd largest node in a binary tree, we can perform an in-order traversal and keep track of the two largest nodes.
Perform an in-order traversal of the binary tree
Keep track of the two largest nodes encountered
Return the second largest node when traversal is complete
I applied via Campus Placement and was interviewed before Jan 2023. There were 2 interview rounds.
Easy coding question generally A, B level question of codeforces
JavaScript questions
I applied via Approached by company and was interviewed in Dec 2021. There were 4 interview rounds.
2 questions. 1 was basic level. 2 was of medium level.
Find first missing positive number in an array in O(n) time and O(1) space.
Traverse the array and mark the presence of each positive integer by changing the sign of the corresponding index.
Traverse the array again and return the index of the first positive integer.
If all integers are present, return the length of the array + 1.
Example: [3, 4, -1, 1] => mark 3rd and 4th index as negative => return 2.
Example: [1, 2, 0] =...
Given an integer, print the relevant column name in an excel sheet.
Create a string array of alphabets from A to Z
Use modulo operator to get remainder and divide by 26 to get quotient
Append the corresponding alphabet to the result string
Reverse the result string
I applied via Campus Placement and was interviewed before Feb 2023. There were 2 interview rounds.
Topics:-
Duration-1.5 hours
Kadane's Algorithm, Even Numbers at even index & odd at odd index, print out the second highest node of the tree
ZigZag tree traversal is a method to traverse a binary tree in a zigzag pattern.
In ZigZag tree traversal, we visit the nodes of a binary tree in a zigzag pattern, moving from left to right and then right to left.
We can use a stack or a queue to implement ZigZag tree traversal.
The algorithm involves maintaining two stacks or two queues to keep track of the nodes at each level.
We start with the root node and alternate be...
Maths,quant for 1 hour duration
Arrays, strings, linked list, palindrome
DS/ALGO and problem-solving was asked in round one
Seeking new challenges and growth opportunities in a different environment.
Desire to work on new technologies and projects
Opportunity for career advancement
Seeking a better work-life balance
Interested in a different company culture or team dynamic
based on 1 interview
Interview experience
Test Analyst
117
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst Developer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Quality Analyst
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Test Manager
5
salaries
| ₹0 L/yr - ₹0 L/yr |
Zerodha
Upstox
Groww
Paytm Money