ExcelR Data Scientist Interview Questions and Answers

Q1. Missing values outliers, over fitting underfitting
Add your answer

Q1. Outliers missing values, overfitting underfitting
Ans. 
Understanding outliers, missing values, overfitting, and underfitting in data science.
• Outliers are data points that significantly differ from other data points in a dataset.

• Missing values are data points that are not present in a dataset.

• Overfitting occurs when a model learns noise in the training data rather than the underlying pattern.

• Underfitting occurs when a model is too simple to capture the underlying pattern in...read more
Answered by AI
Add your answer

Q1. Why your interested
Add your answer
Q2. Why you want to Jon
Add your answer

Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
Add your answer
Q2. Sql joins questions based on three tables, complex joins
Add your answer

Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Add your answer

Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...read more
Add your answer

Q1. Was asked basic HR questions
Add your answer

Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Add your answer

Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...read more
Add your answer

Q1. Question based on Window Functions in sql
Add your answer
Q2. Order of execution
Ans. 
Order of execution refers to the sequence in which operations are carried out in a program or system.
• Execution starts from the top of the program and moves downwards.

• Operations within parentheses are executed first.

• Multiplication and division are executed before addition and subtraction.

• Functions are executed when they are called.

• Control structures like loops and conditionals affect the order of execution.
Answered by AI
View 1 more answer

Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
Ans. 
Use a SQL query to find different routes for an airline based on source and destination columns in a table.
• Use a SELECT statement to retrieve the distinct combinations of source and destination.

• Use the DISTINCT keyword to ensure only unique routes are returned.

• Order the results by source and destination for easier analysis.
Answered by AI
View 1 more answer
Q2. Situational questions based on Business KPI
Add your answer

Q1. Simple discussion on the role and company culture
Add your answer

Q1. Case study question
Add your answer

Q1. Basic Discussion on relocation and interest in joining the company.
Add your answer

Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...read more
Add your answer
Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
Add your answer

Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...read more
Add your answer
Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...read more
Add your answer

Aptitude test is easy.

Really tuff

Q1. What are your salary expectations?
Ans. 
I am open to discussing salary based on the responsibilities and opportunities offered by the position.
• I am flexible and willing to negotiate based on the overall compensation package.

• I am more interested in the growth potential and learning opportunities than a specific salary number.

• I would like to be compensated fairly for my skills and experience in the industry.

• I am open to discussing salary range during the inter
Answered by AI
Add your answer
Q2. What is your family background?
Ans. 
My family background is diverse and includes individuals from various professions and cultural backgrounds.
• My father is a doctor and my mother is a teacher.

• I have two siblings, one is an engineer and the other is a lawyer.

• We have relatives who are artists, entrepreneurs, and scientists.

• Our family gatherings are always filled with interesting conversations and different perspectives.
Answered by AI
Add your answer
Q3. Where do you see yourself in 5 years?
Ans. 
In 5 years, I see myself as a senior software developer leading a team and working on complex projects.
• Leading a team of developers

• Working on complex projects

• Continuously learning and improving my skills

• Contributing to the growth and success of the company
Answered by AI
Add your answer
Q4. Why should we hire you?
Ans. 
I have a strong technical background and a passion for software development.
• I have a solid understanding of programming languages and software development principles.

• I have experience working on various software projects, including [example project].

• I am a quick learner and adapt easily to new technologies and frameworks.

• I am a team player and have excellent communication skills, which are essential for collaborating w...read more
Answered by AI
Add your answer