Easy to intermediate questions. Sorting algorithms, find a median of a given list, oops concepts, basics of data structures and some design related questions. SQL questions like find Max salary, find first 10 salaries from individual department of a given table, pandas basic questions like, how do you sort columns, renaming a column, renaming a particular function, data frame operations

I have attended virtual interview for python developer. HR called me and arranged me for the interview. I have called back and said this role I received in email was for the position of data engineering specialist. I have clearly mentioned that as I am a python developer with experience into building web application and automating ci/cd in devops. The interviewer had asked me to write a python code I have completed it with expected output within 5 mins. He asked me another pandas question I honestly answered I'm not into data engineering. HR told that this position is for python developer and not specifically data engineering. Next, same hr again arranged interview. I double checked that this time also same specialist data engineering. But she said it is for python developer. Interviewer name is vijetta, she gave me two problems one is print alternate values in a list which I achieved using increment step in for loop. Second questions was two sum. At first I solved using naive approach in O(n²). Later that she asked what is time complexity can you reduce to n. I explained the approach it can be stored in a dictionary and we can accomplish in one for loop. She told that.. you do not need to write a code and logic is enough. Secondly I was asked to write a sql query for 2nd largest and nth largest. I achieved that using limit and offset. She agreed on that solution. Next was to get the corresponding empid and manager name from the employees table. I used self join and showed the expected output. But useless interviewer rejected me saying I'm not able to do complex logic. The interview was kept for name sake. If you have your personal preferences then why are you wasting someone's time. I saw the true colors of the interviewer working there. Totally a waste of time. In future I'll never consider this company to join. Poor management and poor interviewer without proper knowledge