Tredence Analyst Interview Questions, Process, and Tips

Q1. More on guesstimates
Add your answer

Round duration - 120 Minutes
Round difficulty - Medium

It had multiple reasoning, aptitude questions, pseudo codes and there was one guesstimate and an essay.

Q1. Puzzle
Guesstimate on how many people uses mobile phones in India
Ans. 
Tip 1 : Try to narrow down the problem first before writing.
Tip 2 : Use proper description of every step.
Answered by CodingNinjas
Add your answer

Round duration - 20 minutes
Round difficulty - Medium

It was a technical round

Q1. DBMS Question
Medium level SQL queries were asked on joins, pivot.
Ans. 
Tip 1 : Do practice SQL queries.
Tip 2 : I had used MSSQL which had various in built functions which helped.
Answered by CodingNinjas
Add your answer

Round duration - 25 minutes
Round difficulty - Medium

Programming Questions were asked

Q1. Technical Question
How to change the data type and push the data into a database?
Ans. 
Step 1 : Using pandas to get the data type using pandas .info()
Step 2 : Used as_type()
Step 3 : Put the data as a data frame.
Step 4 : Using sql alchemy to push the data into the sql database.
Answered by CodingNinjas
Add your answer