Virtual Interview - 4 years' experience in Data Engineering Domain
Interview process was smooth end to end. I was reached out from naukri, interview scheduled in next 2 days, R1 was 30 mins.
Interview questions [1]
Question 1
Round 1 - Purely SQL
1. Types of Joins
2. Question on Joins
3. ETL Process
4. 2 SQL Hands-on question based on Strings and case when use
I applied online. I interviewed at Innovaccer (Noida) in Nov 2021
Interview
Interview consisted of first screening round on Hackerrank, Technical Interview, Managerial Interview, HR Interview. Screening round had 2-3 sql medium questions. Technical Interview consisted of Lead Data Analyst/ Senior Data Analyst to take an hour on technical interview based on the resume and skills required for job. Then Managerial round consisted of a Manager/Director to take an interview based on resume on your job tasks, resume. Final HR round consisted of meeting with HR on values and behavior questions.
Interview questions [1]
Question 1
In technical interview, they mostly asked SQL and barely any Python. In Manager Interview they asked about the job roles in resume and the challenges/solution related to it. HR interview asked about company values, HR questions like any relative working in NAB etc.
I applied online. I interviewed at Innovaccer (Noida) in Apr 2021
Interview
Round 1 :- Technical discussion over call, asked some basic questions of SQL
Round 2:- Technical discussion over webex, asked Advance SQL questions, Project, Data Processing steps like Data cleaning, Data prepartions
Round 3:- Manager round, Mainly asked you about project and some basic questions related to your project.
Round 4:- HR round, explain you about roles, organization culture, learning opportunity.
Interview questions [1]
Question 1
Q) Question based on SQL Join, sub query, Aggregation
