Filter interviews by
I was interviewed in Jan 2025.
20 Questions in 20 min
Q1. To measure exactly 9 minutes using the 4-minute and 7-minute sand timers, follow these steps:
1. Start both the 4-minute and 7-minute timers at the same time.
2. When the 4-minute timer runs out, flip it immediately. At this point, 4 minutes have passed, and there are 3 minutes left on the 7-minute timer.
3. When the 7-minute timer runs out, 3 minutes have passed since you flipped the 4-minute timer, totaling 7 minutes. At this point, the 4-minute timer has been running for 3 minutes (1 minute left).
4. When the 4-minute timer runs out again (after 1 more minute), a total of 8 minutes has passed.
5. Finally, flip the 4-minute timer one last time. Wait for 1 more minute, which will give you a total of 9 minutes.
Q2. The SQL query provided will select all customers who do not have any orders. It retrieves customer IDs from the `Customers` table where the `customer_id` is not present in the `Orders` table.
Q3. The first SQL query retrieves the second oldest customer from the `Customers` table by selecting their `first_name` and `age`, ordering the results by age in descending order, and skipping the oldest customer with an offset of 1.
The second SQL query counts how many orders each customer has placed and selects customers who have placed more than one order, grouping the results by `customer_id` and including their `first_name`.
I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
List is mutable, tuple is immutable in Python.
List can be modified after creation, tuple cannot be modified
List uses square brackets [], tuple uses parentheses ()
List is used for collections of items that may need to be changed, tuple is used for fixed collections
Use dropDuplicates() function in Spark to remove duplicates from a DataFrame.
Use dropDuplicates() function on the DataFrame to remove duplicates based on all columns
Specify columns to check for duplicates by passing them as arguments to dropDuplicates() function
Example: df.dropDuplicates() or df.dropDuplicates(['col1', 'col2'])
I was interviewed in Mar 2017.
I believe the recruiting process is thorough and well-organized.
The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.
They have a clear timeline for the hiring process and keep candidates informed of their progress.
Feedback is provided to candidates after interviews to help them improve for future opportunities.
I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.
It was a 3 hour test with 144 questions
I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.
Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question
Easy
50% went to next round
UNION combines and removes duplicates, UNION ALL combines without removing duplicates.
UNION merges the results of two or more SELECT statements and removes duplicates.
UNION ALL merges the results of two or more SELECT statements without removing duplicates.
UNION is slower as it has to remove duplicates, while UNION ALL is faster.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column...
SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
SELECT: retrieves data from a database
INSERT: adds new records to a table
UPDATE: modifies existing records in a table
DELETE: removes records from a table
CREATE: creates a new table, view, or index
DROP: deletes a table or index
I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.
Online platform,
SQL coding
I applied via Referral and was interviewed in Aug 2022. There were 4 interview rounds.
Most questions were based on profit/loss and coding Questions are simple
Gave us topic on how education is important in our life
based on 3 interviews
Interview experience
Data Scientist
32
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate Consultant
8
salaries
| ₹0 L/yr - ₹0 L/yr |
Machine Learning Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics