I applied online. The process took 1 day. I interviewed at Lagozon Technologies (New Delhi) in Jan 2025
Interview
The entire process comprises of four rounds
1. Assessment comprising questions from SQL and Power BI
2. Technical Interview 1 : SQL, Power BI, DAX, M query questions
3. Technical Interview 2 : M query in detail, Date transformation
4. HR Round
Interview questions [1]
Question 1
1. Time intelligence functions;
2. M transformations
3. Joins, coelsce based SQL queries
4. 8/2023, 9/2023: convert these type of date formats into 01/08/2023 and 01/09/2023 using M query; The solution should be generalised.
5. Incremental refresh and where it's won't work.
I applied online. The process took 1 day. I interviewed at Lagozon Technologies in Jan 2025
Interview
Smooth process, everything was organised, not much waiting.
4 rounds in the process as below
1. MCQ test: SQL, Power BI, Python etc
2. Technical interview
3. Technical Interview 2
4. HR Round
Hr called me and i clearly mentioned my last drawn CTC and my expected CTC. After that she schedule my interview. I cleared 2 technical round and one managerial round. After that they are giving silly excuses that you are not technically gud so that's why we are not shortlisting you. If my technical skills are not gud how can you cleared my technical rounds. After that HR said we have budget constraint. If you have budget constraints so why you wasted my time?? I clearly mentioned my CTC and expected CTC. Why you scheduled my interview.......
