I interviewed for a Senior Data Engineer position at Visa in Bengaluru in October . The interview process consisted of an online assessment, followed by two video interview rounds.
The online assessment included three coding questions: two medium difficulty and one hard difficulty. The questions were as follows:
The first video interview round was a coding round with two questions: one easy and one medium difficulty. I cannot recall the first question clearly, but it involved HashMaps and arrays. The second question was: Given a list of ranges and a target number, find in which range that target number will occur. If not found, return "-".
The second video interview round was a Data Engineering round with three questions: one coding and two SQL. The first question was the same as the second question from the first round, but the input data was given in the form of a table, requiring some preprocessing. The second and third questions were basic SQL queries involving GroupBy and Year-Month GroupBy, respectively.
The interviewer in the second round seemed to be in a hurry and was constantly jumping from one topic to another, which made the interview experience less than ideal. Ultimately, I was rejected for the position.