i'm going through a BofA loop for a data engineering role on the Enterprise Data platform team. recruiter told me to expect SQL, system design, and behavioral rounds but wasn't specific about the format.
anyone been through the tech interview track recently, say last 6-12 months? specifically curious about: how heavy is the SQL? like window functions, or deeper? is there any spark/pipeline design component or is it more conceptual? how many rounds total for a senior IC level?
any data points from other functions welcome too, just want to get a feel for how the loop runs.
4 replies
backend_bekah
went through a data platform interview at BofA about 8 months ago. SQL was genuinely hard, not filter-and-group stuff. partitioning, window functions, ranking, and one question that involved recursive CTEs. the system design round was more conceptual but they cared a lot about data lineage and auditing, which makes sense for a bank.
de_derek
lineage and auditing, that's a useful signal. makes sense given the regulatory requirements. good prep angle.
corp_refugee
spark came up for me at the senior level. nothing too hairy but you should be able to talk about partitioning strategy and why your choices matter at scale. they're not looking for magic, they want to see you think about operational costs.
staff_steph
four rounds when i interviewed at senior IC, not counting recruiter screen. two technical, one behavioral panel, one with hiring manager. could vary by team though.