Took 4 rounds of interview for data engineer - 2 Tech, 1 HM & 1 HR Topics - ADF Pipelines, Databricks, SQL Queries, Spark Tuning SQL Tuning, Power BI, Spark code

3 rounds,2 technical and 1 hr,what if you have 1 gb file it gives you error how you handle Oops concepts Difference between list tuple set dictionary "List Comprehension A concise way to create lists using a single line of code." "Dictionary Comprehension Similar to list comprehension but creates dictionaries." Add and remove numbers in stack Add and remove numbers in Queue query to give the rank to the employee with respect to department Dublicate emails flatten a nested list Find dublicate in list in Python