Contractor Developer Assessment

First and Last
Show how you would convert DateTime.UtcNow into central time zone.
IMyInterface proxy = Factory.Create<IMyInterface>();
A database table called “Listing” exists with the following fields: ID (int, pk), Name (varchar), IsPromoted (bit). Write a SELECT statement that accepts @Query as input, and returns all entries from this table with a partial match on this. Promoted listings, if they exist in the results, should be boosted so that they appear in every odd result, starting with position #1.
Write the HTML for a form, asking the user for their name, email and phone number.
List any tools a developer might find helpful in answering questions 1-4.
Describe a recent situation where you told a client or senior that a requested delivery date was unrealistic. How did you communicate it and what was the outcome?
If you realize a feature you own is trending 40% over estimate, at what point and how would you surface that? Also, describe a specific situation in detail where you have seen this occur.
Tell us about a time you disagreed with your tech lead’s solution. What did you do?
Our core collaboration window is 08:00–11:00 CST (18:30–21:30 IST) Mon-Thu. Can you commit to those hours for meetings and quick turn-arounds? Anything that would prevent it?
You receive a one-paragraph feature request with no wireframe. Outline your first three steps.
Rewrite this requirement as a clear acceptance-criteria list in Gherkin “Given/When/Then” format: Build a date range picker that defaults to last week.
Explain how you would profile and fix a slow LINQ query hitting SQL server.
Give an example of a recent PR where reviewers requested changes. Summarize the feedback and your adjustments.
Tell us a little bit about the things you enjoy outside of work. For example, what are your favorite movies, TV shows, books, or games?