TLDR: Know Basic/Intermediate SQL commands like Joins, Unions, Cases, etc. I applied through LinkedIn. The total process took a week and a half. The first email was from a recruiter asking me to answer a few questions so the team could get a better understanding of why I was interested in the position, my experience background, and a few other things. A follow-up email was received a few days later with details for a videoconference between me, the hiring manager, another manager, and two similar level associates of the position, The videoconference was pretty standard - the hiring manager did an overview of the role, and then I went over my background and relative experience. The other members of the call then asked me technical questions related to SQL and to walk them through a Python script I had wrote. I withdrew after the videoconference because it did not seem like a good fit from a technical standpoint. Overall though everyone was very professional and attentive.