The Interviewer was just 1 years of experience and was taking interview for me, I was 5 years of experience. He was just focused only on standard interview questions and was expecting answer which is like bookish not the practical one. Its like they opened position for just passing the Time.
Interview questions [1]
Question 1
Databricks unity catalog, liquid clustering, shallow and deep clones. Delta format.
SQL question based on data which needed to find the balance of each users after transanctions.
SQL query to find the employees joined in last 3 months.
Python question to find character frequency and question to remove duplicate.
They take L1 and L2 technical interview and ask basic questions about Sql and project on which we are working. It includes questions aboutprocedure, functions, packages, joins, triggers . They can ask about project architecture.
I applied through a staffing agency. I interviewed at Nice Software Solutions (Nāgpur, Maharashtra) in Mar 2021
Interview
Very slow responsive in terms of documentation and feedbacks after the interview process is done they'll take more than 3 weeks to get back to you on your candidature and then the onboarding pro ess is also super slow
Interview questions [1]
Question 1
About my previous work location and Relocation to their HO