Swiggy Interview Questions, Process, and Tips

Q1. About yourself. How many years experience do you have ?
Add your answer
Q2. How many experience for fleet management?
Ans. 
Minimum of 3-5 years of experience in fleet management is typically required.
• Minimum of 3-5 years of experience is usually required for fleet management roles

• Experience in managing a diverse fleet of vehicles is preferred

• Knowledge of maintenance schedules, fuel management, and regulatory compliance is important

• Experience with fleet management software and telematics systems is a plus
Answered by AI
Add your answer

Q1. About fleet management, driver management
Add your answer
Q2. If the driver has been strike what you can do?
Ans. 
If a driver is on strike, it is important to address the situation promptly and effectively to minimize disruptions to fleet operations.
• Communicate with the driver to understand the reasons for the strike

• Evaluate the impact of the strike on fleet operations and plan accordingly

• Consider alternative solutions such as hiring temporary drivers or redistributing routes

• Negotiate with the driver or their representatives to re...read more
Answered by AI
Add your answer

The questions were related to Data Interpretation/Logical Reasoning and general aptitude.

Q1. Questions related to SQL queries, window functions, 2-3 sql queries had to write
Add your answer
Q2. Statistics related questions, left skewed, right skewed etc.
Add your answer
Q3. Questions related to basics of ML
Add your answer

A company wants to open a new store, what would the factors you would consider.
A ride sharing company wants dynamic pricing in place of flat pricing, what factors you would consider.

Q1. General Project and HR related questions.
Add your answer
Q2. Things you want to improve in swiggy and metrics to measure and evaluate them.
Add your answer

Q1. Rank Function Application in Google Sheet?
Ans. 
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]).
Answered by AI
Add your answer
Q2. Joins From SQL?
Ans. 
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;
Answered by AI
Add your answer
Q3. Order Of query execution in SQL?
Ans. 
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
Answered by AI
Add your answer
Q4. Write a query to find out students has greater than 80 marks and from English subject?
Ans. 
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
Answered by AI
Add your answer

Q1. When we use having clause ?
Ans. 
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...read more
Answered by AI
Add your answer
Q2. Aggregate Function Application?
Ans. 
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.
Answered by AI
Add your answer
Q3. Group by and order By?
Add your answer
Q4. Write a query employes join between such dates?
Ans. 
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'
Answered by AI
Add your answer

8 SQl questions of easy, medium and hard diffiulty

Q1. SQL Question on join
Add your answer
Q2. SQL question on window funtions
Add your answer

Q1. Your self, and overall experience related questions, last company JD and maintain last mile fleet .
Add your answer
Q2. Last Company Metrix and What's your responsibility their.
Add your answer

There were 2 questions in coding one with array and in string releated

Q1. About Selenium questions
Add your answer
Q2. Other basic questions related to testing
Add your answer
Q3. Management related question
Add your answer

Q1. One program to solve
Add your answer
Q2. Other questions in selenium
Add your answer