Tredence Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 113 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Tredence.
Tredence
Business Analyst
Senior Average Positive experience Accept offer 4 rounds
Interview process
Technical screen Onsite Background check Offer
Interview formats
Technical Coding Behavioral Presentation
3 virtual rounds happened. The first round was a technical round focused on SQL and Tableau. The second round was a business round covering your understanding and past projects. The third round was a mix of business and technical, discussing how to solve business problems using methodologies. After these rounds, there was an HR round for salary negotiation.
Confirmed questions4 questions
- What are the basics and theory behind SQL and Tableau?
- Can you write SQL queries for the count of orders?
- Can you write SQL queries for shipping losses?
Tredence
Business Analyst
Mid Average Positive experience Accept offer 3 rounds
Interview process
Recruiter call Technical screen Onsite Offer
Interview formats
Technical Coding Presentation
The interview process was quite good. The interviewers were fair in their questioning and didn't ask questions that were technically sound but irrelevant to the industry. Although I applied for a BA role, during the interview, they realized I might be a better fit for a Sr. BA position. I'm very thankful to Tredence for this wonderful interview experience.
Confirmed questions6 questions
- Could you answer some SQL questions that require knowledge on RANK() and SUM() OVER()?
- Do you have knowledge of LEAD()?
- Do you have knowledge of LAG()?
Tredence
Business Analyst
Senior Easy Negative experience No offer 4 rounds
Interview process
Technical screen Technical screen Presentation Panel
Interview formats
Technical Coding Case Behavioral
I managed to get through all 4 interview rounds which took up the whole day. The first round was a technical one focused on SQL queries like basic joins. The second round was optional and for my profile, it was another technical round where I had to answer Python questions. The third round was a business-focused case study to check my problem-solving and decision-making skills, where they cared more about my approach than the answer itself. The final round was with a manager, testing my domain knowledge and some basic HR questions. The HR team was pretty bad, they never updated me on my offer status, very unprofessional and negligent.
Confirmed questions2 questions
- Can you explain CTE expressions?
- How do you perform basic joins in SQL?
Tredence Business Analyst Interview Questions
Quoted word for word from Tredence interview reports.
“Given a car with a spare tire, and each tire lasts only 5 km before bursting, what is the maximum distance the car can travel?”
Read reports →“How many ways can you place two kings on a chessboard so they don't attack each other?”
Read reports →“Given a coin flipped 40 times resulting in 38 heads, what is the probability of getting a head on the 41st flip?”
Read reports →“How many tennis balls do you think were sold in India over the course of a year?”
Read reports →“Puzzle: A car has 1 spare tyre and each tyre can run a distance of 5 km before it completely wears out. How much distance it could travel with these five tyres at max?”
Read report →“If a class has 40 boys and 30 girls, what is the probability that the class leader chosen is a boy?”
Read report →“Using two ropes that burn non-uniformly in exactly one hour, how would you measure a duration of 45 minutes?”
Read report →“Given 3 boxes with a mix of white and black balls, what's the probability the randomly selected black ball came from box 2?”
Read report →“Regarding a triangle with three people on each vertex and a fourth person in the middle, if the middle person shouts "GO" and the three people move in any direction along the edges, what's the probability that two will meet?”
Read report →Formats, difficulty and experience
Across all 113 Tredence interview reports.