Internshala interview experience Real time questions & tips from candidates to crack your interview

Data Science Teaching Assistant Intern

Internshala
upvote
share-icon
3 rounds | 14 Coding problems

Interview preparation journey

expand-icon
Journey
I was pursuing my B.Tech during this internship. My B.Tech was in Artificial Intelligence and Data Science, and all my personal projects were also related to machine learning and data science.
Application story
So, I applied directly through the Internshala portal for this internship. Luckily, there were very few applications, so mine got shortlisted, and I received a call the next day.
Preparation
Duration: 3 months
Topics: SQL, Excel, Power BI, Machine Learning, Deep Learning, Python
Tip
Tip

Tip 1: Focus on SQL, Excel, Power BI, and Statistics, as they make up 90% of the interview tech stack.

Tip 2: You should have the ability to explain concepts to students in a simple and clear way.

Tip 3: Expect questions like “Why do you want to teach students?”

Application process
Where: Other
Eligibility: N/A, (Stipend - 18k)
Resume Tip
Resume tip

Tip 1: The tech stack includes Excel, Python, SQL, and Power BI.

Tip 2: Make sure to include some good Power BI and Excel projects in your resume.

Interview rounds

01
Round
Easy
HR Round
Duration30 minutes
Interview date20 Oct 2025
Coding problem1

1. HR Questions

  • Why do you want to switch to teaching instead of IT?
  • What is the difference between a list and a tuple? (Learn)
  • Are you comfortable with an on-site role?
  • Do you have any prior teaching experience?
02
Round
Medium
Face to Face
Duration50 minutes
Interview date22 Oct 2025
Coding problem8

1. VLOOKUP and XLOOKUP

Difference between VLOOKUP and XLOOKUP?

2. Index vs Map

Explain the index and map functions.

3. Table Concatenation

How can you concatenate multiple tables in Power BI?

4. DBMS

Explain the different types of joins? (Learn)

5. Pivot Usage

What is the use of a Pivot Table in Excel? (Learn)

6. DBMS

What is the difference between Views and CTEs?

7. Project Explanation

Explain your previous data analytics project.

8. Service Usage

Explain the use of Power BI Service. (Learn)

03
Round
Easy
Face to Face
Duration30 minutes
Interview date24 Oct 2025
Coding problem5

1. Linear Regression

Explain linear regression to me (assuming you are explaining it to a student).

2. Central Tendencies

Explain the difference between mean, median, and mode.

3. Five Summary

What is the five-number summary? Explain.

4. Test Selection

When should you use a t-test and a z-test?

5. CLT Explanation

Explain the Central Limit Theorem.

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
Web Developer
3 rounds | 4 problems
Interviewed by Internshala
1091 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
4657 views
0 comments
0 upvotes
company logo
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
6451 views
0 comments
0 upvotes
company logo
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
3452 views
0 comments
0 upvotes