Recruiter contacted me through LinkedIn.

First phone screen by recruiter about my overall experience, whether it's relevant or not.

Recruiter clarified the salary range.

Second round: Technical phone screen.

Third round: Director for behavioral and situational questions.

Technical

1. What is better as a primary key: a surrogate key or a natural key in data modeling? Explain what to define and when, with examples.

2. Describe projects you have worked on and the steps you follow for data modeling.

3. Identify the top three challenges you have faced on the design and technical sides. Then, provide detailed questions related to each challenge.

Behavioral, Team Skill, and Situation-Based Round

1. How will you manage multiple projects, and what actions will you take in case of conflicts?

2. Provide an example where you have led by example.

3. Share an example of teamwork and describe a knowledge-sharing session you conducted for your team.