Visa | Senior Data Engineer | Bengaluru | Oct 2022 [Reject]

Anonymous User
839

Online Assesment (Hackerrank Exam)

  • 3 Coding Questions
  • 2 Medium 1 Hard

Q1) Matrix reverse diagonal traversal
Q2) Given a pair of integers (a,b) validate if after performing certain operation zero or multiple times it can be converted to (c,d)
Q3) Given 2 arrays, find minimum moves to match array 1 and array 2. Move is defined as an increment or decrement of one element in an array.

Round 1: Video Interview | Coding Round

  • 2 Question
  • 1 Easy 1 Medium

Q1) Cant remember clearly but mostly around HashMaps and arrays. Simple Enough
Q2) Given a list of ranges and a target number find in which range that target number will occure if not found return "-"

Round 2: Video Interview | Data Engineering Round

  • 3 Questions - 1 Coding 2 SQL

Q1) Was asked the same Q2 from R1 but this the input data was given in the form of table so it requires some preprossing.
Q2) Easy GroupBy sql Query
Q3) SQL query for Year - Month GroupBy, For a given year current month value should be total to this month + previous months values

  • Some Spark related questions

In this round interviewer seemed to be in a hurry and was constantly jumping from 1 thing to another as if he was not interested in taking the interview and wanted to just get over with it. Not the best experience.

Verdict: Rejected

Comments (2)