Top 17
Prep plan
Updated weekly · Last refresh Oct 17

TTT Software Engineer Interview Questions

The questions to prepare for a TTT Software Engineer interview. Questions from real interview reports rank first. Updated daily.

17questions
~3htotal time
Track your progressSign up free to work through all 17 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions + 1 drill · ~63 min
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsTTT
Optimize Complex SQL QueryHard

Tests your SQL performance troubleshooting approach, including query plans, indexing, and rewrite strategies.

Performance TuningJoinsAggregationsTTT
Window Functions for RankingHard
Practice

Rank Whova attendees by total engagement and calculate each user's chronological running engagement total.

Window FunctionsRankingRunning TotalsTTT
SQL Window Functions for Campaign RankingMedium
Practice
Practice drill

Rank campaigns by advertiser performance and calculate campaign-level running conversions over time with PostgreSQL window functions.

Window FunctionsJoinsData ManipulationStackadaptLiveRampAmazon Advertising
More SQL & Data Manipulation questions with a free account
2
Coding4 questions · ~43 min
Python Memory Management ExplainedEasy

Explain how Python manages memory using reference counting, garbage collection, and object allocation.

Hash TablesArraysStringsTTT
Python String UtilitiesEasy
Practice

Implement a string reversal or palindrome check using direct character processing.

Basic AlgorithmsStringsloopsTTT
Lists vs Tuples in PythonEasy

Tests your understanding of Python data structures and appropriate selection for maintainability and performance.

basicspythonoopTTT
More Coding questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership7 questions · ~75 min
Connecting Goals to the RoleEasy

Tests self-awareness and whether the candidate can connect long-term career goals to the role in a specific, credible way.

career goalsrole fitmotivationTTT
More Behavioral & Leadership questions with a free account
4
More topics1 question · ~11 min
Exception Handling Best PracticesEasy

Tests your ability to write robust Python code with clear error handling and maintainable structure.

basicsTestingpythonTTT
The finish line: interview-readyComplete all 17 questions plus 1 hands-on drill to finish this plan.