Filter interviews by
I applied via Referral and was interviewed in May 2024. There were 3 interview rounds.
Use SQL query to join tables on sales and survey
Use JOIN keyword to combine tables based on a common column
Specify the columns to select from each table
Example: SELECT * FROM sales JOIN survey ON sales.id = survey.sales_id
The order of execution of a SQL code is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM clause is executed first to retrieve data from tables
WHERE clause filters the data based on specified conditions
GROUP BY clause groups the data based on specified columns
HAVING clause filters the grouped data
SELECT clause selects the columns to display
ORDER BY clause sorts the final result set
Audience selection, campaign effectiveness and different KPIs for campaign measurement
Top trending discussions
I applied via Naukri.com and was interviewed in Aug 2024. There were 5 interview rounds.
I have a strong background in leading teams, collaborating with stakeholders, and managing projects effectively.
Led cross-functional teams to successfully deliver projects on time and within budget
Collaborated with stakeholders to gather requirements and ensure project alignment with business goals
Utilized project management tools such as Jira and Trello to track progress and communicate updates
Facilitated team meeting...
I address tough stakeholders by actively listening, understanding their concerns, finding common ground, and maintaining professionalism.
Actively listen to their concerns and perspectives
Seek to understand their motivations and priorities
Find common ground and areas of agreement
Maintain professionalism and remain calm in challenging situations
I was interviewed before Dec 2020.
Round duration - 60 Minutes
Round difficulty - Medium
There were 2 coding questions given in this round. One was related to Dynamic Programming and the second one was related to Recursion and Number Theory.
Mr. X is a professional robber with a plan to rob houses arranged in a circular street. Each house has a certain amount of money hidden, separated by a security system that ...
House Robber problem where a robber wants to maximize stolen money without robbing adjacent houses in a circular street.
Use dynamic programming to keep track of maximum stolen money at each house.
Consider two cases: either rob the current house and skip the next, or skip the current house.
Handle circular arrangement by considering the first and last houses separately.
Example: For arr[] = {2, 3, 2}, the output is 3. Rob...
Calculate the Nth term in the Fibonacci sequence, where the sequence is defined as follows: F(n) = F(n-1) + F(n-2)
, with initial conditions F(1) = F(2) = 1
.
Calculate the Nth Fibonacci number efficiently using dynamic programming.
Use dynamic programming to store and reuse previously calculated Fibonacci numbers.
Start with base cases F(1) and F(2) as 1, then calculate subsequent Fibonacci numbers.
Optimize the solution to avoid redundant calculations by storing intermediate results.
Time complexity can be reduced to O(N) using dynamic programming.
Example: For N = 5, the 5th F
Round duration - 50 Minutes
Round difficulty - Medium
Standard Data Structures and Algorithms round where I was given 2 questions to solve , one was from Linked List and the other was related to Priority Queue / Quick Sort .
You are provided with two linked lists, L1
and L2
, both sorted in ascending order. Generate a new linked list containing elements that exist in both linked l...
Given two sorted linked lists, find the intersection of elements in both lists and return a new sorted linked list.
Traverse both linked lists simultaneously to find common elements
Create a new linked list to store the intersecting elements
Ensure the final linked list is sorted in ascending order
Handle cases where there are no common elements between the lists
Ninja enjoys working with numbers, and Alice challenges him to find the Kth largest value from a given list of numbers.
The first line contains an integer 'T...
Find the Kth largest element in a given list of numbers.
Sort the array in descending order.
Return the Kth element from the sorted array.
Handle multiple test cases efficiently.
Round duration - 50 Minutes
Round difficulty - Easy
This round majorly focused on Real life appications of Data Structures and also revolved around Object Oriented Programming Style of writing code .
Design a data structure that supports four operations: insert an element, remove an element, search for an element, and get a random element. E...
Design a data structure with insert, delete, search, and getRandom operations, all in constant time.
Use a combination of HashMap and ArrayList to achieve constant time operations.
For insert operation, add the element to the ArrayList and store its index in the HashMap.
For delete operation, swap the element to be deleted with the last element in the ArrayList, update the index in the HashMap, and then remove the last el...
Design a data structure for a Least Recently Used (LRU) cache that supports the following operations:
1. get(key)
- Return the value of the key if it exists in the cache; otherw...
Design a Least Recently Used (LRU) cache data structure that supports get and put operations with capacity constraint.
Implement a doubly linked list to maintain the order of keys based on their recent usage.
Use a hashmap to store key-value pairs for quick access.
When capacity is reached, evict the least recently used item before inserting a new item.
Update the position of a key in the linked list whenever it is accesse
Round duration - 45 Minutes
Round difficulty - Medium
This round was inclined towards some Low Level Design Principles and some concepts from Java .
Design a Railway Reservation System
Create a database to store train schedules, seat availability, and passenger information
Implement a user interface for users to search for trains, book tickets, and view their reservations
Include features like seat selection, payment processing, and ticket confirmation
Handle scenarios like waitlisting, cancellations, and refunds
Ensure data security and privacy of passenger information
Java is platform-independent because the code is compiled into bytecode that can run on any platform with a JVM, which is platform-dependent due to its reliance on the underlying hardware and operating system.
Java code is compiled into bytecode, which can run on any platform with a JVM.
JVM acts as an interpreter that translates bytecode into machine code specific to the underlying hardware and operating system.
The JVM ...
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I was interviewed before Dec 2020.
Round duration - 90 Minutes
Round difficulty - Medium
This Round was DS and Algo round and it started with formal introduction, followed by 2 problems. We first dicussed the approach the time complexity and proper code covering all cases.
You are given a bag of capacity 'W' kg and a list 'cost' of costs for packets of oranges with different weights. Each element at the i-th position in the list...
Find the minimum cost to buy a specific weight of oranges using given cost list.
Iterate through the cost list and find the minimum cost to achieve the desired weight
Keep track of the minimum cost while considering available packet weights
Return -1 if it is not possible to buy exactly W kg of oranges
Given a binary tree where each node contains an integer value, and a value 'K', your task is to find all the paths in the binary tree such that the sum of the node values in ...
Find all paths in a binary tree where the sum of node values equals a given value 'K'.
Traverse the binary tree using DFS and keep track of the current path and its sum.
At each node, check if the current sum equals 'K' and add the path to the result if true.
Continue traversal to the left and right child nodes recursively.
Return the list of paths that sum up to 'K'.
Round duration - 40 Minutes
Round difficulty - Medium
This round majorly focused on puzzles and some questions revolving around Computer Networks and the projects in my resume .
Use two wires of different lengths to measure a specific amount of time by burning them simultaneously.
Burn both wires at the same time, one wire will burn faster than the other.
Measure the time it takes for the faster burning wire to completely burn.
Calculate the specific amount of time by using the ratio of the lengths of the two wires.
Round duration - 30 Minutes
Round difficulty - Easy
This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Naukri.com and was interviewed in May 2019. There were 5 interview rounds.
Key metrics for tracking growth in brick and mortar business.
Sales revenue
Customer footfall
Average transaction value
Customer retention rate
Inventory turnover rate
Gross profit margin
Net promoter score
Employee productivity
Marketing ROI
KPIs are interrelated in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.
KPIs are Key Performance Indicators that measure the success of a business or project.
KPIs can be organized in a tree-like structure, with higher-level KPIs being influenced by lower-level ones.
For example, a company's overall revenue might be a high-level KPI, with lower-level KPIs such as sales revenue and cust...
Advertising a new store opening in a location
Identify target audience and their preferences
Create a catchy slogan and design attractive visuals
Utilize social media platforms and local newspapers for promotion
Offer discounts and promotions to attract customers
Organize a grand opening event to create buzz and excitement
Logistic regression is a statistical method used to analyze and model the relationship between a dependent variable and one or more independent variables.
It is a type of regression analysis used for predicting binary outcomes
It uses a logistic function to model the probability of the dependent variable
It is commonly used in fields such as healthcare, finance, and marketing
Example: Predicting whether a customer will buy...
I applied via Campus Placement and was interviewed before Jun 2020. There were 5 interview rounds.
Logistic regression is a statistical method used to analyze and model the relationship between a binary dependent variable and one or more independent variables.
It is a type of regression analysis used for predicting binary outcomes
It uses a logistic function to model the probability of the dependent variable
It is commonly used in fields such as healthcare, finance, and marketing
Example: Predicting whether a customer w...
An unique id for a massive parallel system can be generated using a combination of timestamp, machine id and a random number.
Use a timestamp to ensure uniqueness
Include a machine id to avoid collisions in a distributed system
Add a random number to further increase uniqueness
Consider using a UUID (Universally Unique Identifier) for simplicity
Ensure the id generation algorithm is thread-safe
A parking lot system that manages parking spots and vehicles.
Create a class for parking lot with attributes like total number of spots, available spots, etc.
Create a class for vehicle with attributes like license plate number, type, etc.
Implement methods for parking a vehicle, removing a vehicle, and checking availability of spots.
Use data structures like arrays and maps to store and retrieve information.
Consider imple
I applied via Naukri.com and was interviewed in Mar 2020. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Software Engineer
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
962
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
231
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
221
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Software Engineer
164
salaries
| ₹0 L/yr - ₹0 L/yr |
Home Depot
Ace Hardware
Menards
Sherwin Williams Paints