Filter interviews by
I applied via Walk-in and was interviewed before May 2023. There were 2 interview rounds.
Calculate rolling average for order amount for merchants
Calculate the average order amount for each merchant over a specific time period
Update the average as new orders come in, dropping the oldest order amount from the calculation
Example: Merchant A had orders of $100, $150, $200 in the last 3 days. Rolling average would be ($100 + $150 + $200) / 3 = $150
SQL, Python, Case Studies, Window Functions
Top trending discussions
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
I applied via LinkedIn and was interviewed in May 2024. There was 1 interview round.
I applied via Naukri.com
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
2 SQL questions asked
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
I applied via Job Portal
SQL and Python data analysis questions
Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.
Use string matching techniques like exact match, partial match, or fuzzy matching.
Apply data cleaning and preprocessing techniques to standardize the data before matching.
Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.
Consider using database join...
Interview experience
Delivery Boy
27
salaries
| ₹0.8 L/yr - ₹3.5 L/yr |
Key Account Manager
21
salaries
| ₹3.2 L/yr - ₹7.1 L/yr |
Driver
9
salaries
| ₹1 L/yr - ₹6 L/yr |
Software Engineer
8
salaries
| ₹30 L/yr - ₹50 L/yr |
Operations Associate
7
salaries
| ₹2.1 L/yr - ₹3.5 L/yr |
Zomato
Swiggy
FoodPanda
Faasos Food Services