I applied online. The process took 5 days. I interviewed at Simform (Ahmedabad) in Oct 2023
Interview
Never seen this type of interview process before, it's harder than any of the Companies from my experience (waste of time) Liked: 1. Questions were asked from all areas but they covered only limited topics and the interview was not interactive, a simple formal interview where the interview asked some questions from the sheet and we had to answer only. Not like: 1. I do not judge the Interviewer from only 90 mins but he is *Narcissistic* 2. In the interview for questions when I asked for an explanation for questions, the interviewer said we needed someone who could directly work without asking questions, and no hint was provided. 3. For the same question Interviewer didn't ask DS or Algo / Core Python in an interview he wanted me to write a program for AWS/GCP *without using the Internet in 15mins only* 4. It's like the interviewer is expecting the same answer that he knew for all the questions.
Interview questions [1]
Question 1
1. Explain Spark architecture 2. How to extract data from Third-party API using Spark streaming? 3. What is Debezium? 4. Left join related SQL question 2-3 practical scenario-based questions (duration 30mins) 1. Write an ETL pipeline using Spark/Pandas (no question explanation will be provided when asked) 2. where we have to code in AWS(boto3) or GCP without any internet help, the document is also not proper they have inconsistency in the database schema.