Data Engineer Interview Experience - Irving, Texas
Process
First technical round was over video call, mostly asked about experience and tools that I worked on based on the profile.
Second technical round was a F2F with 2 leaders, One who went on by asking technical questions starting from migration projects to optimization techniques. Other person asked about overall project scope and agile methodologies.
Questions
Handling SCD 2 in Hive.
Oozie based questions, where to schedule, how to call Oozie, where to view Oozie job execution, what does coordinator do, how to set dependency when executing few actions.
Shell based questions, how to find difference between 2 files, how to execute code in backend, how to schedule jobs using shell.
Spark optimization techniques, partitioning, bucketing, salting, repartition, coalesce, file formats.
Existing job is running smoothly but suddenly one day it has executed for a longer time how do you identify the issue.
Word count code in any language.
Was this helpful?
Interview Statistics
The following metrics were computed from 1 interview experience for the Citigroup Data Engineer role in Irving, Texas.
Success Rate
Citigroup's interview process for their Data Engineer roles in Irving, Texas is extremely selective, failing the vast majority of engineers.
Experience Rating
Candidates reported having very good feelings for Citigroup's Data Engineer interview process in Irving, Texas.
