I applied online. The process took 5 days. I interviewed at Turing (Pune) in Sept 2024
Interview
HR found my profile through Naukri, they got an understanding about my current job role and checked if it aligns with their requirement and arranged an interview. The interview was rescheduled thrice and that too not in advance.
Interview questions [5]
Question 1
Given the AirBnB dataset: https://colab.research.google.com/drive/1IwyaZuTccboR8huyWcxHKACTyFQBvHp5?usp=drive_link#scrollTo=I553tK0NAHtd
Listings: This is a table that contains information about Airbnb listings in some city. Every listing has a single row in the table and contains several attributes related to the listing as well as the Airbnb host for the listing.
Reviews: This is a table that contains information about all the guest reviews for the listings in the “Listings” table, along with related attributes such as the date of the review and the reviewer's name
Answer the following questions:
What is the neighborhood in which superhosts have the biggest median price difference with respect to non superhosts? Use the following three columns in the 'listings' dataset to answer this question: 'host_is_superhost', 'neighbourhood_cleansed', and 'price'.
What is the average price difference between a professional host and a non-professional one? Consider a host as professional if they have listings in more than 5 different locations (location is defined by the 'neighbourhood_cleansed' column).
What is the median price premium given to entire homes / entire apartments with respect to other listings of the same neighborhood? Report the average across all neighborhoods. Use the 'room_type’ column in the 'listings’ dataset to distinguish between entire homes / entire apartments and other types of listings
What is the listing with the best expected revenue based on the last 12 months, considering 60% of guests leave reviews and every guest will stay only the minimum number of nights? Use both the 'listings' and 'reviews' datasets for this question and only use listings with minimum nights of stay <= 7. The 'minimum_nights' column indicates the required minimum number of nights of stay for any listing.
Quite tough vetting process contains multiple rounds.
Totally 5 rounds profile creation, experience add on, behavioural quest, communication check, tech stack choosing, problem solving, coding and bar raiser after joining in to team also it will be 10 days performace check after that only u can work there else only one exit call enough to throw u out it's terrible.
Interview questions [1]
Question 1
They made me to do long analysis in the span of 1hr.