Video Call Interview
Datawarehousing Scenarios
Data Modeling
Performance Tuning
Materialkzed Views
Index
Primary Key
Duplication Removal
Parent Child Relationship
Data Security
Star Schema
Snowflake Schema
Data Wrangling
Flattened Table
All are scenario based questions raised and it was technically enriched questions
SDLC PROCESS, Dev, Test, Prod environments, other deployment techniques
2-3 technical interview on the core skills and then on core values. 1 HR interview. It takes around 2-3 weeks to complete from first round to offer. Questions on the architecture and solutions.
Interview questions [1]
Question 1
What is the current end to end architecture of your system
I applied through a recruiter. I interviewed at Barclays
Interview
Phone interview. Initially didn't call me at all and claimed they did. Second attempt with the phone interview was long and never heard back or my progress online has been updated.