2 technical Round and 1 from internal and 1 from client or by managerial there will be 2 SQL questions and 1 or 2 spark coding question basic.
SQL: print the given string in vertical order.
SQL: question based on lead, lag, rank, dense rank
Interview questions [1]
Question 1
For Azure Data Engineer Role : There were 2 technical round and questions are from Pyspark, Spark, ADF, SQL, ADB
Mostly asked about .net CLR, middleware,customMiddleware,JIT ,sql query to select top 4th highest salary .filters in .net core, action filter, difference between ref and out keyword, Difference between var and dynamic
2 rounds
1st round - test fundamentals of frontend technologies by asking questions
2nd round - deep dive by asking scenario based questions that would require project experience to answer