i
Dunzo
Filter interviews by
Be the first one to contribute and help others!
I applied via Recruitment Consultant and was interviewed before Dec 2019. There were 3 interview rounds.
Swiggy is an Indian food delivery company that operates through a website and mobile app.
Swiggy was founded in 2014 and is headquartered in Bangalore, India.
It partners with local restaurants to provide food delivery services to customers.
Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.
It has expanded to over 500 cities in India and has ov...
Define CTE and how it works
I applied via Walk-in and was interviewed in May 2023. There were 2 interview rounds.
Given a on spot question and we have to solve the problem. As i attended for MIS Job its in Excel. They have a set of questions in that question will be like basic to advanced formulas. We have to solve infront of Interviewer.
I applied via Walk-in and was interviewed in Jun 2023. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.
Rank function is used to determine the rank of a value in a list.
It can be used to rank values in ascending or descending order.
The syntax for the rank function is RANK(value, range, [is_ascending]).
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;
The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables from which data will be retrieved.
WHERE: Filters the rows based on specified conditions.
GROUP BY: Groups the rows based on specified columns.
HAVING: Filters the groups based on specified conditions.
SELECT: Retrieves the columns specified in the query.
ORDER BY: Sorts the result set based on specified column
Query to find students with over 80 marks in English subject
Use SELECT statement to retrieve data
Filter the results using WHERE clause for marks greater than 80
Include condition for English subject using AND operator
HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.
HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.
It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.
It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.
Example: SELECT department, AVG(salary) FR...
Aggregate functions are used to perform calculations on groups of rows in a table.
Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.
They are commonly used in SQL queries to summarize data.
For example, you can use SUM to calculate the total sales for a specific product.
Another example is using AVG to find the average salary of employees in a department.
Use a SQL query with JOIN to retrieve employees between specified dates.
Use the JOIN keyword to combine data from two tables
Specify the date range using the WHERE clause
Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'
Asking about ur self introduction and work experience
I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.
I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.
Company productivity can be advanced through marketing by increasing brand awareness, targeting the right audience, utilizing digital marketing strategies, and analyzing data for optimization.
Increase brand awareness through targeted advertising campaigns
Target the right audience through market research and segmentation
Utilize digital marketing strategies such as social media, email marketing, and SEO
Analyze data to op
I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.
I am a dedicated and hardworking individual with a passion for learning and growth.
I have a Bachelor's degree in Business Administration
I have 3 years of experience in marketing and sales
I am fluent in English, Spanish, and French
I have 5 years of experience working in marketing and sales roles at a Fortune 500 company.
Managed marketing campaigns and strategies to increase brand awareness
Developed sales tactics to drive revenue growth
Collaborated with cross-functional teams to achieve business objectives
I was responsible for managing the marketing campaigns and social media presence of the company.
Managed marketing campaigns to increase brand awareness
Handled social media accounts to engage with customers
Analyzed data to measure the effectiveness of marketing strategies
I handle customer calls by actively listening, empathizing with their concerns, and providing solutions in a professional and friendly manner.
Active listening to understand the customer's issue
Empathizing with the customer's concerns to show understanding
Providing solutions or assistance in a professional and friendly manner
Ensuring clear communication and follow-up if needed
Seeking new challenges and opportunities for growth.
Desire for career advancement
Seeking new challenges
Opportunity for professional growth
Company restructuring
Relocation
posted on 10 Apr 2024
I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.
Community Operations Specialist
116
salaries
| ₹2.6 L/yr - ₹4.3 L/yr |
Key Account Manager
106
salaries
| ₹4 L/yr - ₹12 L/yr |
Store Manager
104
salaries
| ₹3.8 L/yr - ₹7 L/yr |
Procurement Manager
104
salaries
| ₹3.5 L/yr - ₹7 L/yr |
Delivery Boy
91
salaries
| ₹0.5 L/yr - ₹4.5 L/yr |
Swiggy
Zepto
Porter
Rapido