VISA | Senior Data Engineer | Bangalore | Rejected

Company : VISA
Position : Senior Data Engineer

Round 1:

• Hadoop basics ( Rack awareness, replication , namenode vs data node , hdfs commands , how to replace a file in hdfs , how to copy from local , remove files without going to traash, what happens if one block is lost)
• Hive → We have 10k records in a partition we got an update of 200 records , how will you update there is no timestamp column for de duplication , write sql.
• Spark basics , udfs etc..,

**Round 2: **

• DSA simple python on hashmap & lists
• Questions on spark optimizations , Partitioning va bickering
• If you have to ingest a csv file what are all steps you will take ( from source till partitioning on destination )

Round 3:

• Project discussions & Behavioural questions

Veridct: Rejected. They liked my profile but due to compensation ask they didn't offer me.