J'ai postulé via la recommandation d'un employé. Le processus a pris 3 semaines. J'ai passé un entretien chez Tredence (Chicago, IL) en mai 2021
Entretien
The interviewers are very nice and I had a great time with them. They guide me to answer the correct answers several times. There are three rounds, hr screening, tech interview, and business interview.
Questions d'entretien [1]
Question 1
1. Give me three sql problems from easy to hard and write the code 2. some data manipulation with python. 3. some business case problem
J'ai postulé en ligne. Le processus a pris 2 semaines. J'ai passé un entretien chez Tredence (Calcutta)
Entretien
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.
Questions d'entretien [1]
Question 1
Find common elements between two lists
Spark architecture
Types of SCD and how to implement
J'ai passé un entretien chez Tredence (Bentonville, AR)
Entretien
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.
Questions d'entretien [1]
Question 1
Write an sql code for filtering dates in a give database?