Innovaccer Data Analyst Interview Questions and Answers

SQL+CODING QUESTIONS

Q1. CODING QUESTION YOU NEEDED TO TELL YOUR APPROACH AND CODE THEN
Add your answer
Q2. SQL QUESTIONS - THEORY + PREDICTING OUTPUT
Add your answer

Q1. DSA + MANAGERIAL ROUND
Add your answer
Q2. HR QUESTIONS ABOUT YOUR FUTURE
Add your answer

Q1. Dense rank, rank and row number
Add your answer
Q2. Self join HR data sql query
Ans. 
A self join in SQL allows a table to be joined with itself to compare rows within the same table.
• Self join is useful for hierarchical data, e.g., employees and their managers.

• Example: SELECT a.EmployeeID, a.Name, b.Name AS ManagerName FROM Employees a JOIN Employees b ON a.ManagerID = b.EmployeeID;

• It can also be used to find duplicates or compare rows, e.g., finding employees with the same job title.

• Self joins require ...read more
Answered by AI
Add your answer

Q1. They asked Questions on join given two table A&B with one column each and u have to print out put for inner join, left join and correct join.
Ans. 
Explains inner join, left join, and right join using two tables A and B.
• Inner Join: Returns records with matching values in both tables. Example: A = [1, 2, 3], B = [2, 3, 4] -> Result = [2, 3].

• Left Join: Returns all records from table A and matched records from table B. Example: A = [1, 2, 3], B = [2, 4] -> Result = [1, 2, 3].

• Right Join: Returns all records from table B and matched records from table A. Example:...read more
Answered by AI
Add your answer
Q2. Then they asked medium level questions given , write query to print 2nd highest marks for each class using concept of windows function in SQL.
Ans. 
Use SQL window functions to find the second highest marks for each class efficiently.
• Use the ROW_NUMBER() function to assign a unique rank to each student's marks within their class.

• Partition the data by class using the PARTITION BY clause.

• Filter the results to get only the rows where the rank is 2, which corresponds to the second highest marks.

• Example SQL query: SELECT class, marks FROM (SELECT class, marks, ROW_NUMBE...read more
Answered by AI
Add your answer

Q1. Managerial round
Add your answer
Q2. They asked all my project in my CV and deep discussion on each one. What is SCD type, what are composite key .
Add your answer

Q1. CTC negotiation
Ans. 
Negotiating CTC involves understanding your worth, market standards, and effectively communicating your value to the employer.
• Research industry standards for similar roles to set a realistic expectation.

• Highlight your unique skills and experiences that add value to the company.

• Be prepared to discuss your previous salary and justify your expectations.

• Consider the entire compensation package, including benefits and bonus...read more
Answered by AI
Add your answer
Q2. What u know about company and why u want to join company.
Add your answer

There was 1 interviewee, he asked 2 SQL questions over a time period of 40 minutes, we discussed around the question, my solution, and his approach towards the same.

Q1. What was my role in the previous organisation and explain how and why about it?
Add your answer
Q2. Another SQL Question.
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. Why do you want to join the company, and what are your goals?
Add your answer