i
Porter
Filter interviews by
Clear (1)
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
Sql, python, stats, dashboarding
Guesstimates, Optimisation, RCA
I applied via Instahyre and was interviewed before Dec 2020. There were 4 interview rounds.
SQL queries for Business Analyst role
SELECT * FROM table_name;
SELECT column_name FROM table_name WHERE condition;
SELECT COUNT(*) FROM table_name;
SELECT AVG(column_name) FROM table_name;
SELECT MAX(column_name) FROM table_name;
SELECT MIN(column_name) FROM table_name;
SELECT column_name1, column_name2 FROM table_name1 JOIN table_name2 ON table_name1.column_name = table_name2.column_name;
SELECT column_name1, COUNT(column_na
Top trending discussions
I was interviewed before Apr 2021.
Round duration - 60 minutes
Round difficulty - Easy
In the interview I was asked few puzzles and few coding problems.
In the coding questions the interviewers did not ask me to write down the complete codes of the problems, they only asked me to suggest some suitable algorithms.
Given a positive integer N
, find the total number of '1's in the binary representation of all the numbers from 1 to N
.
You should return the result modulo 109+7 as the co...
Count the total number of set bits in the binary representation of numbers from 1 to N, modulo 10^9+7.
Iterate through numbers from 1 to N and count the set bits in their binary representation
Use bitwise operations to count set bits efficiently
Return the total count modulo 10^9+7 as the result
Round duration - 45 minutes
Round difficulty - Easy
In second round of interview I was asked some hardcore programming questions on data structures since I wrote it as my area of interest.
I was asked some puzzles as well.
Given two sorted integer arrays ARR1
and ARR2
of size M and N, respectively, merge them into ARR1
as one sorted array. Assume that ARR1
has a size of M + N to hol...
Merge two sorted arrays into one sorted array in place.
Iterate from the end of both arrays and compare elements to merge in place
Use two pointers to keep track of the current position in both arrays
Handle cases where one array is fully merged before the other
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 chose Snapdeal over Flipkart because of its unique business model and growth potential.
Snapdeal offers a unique marketplace model that allows sellers to directly connect with customers, giving them more control over their business.
Snapdeal has shown consistent growth and has a strong presence in tier 2 and tier 3 cities, which presents a huge untapped market.
Snapdeal's focus on customer satisfaction and providing a p...
Short term aim is to excel in my role as a business analyst and contribute to the success of the company. Long term aim is to become a senior business analyst and eventually a business consultant.
Short term aim: Excel in my role as a business analyst
Short term aim: Contribute to the success of the company
Long term aim: Become a senior business analyst
Long term aim: Transition into a business consultant role
The number of sparrows in IIT KGP is unknown.
The exact number of sparrows in IIT KGP is not available.
There is no specific data on the population of sparrows in IIT KGP.
The number of sparrows in IIT KGP is not documented.
No information is available regarding the count of sparrows in IIT KGP.
The road length of Ahmedabad is approximately 2,500 kilometers.
Ahmedabad has a well-developed road network.
The road length includes both national highways and city roads.
The road length is constantly expanding due to urban development and infrastructure projects.
Major roads in Ahmedabad include the SG Highway, Ashram Road, and C.G. Road.
Tree traversals are methods of visiting all nodes in a tree data structure.
There are three types of tree traversals: in-order, pre-order, and post-order.
In-order traversal visits the left subtree, then the root, then the right subtree.
Pre-order traversal visits the root, then the left subtree, then the right subtree.
Post-order traversal visits the left subtree, then the right subtree, then the root.
Tree traversals are ...
Pre-order and post-order are traversal methods used in binary trees.
Pre-order: visit root, left subtree, right subtree
Post-order: visit left subtree, right subtree, root
Used to traverse binary trees and perform operations on nodes
Example: Pre-order traversal of binary tree: A, B, D, E, C, F, G
Example: Post-order traversal of binary tree: D, E, B, F, G, C, A
I applied via Naukri.com and was interviewed before Aug 2020. There was 1 interview round.
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
based on 2 interviews
Interview experience
based on 4 reviews
Rating in categories
Business Associate
260
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Executive
223
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
96
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Business Associate
78
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Manager
73
salaries
| ₹0 L/yr - ₹0 L/yr |
Dunzo
Flipkart
Amazon
Snapdeal