i
Flipkart
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Design a datawarehouse for an e-commerce platform to store buy and sell transactions.
Create separate tables for customers, products, transactions, and orders.
Use a star schema with a central fact table for transactions and dimension tables for customers, products, and time.
Include columns for transaction ID, customer ID, product ID, quantity, price, timestamp, etc.
Implement data normalization to reduce redundancy and i...
I applied via Walk-in and was interviewed in Sep 2020. There was 1 interview round.
I appeared for an interview before Nov 2019.
I applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.
I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.
I applied via Walk-in and was interviewed before Jul 2020. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.
I applied via LinkedIn and was interviewed before Feb 2023. There were 4 interview rounds.
Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
It was basic MCQ related to Javascript
Basic Apititude Questions
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP B
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
Row level filters are used to filter individual rows of data before any aggregations are performed.
Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.
Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Executive
2.7k
salaries
| ₹2 L/yr - ₹9 L/yr |
Team Lead
1.8k
salaries
| ₹1.2 L/yr - ₹10 L/yr |
Operations Executive
1.8k
salaries
| ₹1.2 L/yr - ₹6.3 L/yr |
Assistant Manager
1.6k
salaries
| ₹6 L/yr - ₹22 L/yr |
Data Entry Operator
1.5k
salaries
| ₹0.4 L/yr - ₹4 L/yr |
Amazon
Myntra
Snapdeal
Meesho