Microsoft Data Science Intern Interview Experience
Summary
I completed a two‑round interview process for a Data Science Intern position at Microsoft, featuring an online assessment and a technical interview, but I was not selected for the final round.
Full Experience
Company : Microsoft Role : Data Science Intern Location : Banglore On-Campus
Round 1 : Online Assesment Question 1 : Don't exactly remember , but Arrays Questions easy-medium level related to finding how much each element deviated from mean
Question 2 : Find the Global Maxima of a Quadratic Equation using SciPy Library
Round 2 : Interview 45 Mins Technical Interview Started of with Asking Probablity and Statistics Question, p-value null hypothesis z-test t-test ANOVA Questions Related to Resume and Projects Basic ML Questions with Real Life Examples Supervised Unsupervised RL. Quesstions about Time-Series Datasets and models 2 SQL Queries 3 Tables - Student Department Events i) Write query to find average marks of each Department (Hackerrank was not working so they dictated the question and told me to write in Teams Chat) ii) Write a Query to find out how many students attended each Event.
Did not make it to final round. But it was also Technical.
Interview Questions (3)
Find Global Maximum of a Quadratic Equation using SciPy
Find the Global Maxima of a Quadratic Equation using SciPy Library.
Average Marks per Department
Write a SQL query to find the average marks of each Department using the provided tables (Student, Department, Events).
Student Attendance Count per Event
Write a SQL query to find out how many students attended each Event using the provided tables (Student, Department, Events).