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
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. I interviewed at Lagozon Technologies
Interview
They will ask about the projects and experience mentioned in the resume and related to it some of the technical questions. Focus on practicing the basics to intermediate level of questions.
Interview questions [1]
Question 1
1. SQL basics to intermediate questions like windows functions, CTE and joins.