Round 1: Technical written test on SQL, Big Data, Cloud technology, and Python/Shell Scripting.

Passed the first round.

Round 2: Technical Interview (In person at the office).

1. Asked how to implement SCD type 2 and, after that, implement the same without using SQL in Python (out-of-the-box scenario).
2. Python: Convert every word in the string to initcase. I created a function with capitalize, then they told me not to use built-in functions like capitalize. I was unable to do it without any built-in functions. They told me that we can use the split function. Is the split function not a built-in function?
3. Asked me Snowflake-related questions, like Snowpipe.
4. Asked me to count all 's' in a column.

sql select regexp_count('snake in the san boots','s{1,}') from dual;

1. Asked how to implement SCD type 2 and after that implement the same without using SQL in Python (out-of-box scenario).

2. Python needs to convert every word in a string to initcase. I created a function with capitalize, then they told me not to use built-in functions like capitalize. I was unable to do it without any built-in functions. They told me that we can use the split function. Is the split function not a built-in function?

3. Asked me on Snowflake-related questions like Snowpipe.

4. Asked me to count all 's' in a column.

sql select regexp_count('snake in the san boots','s{1,}') from dual;