It was for a data role, and the process was the normal one for a big tech company:

• Recruiter screening
• First tech screening (hard SQL and Python)
• Onsite, which consisted of:
  • One meeting with the hiring manager
  • Data modeling
  • The last coding round

I didn't have a match with any interviewer. Funny enough, all of them told me Pinterest has a great culture and people, but every interviewer was serious and indifferent. On my last coding interview from the onsite, the interviewer didn't arrive, and they told me they wouldn't reschedule due to my rejection.

SQL hard, consisting on joining multiple tables and using window functions in order to calculate a metric.