Data integration
Tell me about the most complex data integration environment you’ve built or supported.
What did you use for ingestion and orchestration?
How have you implemented metadata-driven ingestion?
Fabric/Synapse
What have you actually built in Microsoft Fabric or Synapse?
How have you structured a lakehouse?
Explain how you’ve implemented Bronze/Silver/Gold or another medallion approach.
PySpark
How extensively have you used PySpark?
Give me an example of a transformation or data-processing problem you solved with PySpark.
Data modeling
Describe your experience with fact and dimension tables.
How do you approach normalization versus performance considerations in a lakehouse?
Microsoft generalist
Which Microsoft/Azure technologies are you strongest in?
Which ones have you had to learn on the fly?
Tell me about something you had never used before and how you got productive with it.
Power Apps
What Power Apps experience do you have?
Have you worked with Power Automate?
Don’t require an expert, but look for enough exposure that the candidate can contribute when needed.