Innovaccer Interview Questions, Process, and Tips

• Q1. Questions were completely based on data structures and algorithm
  Add Answer
• Q2. SQL based questions were also asked
  Add Answer

• Q1. Dense rank, rank and row number
  Add Answer
• Q2. Self join HR data sql query
  Add Answer

• Q1. DSA and some basic python and questions form resume
  Add Answer
• Q2. DSA and some basic questions from databases and resume
  Add 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.
  Add 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.
  Add Answer

• Q1. Managerial round
  Add 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 Answer

• Q1. CTC negotiation
  Add Answer
• Q2. What u know about company and why u want to join company.
  Add Answer

Python coding, simple

• Q1. Data analytics related, imbalanced data set handling
  Add Answer
• Q2. Overfit and how to fix that
  View Answers (1)

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 Answer
• Q2. Another SQL Question.
  Add Answer

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