Stellar Innovations Data Analyst Interview Questions and Answers for Freshers

Q1. Introduce yourself
Add your answer

SQL and python questions are very easy.

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

Fundamental aptitude questions.

Two medium-level questions.

Q1. Logistic regression parameter tuning
Add your answer

It was a test of 90 minutes containing almost every thing .Quantitative+Logical+Computer fundamentals+2 coding questions

Q1. Python Coding qns
Add your answer
Q2. Sql coding qns
Add your answer

It was an on campus recruitment drive with questions mostly on basic statistics and algebra.

In round 2 the interviewer asked to explain one of my project and then write code for longest common substring problem.

One Simple coding problem followed with couple of probability questions and explaining the Simple Linear model in detail.