Technical coding involves advance level of SQL CTEs and Window functions where u have to calculate salaries based on dates spread over months. Technical depth involves discussion regarding past projects and then some warehousing questions like dimensional modelling and a lot of questions will be picked just from your answers.