Refyne Interview Question

Round 1: Online Assessment by InterviewVector. Q1. Resume based questions Q2. SQL Questions: Leetcode 585: Investments in 2016 Leetcode 626: Exchange Seats Q3. Python Question: Read from csv file and bucket the age in 4 groups and find the average of the age in these respective buckets. output the file into a csv file. Q4. What are stored procedures in SQL? Q5. What are views in SQL? How is it different from a cte. Q6. Difference between iloc an loc in pandas. Q7. How will you do hypothesis testing in python? Specify the standard libraries and approaches. . Round 2: Interview with one of the VP Resume based questions and detail explanation of previous risk data science project. Round 3: Interview with one of the Data Scientists Q1. Calculate market size for health insurance in India. (Guesstimate) Q2. Difference between rank and dense_rank in SQL. . Round 4: Interview with one of the founders Resume based questions Q1. How will you find the total number of bus stops in Bangalore? (end-to-end funnel analysis) (Not a guesstimate)