LatentView Analytics Interview Questions, Process, and Tips for Experienced

Q1. SQL problems to solve nth highest salary
Ans. 
Use SQL query with subquery to find nth highest salary
• Use ORDER BY and LIMIT to get the nth highest salary

• Use a subquery to exclude the top n-1 salaries before selecting the nth highest salary
Answered by AI
Add your answer

Q1. GCP big query Architecture
Add your answer

It was easy to approach!

Discussions about common topics like boon or bane to society

Asked about the scenarios

Q1. Technical round related to skills and resume
Add your answer

Q1. Discussions regarding work culture and compensations
Add your answer

Q1. All basic concepts of pthon sql and ml
Add your answer

Apptitude, tecncal, cognitiive

Q1. Tell me about About your tech stack
Add your answer

Q1. This depends on project to project
Add your answer

Basics of SQL, Python

Experience based questions, SQL and Python

Q1. Tell me about the projects you worked on
Add your answer
Q2. Based on experience some questions related to projects.
Add your answer

Topics will be mainly SQL and few python questions. Duration-3min to 1hr

Q1. What is CLT theorem and what are its uses
Ans. 
CLT theorem states that the distribution of sample means approaches a normal distribution as sample size increases.
• Central Limit Theorem (CLT) is a fundamental concept in statistics that states that the distribution of sample means approaches a normal distribution as the sample size increases.

• It is used in hypothesis testing, confidence intervals, and in estimating population parameters.

• CLT is essential in making infer...read more
Answered by AI
Add your answer
Q2. Asked to write SQL queries which uses join and window functions
Add your answer
Q3. Explain ML Data preparation and EDA steps in detail. What are major steps in preprocessing
Ans. 
ML data preparation involves cleaning, transforming, and organizing data for analysis. EDA involves exploring and visualizing data to understand its characteristics.
• Data cleaning: removing missing values, handling outliers, and dealing with duplicates

• Data transformation: encoding categorical variables, scaling numerical features, and creating new features

• Data organization: splitting data into training and testing sets,...read more
Answered by AI
Add your answer

Q1. Mainly interviewer checked how sound I was in different concepts like statistics, ML
Add your answer
Q2. Asked simple DL questions
Add your answer
Q3. Guestimates- like how much milk is consumed in your city on average. Give an estimate and show your structured way of arriving at that value
Add your answer

Q1. Why you want to join our comany?
Add your answer
Q2. What made you leave your previous organization
Add your answer
Q3. Salary negotations
Add your answer