Interview Experience at Tredence

I participated in the campus recruitment drive by Tredence for the Analyst role. The entire selection process was conducted offline over two days, starting from a Pre-Placement Talk and concluding with the HR round.

Round 1: Online Assessment

This round was held offline at the campus Digital Library, utilizing the HackerEarth platform. Approximately 400 candidates participated, and about 25-30 were shortlisted for the next stage based on their scores. The 2-hour assessment included multiple-choice questions on Aptitude, English Grammar, and basic CS fundamentals (30-35 questions), one case study, and one coding question. The DSA problem was of medium difficulty, similar to a standard LeetCode problem, but required some innovative thinking rather than being a direct standard problem. I do not recall the exact problem statement. Each section had its own marking scheme and cutoff.

Round 2: Communication Round

This round took place on the Mettle platform and consisted of 3-4 sections. I was asked to read statements displayed on the screen and speak continuously about myself for 1-2 minutes, among other tasks. After this round, about 5-6 candidates were eliminated.

Round 3: Technical Round 1

My interviewer was very friendly. After introductions, we discussed SQL and Data Structures & Algorithms. For DSA, I was asked the 'Coin Change' problem, a classic LeetCode problem. The SQL questions were tricky but manageable if one had clear fundamental concepts. Some candidates were also questioned about their internships and side projects, and some faced Linked List related problems.

Round 4: Technical Round 2

This interviewer was stricter, I believe he was an MD at Tredence. He posed challenging SQL questions and their practical implementations, requiring me to write queries on the spot. Specific functions like COALESCE were discussed in detail. My projects from my resume were scrutinized in depth, and it was clear that a thorough understanding of everything mentioned on my resume was essential. Basic Computer Science Fundamentals, particularly from DBMS, were also covered. I was asked about ACID properties and transaction states. After this round, 8 candidates were shortlisted for the HR round.

Round 5: HR Round

This round focused on behavioral questions about my background, hobbies, academic major/minor projects, and future goals. The HR also discussed the company's pay structure. It was an elimination round, with 2-3 candidates being deselected even at this stage, but almost everyone who reached this round secured an offer.