Location: Bangalore
Role: Principal Engineer
Experience: 8+ Years(Worked for FAANG companies)

Though my profile is mostly based on Software Engineering but still they interviewed me for ETL.

Round 1:

SQL vs NOSQL

Create a recommendation engine similar to Netflix and Spotify.

Round 2:

Program to extract all unique elements from a stream

Program to evaluate a expression but mostly using OOP Principles("10+20","20-10")

Round 3:

1). Real-world examples of abstraction vs. encapsulation
2). .net Core vs .net framework
3). SDLC Concepts
4). Design an ETL System
5). Examples of the Publisher/Subscriber
6). Enterprise Integration Patterns in the context of ETL(Message Id and Correlation Id) (How to handle error scenarios given the heterogeneity of the source systems)

Verdict: Reject