The interview process is offline. They asked question of Spark and SQL. They will ask you to solve each problem from both SQL approach and Spark approach. I got selected but I disappointed with the HR, after so many discussion they told that we don't have that many budget.

Unfortunately, my experience with the interview for the Data Engineer position at Infogain was disappointing for several reasons. The recruiter seemed unprepared and uninformed about the requirements for the role. This lack of knowledge was evident in the conversation, as they had not reviewed my resume beforehand, which undermined the efficiency and purpose of the interview. Additionally, the recruiter exhibited minimal interest during the interaction, which gave the impression that the interview was conducted merely to fulfill a quota of candidates rather than as a genuine effort to assess my suitability for the role or provide meaningful insights about the company and position. Given this unprofessional approach, I cannot recommend this interview process to other candidates, as it failed to meet the basic standards of respect and engagement expected during recruitment.