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
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 LinkedIn and was interviewed in Dec 2020. There were 4 interview rounds.
An E-Commerce system can be designed by identifying user requirements, selecting appropriate technologies, and implementing secure payment and shipping methods.
Identify user requirements and create user stories
Select appropriate technologies for front-end, back-end, and database
Implement secure payment and shipping methods
Design a user-friendly interface with easy navigation
Ensure scalability and performance of the sys...
I appeared for an interview before Sep 2020.
Round duration - 60 minutes
Round difficulty - Medium
The platform was HackerEarth time duration was 1 hour.
1.) 25 MCQs (Both Easy and Gate Level Based)
2.) 1 Coding Question, that needs to be solved in O(logn) time. Program for Fibonacci numbers. The basic idea behind that question is we need to crack the pattern and then based on constraints we need to solve it.
Given an integer 'N', the task is to compute the N'th Fibonacci number using matrix exponentiation. Implement and return the Fibonacci value for the provided 'N'.
Use matrix exponentiation to efficiently compute the Nth Fibonacci number modulo 10^9 + 7.
Implement matrix exponentiation to calculate Fibonacci numbers efficiently.
Use the formula F(n) = F(n-1) + F(n-2) with initial values F(1) = F(2) = 1.
Return the result modulo 10^9 + 7 to handle large Fibonacci numbers.
Optimize the solution to achieve better than O(N) time complexity.
Round duration - 40 minutes
Round difficulty - Medium
It was a technical round. The platform was Zoom time duration was 40 mins. Started with Tell me something about yourself.
Determine whether two given strings, A
and B
, both of length N
, are similar by returning a 1 if they are, otherwise return a 0.
String A
is similar to stri...
Determine if two strings are similar based on given conditions.
Check if the strings are equal first.
Then check if the strings can be divided into two halves with similar patterns.
Return 1 if the strings are similar, 0 otherwise.
Round duration - 45 Minutes
Round difficulty - Medium
The platform was Zoom time duration was 1 hour 45 mins. Started with Tell me something about yourself. I told them, that I like solving algorithms, so she was like let’s start with trees then.
Round duration - 30 minutes
Round difficulty - Medium
This was a Hiring Manager Round. The platform was Zoom time duration was 30 mins. Started with Tell me something about yourself.
Round duration - 20 minutes
Round difficulty - Easy
The platform was Zoom time duration was 20 mins. Asked me to give my introduction.
Tip 1 : Don't stick to a single topic too much. Cover all and prepare short notes for all the topics so it will be easier for revision.
Tip 2 : Do projects so that they will be an added weightage.
Tip 3 : Practice a minimum of 100 questions on that particular topic so that it will be easy to crack within no time.
Tip 1 : Projects add good weight to the resume. So the interviewer asks the questions based on that.
Tip 2 : Resume should be genuine. You have to be confident of whatever is written in your resume
I applied via Naukri.com and was interviewed before Jan 2021. There were 5 interview rounds.
Working code with edge cases is code that has been tested with extreme inputs to ensure it functions correctly.
Edge cases are inputs that are unlikely to occur but can cause unexpected behavior if not handled properly.
Examples of edge cases include empty inputs, null values, and inputs at the limits of the data type's range.
Working code with edge cases should be thoroughly tested to ensure it functions correctly in all
posted on 22 Mar 2015
I appeared for an interview 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 appeared for an interview 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.
based on 1 interview
Interview experience
based on 2 reviews
Rating in categories
Senior Software Engineer
1.1k
salaries
| ₹12 L/yr - ₹39.7 L/yr |
Software Engineer
1.1k
salaries
| ₹8 L/yr - ₹30.4 L/yr |
Senior Analyst
281
salaries
| ₹7 L/yr - ₹25.1 L/yr |
Analyst
229
salaries
| ₹5 L/yr - ₹17 L/yr |
Lead Software Engineer
173
salaries
| ₹18 L/yr - ₹60 L/yr |
Reliance Retail
Walmart
Landmark Group
Reliance Trends