It was a great process. I applied through a recruiter who contacted me on LinkedIn. We then set up a call to chat about my experience and the interview process. We scheduled a technical round, and I was able to answer 3 SQL and 2.5 Python questions. It looks like I needed at least 4 SQL and 4 Python questions to get to the next round, so my journey ended here.

Sales Schema

+------------------+---------+ | product_id | INTEGER | | store_id | INTEGER | | customer_id | INTEGER | | promotion_id | INTEGER | | store_sales | DECIMAL | | store_cost | DECIMAL | | units_sold | DECIMAL | | transaction_date | DATE | +------------------+---------+

+---------------------+---------+ | product_id | INTEGER | | product_class_id | INTEGER | | brand_name | VARCHAR | | product_name | VARCHAR | | is_low_fat_flg | TINYINT | | is_recyclable_flg | TINYINT | | gross_weight | DECIMAL | | net_weight | DECIMAL | +---------------------+---------+

+------------------+---------+ | promotion_id | INTEGER | | promotion_name | VARCHAR | | media_type | VARCHAR | | cost | DECIMAL | | start_date | DATE | | end_date | DATE | +------------------+---------+

+---------------------+---------+ | product_class_id | INTEGER | | product_subcategory | VARCHAR | | product_category | VARCHAR | | product_department | VARCHAR | | product_family | VARCHAR | +---------------------+---------+

Question 1:

What percent of all products in the grocery chain's catalog are both low fat and recyclable?

Question 2:

What are the top five (ranked in decreasing order) single-channel media types that correspond to the most money the grocery chain had spent on its promotional campaigns?

Question 3:

% Of sales that had a valid promotion. The VP of marketing wants to know what % of transactions occur on either the very first day or the very last day of a promotion campaign.

Question 1:

Complete a function that returns the number of times a given character occurs in the given string.

For example:

- input string = "mississippi"

- char = "s"

- output : 4

Question 2:

Fill in the blanks.

Given an array containing None values, fill in the None values with the most recent non-None value in the array.

For example:

- input array: [1, None, 2, 3, None, None, 5, None]

- output array: [1, 1, 2, 3, 3, 3, 5, 5]

Question 3:

Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings.

For example:

- string 1 : "Firstly this is the first string"

- string 2 : "Next is the second string"

- output : ['Firstly', 'this', 'first', 'Next', 'second']