Basic to Advanced level questions on SQL and MSBI. Cloud technologies as well like Azure or Aws is required to attempt interview. First Round itself is HR round to check communication skills
I applied through a recruiter. I interviewed at Koch in Sep 2021
Interview
* Even though it took long, it was very productive and interactive.
Very professional people
* Good management
* They help us to understand company culture
* Give better understanding on the skill set required for the role
Interview questions [1]
Question 1
about problem solving, team leading process and challenges faced
I applied through a recruiter. The process took 2 weeks. I interviewed at Koch (Bengaluru) in Aug 2020
Interview
First round was based on communication and behavioral questions, 2nd was technical. I was interviewed by a person with slightly more experience than me. The interview process went for approx 30 mins covering SQL, SSIS and Power BI. Although, I wasn't asked a single question on the SSRS part, the feedback I received said: less knowledge in SSRS and SQL. I wrote them asking if there was a miscommunication, they are yet to reply to it. The interviewer seemed amateur with no knowledge of evaluating candidates' knowledge.
Interview questions [1]
Question 1
Difference between different Indexes storage in the hardisk, Intersect function, how to use row_number without order by, sum vs sumx in DAX, optimizing Power BI direct query
