Both interview took around 30min (tech) and 10-15 min (HR) The technical interviewer started with my introduction, and then he explained what are the technologies that company is working on. 1: Rate yourself on a scale of 5 on SQL. I rated myself between 4 and 4.5. 2: He made 2 tables on the board and asked the output table if (left join) is performed (he also asked to write a query for (left join) on the table). 3-window functions 4: Alter table 5: SQL Constraints and the Results in the Table  6: Have you ever used SQL on any project, and what Then he started with Python. 7: He created a list and asked to get the range of data (basically, he wanted to understand my hand on array indexing). 8: In the same way, some output-based questions on python sequences,sets and dictionaries 9: I had mentioned big data technologies on my CV, so he went through Hadoop technology and my understanding, 10- Data visualisation - I was comfortable with POWER BI. 11- General idea about ETL (EXTRACT, TRANSFORM, LOADING) I was also asked how flexible I'm to learn different technologies and work on them. He opened me up to asking anything from my side, and we had some personal discussion and roadmap for internal career growth.