How did the virtual interview go?
For the role of technical mentor for the coursework for the Nxtwave intensive programme.
I received a call from the coach of my NxtWave Intensive 3.0 course on 27th August 2025. I got informed that I will undergo an interview with the placement team tomorrow and confirmed my timing. I said that I will be available around 16:00 - 18:30 on 29th August 2025.
My interview was conducted by a male member of the placement team.
In which programming language do I get questions?
The placement team members asked two questions in Python and a few in SQL.
In Python, I got questions related to
- Find the index of two numbers to the target sum
- Maximum Profit of the stock during the day
In SQL, I got questions related to the database using joins and queries.
- Find the city from the location table where the employee ID is 120.
- Find all details of employees where the department is IT and finance from the employee table.
- Show employees who work on projects outside their department.
My approach to the Maximum profit you can achieve from the transaction.
# You are given an array prices where prices[i] is the price of a given stock on the ith day.
# You want to maximize your profit by choosing a single day to buy one stock and choosing a different day in the future to sell that stock.
# Return the maximum profit you can achieve from this transaction. If you cannot achieve any profit, return 0.
# Example 1:
# Input: prices = [7,1,5,3,6,4]
# Output: 5
# Explanation: Buy on day 2 (price = 1) and sell on day 5 (price = 6), profit = 6-1 = 5.
prices = [7,1,5,3,6,4]
min_ele = min(prices)
profit = prices[-1]
for pos in range(0, len(prices)):
for index in range(pos +1 , len(prices)):
if prices[pos] - prices[index] > profit:
profit = prices[pos] - prices[index]
print(profit)
My approach to finding the index of two numbers to the target sum.
# Given an array of integers nums and an integer target, print indices of the two numbers such that they add up to target.
# You may assume that each input would have exactly one solution, and you may not use the same element twice.
# Example 1:
# Input: nums = 2 7 11 15 target = 9
# Output: [0,1]
# Explanation: Because nums[0] + nums[1] == 9, we print [0, 1].
# Example 2:
# Input: nums = 3 2 4 target = 6
# Output: [1,2]
# Example 3:
# Input: nums = 3 3 target = 6
# Output: [0,1]
arr = list(map(int,input().split()))
target = int(input())
for ele in range(0, len(arr)):
sum_of_el = arr[ele]
for pos in range(ele, len(arr)):
if(sum_of_el + arr[pos] == target):
print([ele,pos])
else:
print("no ")
The different queries that were asked by the mentor in SQL are given in a single code.
select
city
from
locations
join
employees on employees.department_id = department.department_id
join
department on locations.location_id = department.department_id
where employees.emp_id = 120
select
*
from
employees
join
department on department.department_id = employees.department_id
where
department.department_name = 'IT' or
department.department_name ='Finance'
-- Show employees who work on projects outside their department.
SELECT
*
FROM
employees
JOIN department ON employees.department_id = department.department_id
JOIN employee_project ON employee_project.emp_id = employees.emp_id
JOIN projects ON projects.project_id = employee_project.project_id
WHERE
project.department_id NOT department.department_id
After which I asked about the feedback of the mentor, for which he replied You will be informed by the coach.
At which I came to know that I had undergone an interview for a "Teaching post" at the NxtWave and was asked to join from September.
The feedback was that I perform well with some training, he can speak more confidently and loudly and guide the students.
I replied to the coach that I am looking for a software development role instead of teaching.
Final Outcome
I hope you find some useful information. The code provided may not work perfectly with the Python ones, but the approach I explained, which got placed in the mentor role, but I was looking for a development role.