u/Friendly_Wafer_5137

Citi Bank Interview

Yesterday I had the Citi Bank Data Engineer interview and they asked a few spark internal questions and one spark question and 1 SQL question.

Spark question was to read data from hive and return second lowest salary.
SQL question was to find the top 5 sales revenue wise

SQL question I wrote perfectly and in pyspark question I made a mistake, instead of asc() I gave desc() bymistake bcz interviewer said we are running out of time, call was only 30 min, I really felt time constraints. And in hurry I wrote desc thinking question is to find the second highest salary. And interviewer also didn't say anything. Rest everything was perfect from syntax to all other logic.

Will I get rejected on this?

reddit.com

u/Friendly_Wafer_5137 — 11 days ago

▲ 16 r/dataengineersindia

A few weeks back I gave an interview at optum, The questions were intermediate level and I answered all. But still got rejected stating the reason " business decision".

But which ever role I apply, I get rejection mail within second and application status turns into no longer under consideration.

Is that they blacklisted me?

u/Friendly_Wafer_5137 — 16 days ago