Tredence Interview Experience For Data analyst
After Pre-placement talk,
Round 1
It was an online Assessment of 2 hrs on Hacker Earth consisting of 60 questions(55 Mcqs, 2 python programming and 3 SQL)
Mcqs were majorly out of Data structures, Machine Learning, Deep Learning, Statistics, Aptitude, Logical reasoning and verbal ability.
Round 2
It was the SpeechEx Assessment on the Mettl platform. Questions were of basic Grammar and we were mainly to test a candidate’s verbal abilities questions were like”What is success to you in life? Elaborate” etc.
Round 3
It was a 30-minute interview round and was mostly resume-based [for me].
A few questions that the interviewer asked me after the introduction were:
- ML algorithms like k-nearest neighbour, K means clustering, Linear Regression (Explanation and differences majorly)
- Dijkstra’s algorithm and the problem associated with it (doesn’t work for negative edge weights so we use the Bellman-Ford algorithm).
- Which of the Dijkstra and Bellman-Ford algorithms is more Greedy?
- Pseudo code for Dijkstras algorithm
- Working on Bubble/Selection and Quick Sort.
- Code for Merge Sorting.
- Write a function that returns 2 when we pass the value as 3 and returns 3 when we pass the value as 2 without using any conditional statements. (I made use of Array indexes: arr[2] = 3 and arr[3] = 2. However, returning 5 – value works too)
- Difference between WHERE and HAVING clause in SQL.
- What is the Coalesce statement in Sql?
- Given a number. Find the smallest number of the same length that can be formed using its digits.
- Any questions for me?