ION Group Technical Analyst interview questions

The interviewer maintained a relaxed demeanor, focusing on puzzles, basic DBMS concepts, and resume-based queries. While puzzles were challenging, resembling those from GFG, their absurdity stood out amidst the technical discussions.

I applied through college campus. 1st round was of 2 hrs aptitude and Computer Science basics mcq test. I applied for technical analyst which does not have any coding questions in the test but more on sql. 2nd round was an online technical interview with 2 panelists who asked me 4 puzzles, resume related questions and the reason I hv chosen this particular role of technical analyst. This round was of 1 hr. 3rd round was of case study where we hv to study and answer some cases based on the case. My case was retail profit on amazon delivery services. This was of 30 mins and was more of a general discussion round. 4th round was Stakeholder's round where there were again 2 panelists who were very senior. They asked resume based questions and project based questions, some technical questions on OOPS, scenario based questions like what will u do if u r on a night shift and cannot contact any other colleagues but u need to sort an issue of yr client urgently but don't know how to resolve the issue.