Interview happened for 1.30 hrs and question was all about python and complex SQL queries. also asked some basic theory questions about python like Lambda , list comprehension and basic questions on window functions like union, union all and nvl functions etc..