I applied through an employee referral. The process took 3 weeks. I interviewed at Tredence (Bengaluru) in Sep 2021
Interview
It was very decent. The folks who took my interview, were very balanced in questioning and didn't bore me with technically sound industry irrelevant questions. Also, even though I had applied for BA role, upon interviewing me, the interviewer felt that I would suit the Sr. BA profile. I really thank Tredence for such an amazing interview process.
Interview questions [1]
Question 1
SQL Questions which will require knowledge on RANK(), SUM() OVER().
I suggest HackerRank SQL for handling the SQL questions. Knowledge of LEAD(), LAG(), and knowledge of HiveQL will be great, though HiveQL is not a mandatory skill but it definitely adds weight to your candidature. In case of HiveQL focus on Partitioning and Bucketing concepts and get an idea on how Map-Reduce thing takes place in an distributed environment.
Basic Tableau Stuffs.
Some of Python DataFrame operations like creating a DF from dictionary or list of tuple.
They majorly asked Business cases. They also asked a few guesstimates. They also discussed in detail about my previous work experience. Overall, i had 3 interviews in the process for the role
I applied through college or university. I interviewed at Tredence (Durgapur, West Bengal) in Dec 2022
Interview
2 tech rounds 1 hr round,SQL project guesstimate,puzzle were asked in the interview process of Tredence placements .before that one 120 minutes exam was held of 35 questions ,3 coding 1 essay writing 1 guesstimate questions asked
Interview questions [1]
Question 1
2 tech rounds 1 hr round,SQL project guesstimate,puzzle were asked in the interview process of Tredence placements .before that one 120 minutes exam was held of 35 questions ,3 coding 1 essay writing 1 guesstimate questions asked
First round consists of online Aptitude and programming test and duration was approx 90mins also includes an essay
Within 7-8days after clearing the test got a call for scheduling the final interview
Final round- Interview with senior manager
Interview questions [1]
Question 1
Rate yourself on the programming skills you know.
Few questions revolved around essay which I wrote during test
Where do you see yourself in 5 years?