Big Data Consultant Interview Questions

1,784 big data consultant interview questions shared by candidates

to write SQL queries and Pyspark coding to load, filter, aggregate and save as another new table, strategies to design ETL validations to merge to consume kafka and s3 bucket files. Strategies to consume data from s3 bucket focusing on spark architecture, designing clusters, shuffling, narrow/wide transformations, authenticating Azure data lakes, resource manager in spark.
avatar

Lead Big Data Engineer

Interviewed at Citibank

3.6
Jul 3, 2025

to write SQL queries and Pyspark coding to load, filter, aggregate and save as another new table, strategies to design ETL validations to merge to consume kafka and s3 bucket files. Strategies to consume data from s3 bucket focusing on spark architecture, designing clusters, shuffling, narrow/wide transformations, authenticating Azure data lakes, resource manager in spark.

Three Rounds: First : - Technical Interview : - Happened for 40 mins around. Asked questions regarding the technologies you've worked on. Second : - Coding round. They gave a scenarios and asked to code in all four big data applications - Mapreduce, Hive, Spark, and Pig (i didn't attempt pig code since i was running out of time). They ignored syntactical errors. Only approach is what they looked for. Third Round: - Technical interview. It went for over 1 hour 40 mins. He asked all the scenarios based question. He was happy with my answers. After that i was told that i was being selected and called for salary discussion and agreed on some package. And surprisingly i received package which was way too less than what we agreed for. *So interview experience was good but Worst HR process*
avatar

Big Data Developer

Interviewed at Datametica

3.4
Jan 19, 2019

Three Rounds: First : - Technical Interview : - Happened for 40 mins around. Asked questions regarding the technologies you've worked on. Second : - Coding round. They gave a scenarios and asked to code in all four big data applications - Mapreduce, Hive, Spark, and Pig (i didn't attempt pig code since i was running out of time). They ignored syntactical errors. Only approach is what they looked for. Third Round: - Technical interview. It went for over 1 hour 40 mins. He asked all the scenarios based question. He was happy with my answers. After that i was told that i was being selected and called for salary discussion and agreed on some package. And surprisingly i received package which was way too less than what we agreed for. *So interview experience was good but Worst HR process*

Viewing 1571 - 1580 interview questions

Glassdoor has 1,784 interview questions and reports from Big data consultant interviews. Prepare for your interview. Get hired. Love your job.