Testhouse Junior Analyst Interview Questions and Answers

Q1. Briefing about my last job
Add your answer

Q1. On python data manipulation(easy)
Add your answer
Q2. Sql(intermediate)
Add your answer

Q1. Sql question and also some data engineer level questions
Add your answer

Simple topics like present situations

Some basic mathematics and sql and python basic questions

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

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
View 2 more answers

Q1. Introduction, followed by SQL questions, like what is the order of execution in SQL, and how do various joins work
Add your answer

Q1. Basic SQL questions, including the ones in the last round, also some query writing, with easy to medium difficulty
Add your answer

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
Add your answer
Q2. This round was taken by the Indium's client company, by your prospective manager there.
Add your answer

Q1. In this they'll decide on the offer to make.
Add your answer

Life Experience

Q1. Machine Learning Questions like Regularization, Standardization,Supervised and Unsupervised ML
Add your answer
Q2. SQL questions on Second Highest Salary,Case usage Difference between Delete and Truncate,Constraints
Add your answer
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...read more
Answered by AI
Add your answer
Q4. Case Study Questions and Project Discussion
Add your answer

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.

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...read more
Add your answer

Q1. Questions on my previous work experience
Add your answer
Q2. SQL Questions based on random scenario
Add your answer

Q1. Hacker rank solving questions
Add your answer