Vedantu Senior Data Analyst Interview Questions and Answers

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

Any general knowledge topic

Q1. Tell me about yourself
Ans. My Name is Sujitha Rajendran.I have completed Master of Business Economics at Ethiraj College for women. I am from Namakkal district and searching for job opportunities now. My Father is a business man. My Mother is a home maker and My Brother is a Software Engineer
Answered Anonymously
Add your answer
Q2. Strength and weakness
Add your answer
Q3. Short term and long term goal
Ans. 
Short term goal is to enhance data analysis skills, long term goal is to become a data science expert.
• Short term goal: Improve proficiency in SQL, Python, and data visualization tools

• Long term goal: Obtain advanced certifications in machine learning and AI

• Short term goal: Complete online courses on statistical analysis and data cleaning

• Long term goal: Lead data science projects and mentor junior analysts
Answered by AI
Add your answer
Q4. Why did you chosen this company?
Ans. My Strength is that I am not only a hard working person but also a smart working person. I am a quick learner and self motivational person. I am a good team player, good listener and good in time management
Answered Anonymously
Add your answer
Q5. Why we want to hire you?
Add your answer
Q6. Salary discussion
Add your answer

Verbal, logical, Quantative test

Q1. Self introduction
Add your answer

Q1. Tell me something about yourself
Ans. 
I am a data analyst with a strong background in statistics and programming, passionate about deriving insights from data.
• I have a Bachelor's degree in Statistics and experience in data visualization tools like Tableau

• I am proficient in programming languages such as Python and SQL

• I have worked on projects involving predictive modeling and data mining techniques
Answered by AI
Add your answer
Q2. Some question related to Python
Add your answer

Sql coding test where multiple sql questions were asked

Q1. Technical test on SQL and previous experience
Add your answer

Q1. Another technical by the head of data
Add your answer

There was a take home data science assignment

Q1. Again another technical with a data analyst
Add your answer

Case study round with one head of data

Q1. Again another technical round by the business operations head
Add your answer

Presentation to all the panel members on the project

Q1. One on one with a technical manager
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

SQL, Analytical, Maths

Q1. SQL qsn on some data
Add your answer
Q2. Qsn on LLMs in company
Add your answer