Dhwani Rural Information Systems Data Analyst Interview Questions and Answers

Q1. How many swift cars in mumbai?
Ans. 
The exact number of Swift cars in Mumbai is not available, but it is a popular choice among car owners in the city.
• Swift cars are a common sight on the roads of Mumbai.

• Maruti Suzuki, the manufacturer of Swift cars, has a strong presence in the city.

• The number of Swift cars in Mumbai is constantly changing due to sales and purchases.

• One can see multiple Swift cars in popular areas like Bandra, Andheri, and South Mumbai.
Answered by AI
Add your answer

Reasoning and aptitude questions were asked

Q1. Interview was around python programming and team fitment
Add your answer

Easy and moderate level question

Given a relevant topic and discussion on it

Q1. Introducd yourself
Add your answer
Q2. Why do you want to join us
Add your answer

Intermediate SQL Topics - Window Function, Subquery, Joins

Tables:
registration (userid string, regdate date);
txn(txndate date, userid string, amt int, game string);

1. Write a query to get proportion of users who have played a game within 2 days of registration
2. Find the most money spent on a game for each user
3. Get the list of users who played poker but not ludo

Python, SQL questions were in the initial round of hiring process.

Q1. ML, DL & knowledge about Cloud were main focus of the interview.
Add your answer
Q2. Questions around your resume
Add your answer

First round was a coding test online with screen monitoring

Q1. Hacker rank code for no reason for de
Ans. 
The question is unclear and requires further clarification.
• Request for more information on the specific requirements of the code.

• Ask for clarification on the purpose of the code.

• Determine the programming language to be used.
Answered by AI
Add your answer
Q2. Python sort element of string array by alphabet weightage and resolve all 23 test cases that nobody can
Ans. 
Sort string array elements by alphabet weightage in Python and pass 23 test cases.
• Use the sorted() function with key parameter to sort elements by weightage

• Define a function to calculate weightage of each character

• Test the function with various test cases to ensure accuracy
Answered by AI
Add your answer

Q1. Spark, AWS, Python
Add your answer

Q1. Python, SQL, Spark
Add your answer

Q1. Salary discussion
Add your answer

Q1. General Interview
Add your answer

BASIC PYTHON AND SQL

Q1. Questions based on past experience
Add your answer
Q2. My roles and responsibilities
Add your answer

Q1. Easy HR questions
Add your answer