Multiple round of interview.
Interview context was different from what role I had applied for. Interview went for NLP discussion where as I was interviewing for Analyst role, but no hands on coding assessment
There were 3 rounds of interview first is screening process, HR will connect with you on phone, and then schedule a first round of interview, 1st round is technical round, SQL questions were asked, mostly scenario based questions, it was a mid level questions, focus on window functions, joins, CTE
Interview questions [1]
Question 1
Tell about the current project experience with sql
I applied online. The process took 2 weeks. I interviewed at Target in May 2022
Interview
The interview was behavioral and took about 15 minutes. Asked questions such as how would deal with a complaint or working with others along with availability to work. Other topics include previous work experience or customer service.