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 applied via Walk-in and was interviewed before May 2020. There were 3 interview rounds.
I appeared for an interview before Nov 2019.
Create a pivot table and sort the data in ascending order.
To create a pivot table, select the data range and go to the 'Insert' tab in Excel.
Choose 'PivotTable' and select the location for the pivot table.
Drag the desired fields to the 'Rows' and 'Values' areas.
To sort the data in ascending order, click on the drop-down arrow next to the field name in the pivot table and select 'Sort A to Z'.
Using lookup with product-based data to find the needed data.
Use a lookup function like VLOOKUP or INDEX/MATCH to search for the needed data
Identify the key or unique identifier to match the data
Specify the range or table where the data is located
Retrieve the desired data based on the lookup value
posted on 9 Nov 2024
I applied via LinkedIn and was interviewed before Nov 2023. There were 2 interview rounds.
Basic questions based on Sql
I applied via Company Website and was interviewed in Jun 2023. There were 3 interview rounds.
Myathari Manikyam I'm from Algole mandal Zaheerabad district Sangareddy
I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.
I applied via Company Website and was interviewed in Oct 2020. There was 1 interview round.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Executive
2.9k
salaries
| ₹1.8 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 - ₹21 L/yr |
Executive
1.3k
salaries
| ₹1.2 L/yr - ₹7 L/yr |
Amazon
Myntra
Snapdeal
Meesho