A recruiter reached out to me for an initial phone screen. They then set up a one-hour phone screen with a Data Engineer that covered SQL and Python. I answered all of the questions correctly but needed help on the final Python question.

The recruiter reached out to me again, and I had to do a second coding screen, similar to the first. This time it was strictly on Python. I got all correct, but I stumbled on the final Python problem.

A couple of days later, the recruiter reached back out to me with feedback, some positive and some mediocre. I was told I needed more experience and a better thought process. Therefore, I did not move to the onsite interview.

I enjoyed interviewing, though; the interviewers were nice.

Python

• Count distinct words in a sentence.
• Count the number of times a word appears in a sentence using a Hash Map.
• Return tuples of a list, matching each item to another item.
• Count the number of times a substring appears in a string.

SQL

• Return the minimum and maximum age of males and females who bought a product.
• Count the number of stores in a state with a grand total of greater than or equal to 25,000 square feet.