
Tredence Consultant Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 8 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Tredence.
Consultant
The interview process was very unclear. The interviewer didn't describe the role accurately. Scheduling the interview was also really tough. The HR team was rude and unhelpful, and it seemed like they weren't really interested in doing the interview.
- Can you write some SQL code to filter dates in a database?
Consultant
I had two technical rounds and then an HR round. The first round was techno-managerial, covering SQL, PySpark, Databricks, ADF, and Python, with questions ranging from easy to moderate. The second round focused on PySpark, SQL, Databricks Unity Catalog, optimization, and DLT, with moderate difficulty questions.
- Can you explain SQL Joins, CTEs, and Window functions?
- Tell me about your experience with SQL, PySpark, Databricks, ADF, and Python.
- Let's discuss PySpark, SQL, Databricks Unity Catalog, optimization techniques, and DLT.
Consultant
I had 2 technical rounds and then an HR discussion. Both of the technical rounds were pretty easy. They asked basic questions about spark, SCD, python, and SQL. The second round was focused on databricks questions and was taken by a Senior Person.
- How to find common elements between two lists?
- Explain Spark architecture.
- What are the types of SCD and how do you implement them?
Tredence Consultant Interview Questions
Quoted word for word from Tredence interview reports.
“How to find common elements between two lists?”
Read reports →“Can you write some SQL code to filter dates in a database?”
Read reports →“Explain Spark architecture.”
Read reports →“Can you explain SQL Joins, CTEs, and Window functions?”
Read reports →“Could you present three SQL problems, ordered by difficulty from easy to hard, and provide the corresponding code?”
Read report →“Can you answer some technical questions about Python and ML?”
Read report →“Can you answer some questions about Databricks?”
Read report →“Also, can you answer some questions about logical reasoning and business functions during the management round?”
Read report →“Can you share an instance where you leveraged data to resolve an issue?”
Read report →Formats, difficulty and experience
Across all 8 Tredence interview reports.