I applied online. The process took 2 weeks. I interviewed at Tredence (Calcutta)
Interview
Two technical rounds followed by one HR round.
First round(techno managerial): Questions based on Sql, pyspark, Databricks,ADF,python
Level was easy to moderate
Second round:Questions based pyspark,sql, Databricks unity catalog, optimization,DLT
Questions were moderate
2 technical rounds and HR discussion. Both rounds were easy. Basic questions were asked on spark, SCD, python and SQL. Second round was focused on databricks questions taken by Senior Person.
Interview questions [1]
Question 1
Find common elements between two lists
Spark architecture
Types of SCD and how to implement
Very vague. Interviewer did not paint the right picture. Setting up the interview was also a very difficult process. The hr team is rude and unhelpful. It almost felt like they were not interested in conducting the process.
Interview questions [1]
Question 1
Write an sql code for filtering dates in a give database?
