Interview at Servian

 Hi All,

I am back again with another wonderful blog sharing my experience about my interview at one of the very promising Australia Based Company, Servian. I happen to know about it from linkedin. After a good deal of research and seeing reviews from Glassdoor I finally applied for it.  the JD was for ETL Developer.

At the very begining I received a call from their HR who was based on Bangalore. He asked me about my current job role and my relocation preference. They have been hiring for just Banagalore location so my saying that "I don't have any specific location preference did help!". I was asked about my current and expected CTC and then followed a question to justify such a hike :p

Machine Round

I was finally considered for a machine round and the interview was supposed to be scheduled once I clear this round. There were 15 Questions and the allocated time was 1 hour. The difficulty was not much. Question based on joins, aggregator and group by were there. I felt the difficulty were either low or medium. However, I recomend having some hands on as it will ensure you don't drag the  assessment long. Note: one of the question here was to write about your motivation to join the company. So, a bit of research on the same before the assessment will help. 

Technical Interview

The technical interview was schedule between 4 PM to 5 PM on teams. I had to switch on my webcam and answer the questions being asked. Here are some of the questions that were asked to me. 

  

1. The input table is shown in figure 2. Write a query to show the data as structured in figure 1.

figure 1: Output format

figure 2: Input format

The question seemed a bit tricky initially and I took some time to figure out a solution for the same. Below is the SS of the solution I wrote.

select a.name,b.name,c.name,d.name from

electronics a

join

electronics b

on 

a.category_id=b.parent_id

join

electronics c

on

b.category_id=c.parent_id

left join

electronics d

on

c.category_id=d.parent_id

where a.name="ELECTRONICS"

2. I was the asked about schemas - Start, Galaxy and Snowflake.

3. Which schema has normalized tables.

4. How can you take the data from a flatfile and a table and join data from them and store it in third table, without using any tool.

5. What are confirmed dimensions. Explain with an example. 

These were the questions I was asked. And frankly speaking it was not much difficult. 

However, I received a mail after a week that I was not a right fit for the role. I guess it was due to me taking a little longer to solve the query problem which was asked at the very begining. This rejection did enervate the lambent fire in me and I have been strugling hard to hit a better job now. 

One platform that has been helping me prepare is hacker rank. I insists my readers to practice the sql statements at https://www.hackerrank.com/domains/sql .It has hone my skills to a great extent.

Hope you like my blog and do share your opinion and experience on the same.

 

I was asked