Avalara | SSE (IC-3) | Remote | July 2024 [Offer]
- Result
- Offer
- Location
- bangalore
- Experience
- 3 years
- Posted
- 18 Aug 2024
Summary
I successfully secured an offer for the SSE (IC-3) role at Avalara after participating in a hiring drive in Bangalore, which involved an Online Assessment, a comprehensive technical round, and a final Hiring Manager interview.
How it went
I recently interviewed for the SSE (IC-3) position at Avalara. My current experience spans 3 years in a Fintech Startup. The interview process consisted of three rounds, all conducted during a hiring drive organized in Bangalore.
Round 1 (Online Assessment)
This round lasted 30 minutes and primarily focused on aptitude questions.
Round 2 (Technical)
This technical round was approximately 1 hour and 30 minutes. It included a question on the Hackerrank portal where I had to call an API and perform operations on the response data. There were also various questions related to Java and SQL. For the SQL part, I was given some tables and asked to write queries. Specifically, one question required a LEFT JOIN, and for another, I mentioned that window functions like RANK() could be used to solve it. Additionally, I was questioned on Docker and Kubernetes concepts. I noted that the questions were generally based on the skills mentioned in my resume.
Round 3 (Hiring Manager)
The final round was with the Hiring Manager, lasting about 1 hour. This round primarily focused on behavioral questions. We discussed a technical problem I had solved, my motivations for wanting to change my current organization, and my understanding of Avalara as a company.
Verdict: Offer
I received confirmation of my selection during the drive itself and got the official offer letter within the next 3-4 days. Compensation details can be found here.
Questions asked (3)
- 01
SQL Queries with Joins and Window Functions
Other
Given a set of tables, write SQL queries to solve specific problems. One problem required the use of a
LEFT JOIN, and another was suitable for solving with window functions likeRANK(). - 02
Reason for Changing Current Organization
Behavioral
Explain your motivations and reasons for seeking to change your current organization.
- 03
Knowledge about Avalara
Behavioral
Demonstrate your understanding of Avalara as a company, its mission, products, or services.