Upload Button Icon Add office photos

Filter interviews by

Testhouse Junior Analyst Interview Questions and Answers

Updated 10 May 2021

Testhouse Junior Analyst Interview Experiences

1 interview found

Interview Questionnaire 

2 Questions

  • Q1. Explain about the job role?
  • Q2. Have a detailed look on the interview mail they send.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Questions are related to excel, SQL, visualisation tools such as Tableau, Power BI.

Round 2 - Coding Test 

Questions are related to SQL, excel, visualisation tools such as power BI and Tableau etc.

Round 3 - HR 

(2 Questions)

  • Q1. Normal discussions regarding salary negotiation.
  • Q2. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Questions are the same you can easily practice them on the internet and Hackerrank.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain about joins, window functions, puzzles.

Data Analyst Interview Questions & Answers

Indium Software user image Satyamshree Moharana

posted on 21 Nov 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Approached by Company and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Briefing about my last job
Round 2 - Technical 

(2 Questions)

  • Q1. On python data manipulation(easy)
  • Q2. Sql(intermediate)
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Sql question and also some data engineer level questions

I applied via Naukri.com and was interviewed in Jun 2022. There were 3 interview rounds.

Round 1 - Group Discussion 

Simple topics like present situations

Round 2 - Aptitude Test 

Some basic mathematics and sql and python basic questions

Round 3 - Technical 

(1 Question)

  • Q1. Some sql functions,group by , window functions, some query based on lag and lead functions

Interview Preparation Tips

Interview preparation tips for other job seekers - Good interview process and prepare well in sql

I applied via LinkedIn and was interviewed in Mar 2022. There were 6 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Basic questions about SQL, for ex, what are the various types of joins, what are the various window functions, difference between rank and dense rank, difference between union and union all
Round 3 - Technical 

(1 Question)

  • Q1. Introduction, followed by SQL questions, like what is the order of execution in SQL, and how do various joins work
Round 4 - Technical 

(1 Question)

  • Q1. Basic SQL questions, including the ones in the last round, also some query writing, with easy to medium difficulty
Round 5 - Technical 

(2 Questions)

  • Q1. Elaborate and in-depth discussion about your past experiences, followed by SQL questions, including the ones in the past rounds, and also writing a few queries based on the problem statement
  • Q2. This round was taken by the Indium's client company, by your prospective manager there.
Round 6 - HR 

(1 Question)

  • Q1. In this they'll decide on the offer to make.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very thorough with the basics of SQL, understand the various joins , how duplication occurs in them, and the order of execution, etc. And be well versed about whatever you've put on your resume.

I applied via Recruitment Consulltant and was interviewed in Mar 2022. There were 2 interview rounds.

Round 1 - Group Discussion 

Life Experience

Round 2 - Technical 

(4 Questions)

  • Q1. Machine Learning Questions like Regularization, Standardization,Supervised and Unsupervised ML
  • Q2. SQL questions on Second Highest Salary,Case usage Difference between Delete and Truncate,Constraints
  • Q3. Use of Pandas and Numpy, Gaussian Distribution
  • Ans. 

    Pandas and Numpy are Python libraries used for data manipulation and analysis. Gaussian distribution is a probability distribution.

    • Pandas is used for data manipulation and analysis, including data cleaning, merging, and reshaping.

    • Numpy is used for numerical operations on arrays and matrices.

    • Gaussian distribution is a probability distribution that is commonly used in statistics and data analysis.

    • Numpy provides functions...

  • Answered by AI
  • Q4. Case Study Questions and Project Discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare Basics of ML, SQL and Python-->Pandas and Numpy

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

They have asked for HackerRank test which has mix of aptitude and reasoning. And second part has SQL coding comprises of 2 moderate question and 1 has moderate difficult one. I have successfully submitted 2 questions and faced test case failed for the difficult one.

Round 3 - One-on-one 

(1 Question)

  • Q1. Questions - 1. Order of execution of query. 2. Join and types of join. 3. Group by query. 4. Having vs where. 5. Left join tricky question 6. Self join tricky question. 7. Window function and comparison to...

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice more on Basic and Advance SQL and those who write python in resume then same follows there.

Data Analyst Interview Questions & Answers

Indium Software user image Sai Vineeth Bodapati

posted on 9 Jul 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on my previous work experience
  • Q2. SQL Questions based on random scenario

Interview Preparation Tips

Topics to prepare for Indium Software Data Analyst interview:
  • SQL
  • Python
  • Data Analysis

Tell us how to improve this page.

Interview Questions from Similar Companies

Indium Software Interview Questions
4.0
 • 162 Interviews
HyScaler Interview Questions
4.5
 • 91 Interviews
Qualitest Interview Questions
3.6
 • 79 Interviews
Monotype Interview Questions
3.9
 • 23 Interviews
MulticoreWare Interview Questions
4.3
 • 23 Interviews
View all
Testhouse Junior Analyst Salary
based on 31 salaries
₹1.9 L/yr - ₹3 L/yr
38% less than the average Junior Analyst Salary in India
View more details

Testhouse Junior Analyst Reviews and Ratings

based on 6 reviews

3.8/5

Rating in categories

3.9

Skill development

4.2

Work-life balance

3.4

Salary

4.7

Job security

4.1

Company culture

3.6

Promotions

3.7

Work satisfaction

Explore 6 Reviews and Ratings
Senior Analyst
47 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
45 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Softwaretest Engineer
34 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Consultant
32 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Junior Analyst
31 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Testhouse with

Cigniti Technologies

3.7
Compare

Think Future Technologies

4.0
Compare

Indium Software

4.0
Compare

Qapitol Qa

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview