I applied online. I interviewed at Infosys in Jan 2017
Interview
good one and logical process. Entire process is smooth very hr oriented. Having two round one is technical and second one is hr round, it takes almost more than two weeks.
I applied through a staffing agency. I interviewed at Infosys (Gurgaon, Haryana) in Oct 2017
Interview
I reached at exact timing mentioned. Since I was first to reach at the venue, I was taken to interview room straight away (after filling few docs which took about 10 mins). My interviewer seems to have just landed in Gurgaon and read my Resume and started asking me section wise initially starting with brief description of my work. My interview lasted about 55 minutes.
Interview questions [5]
Question 1
Map Reduce: Program on combiner, what is partitioner, Shuffle. Few other questions were also asked which I don't remember
Hive: Bucketing, Partitioning, Internal and external tables, ORC format, Internal logic of compression in Hive, Write a DDL for external table using partition on a particular column. How many partitions should be used ideally and how to calculate that. Performance enhancement of Hive was also asked and each of the options I gave like vectorization, Tez, strict mode was asked in detail. Distribution by, group by was also asked. I was asked to write few sample queries bases on particular scenarios
SQOOP: Basic questions like how to import data, how to import metadata of a table, exclude table from list of tables in database, how to load in HDFS in incremental mode. I was asked to write certain queries based on scenario which ranged from easy to medium difficulty level.
Spark: Spark was asked in detail and question ranged from easy to medium hard level. RDD, Types of RDD, Dataframes, Datasets, how to implement them (by writing code on paper), optimization of spark code, application master and its functionality. Difference between Df and Datasets and which is better. Why dataframes are used if Datasets provide better functionality. Lot many things were also asked which I don't remember now
I applied online. The process took 2+ months. I interviewed at Infosys (Chennai)
Interview
Through online job portal I applied. Within two weeks I was called for interview. The process and the interview was good. But they offered only 15% hike. So I didn't accept.