Alteryx 2023 Grad | Off campus

Background: Expert on Codeforces, 5 star on Codechef and solved 1000+ problems on Leetcode (2500+ Contest Rating).

Experience: Summer intern at one of the Product Based Companies (Non FAANG).

Application process:
The opening for 6 month winter internship came in around last week of August. I took a referral from one of my connections and applied.

Within a week I got a call from the recruiter that my profile had been shortlisted and they were willing to move forward with my application.

Online Assessment:
I recieved the Hackerrank test link in the 2nd week of September. The test comprised to 5 - 6 MCQs, 1 SQL question and 2 DSA problems.
The SQL problem was a bit tricky as it involved joins with 3 - 4 tables.
It was something like this

there is a database on professors, departments, courses and schedules. Need to write a query that returns the names of all the professors and their respective courses. Each row must contain the name of the professor followed by the name of the course that the professor teaches. There must be no duplicates in terms of the rows.  
  
The schema I have, in terms of the table name and the fields:  
  
PROFESSOR: ID, NAME, DEPARTMENT_ID, SALARY  
DEPARTMENT: ID, NAME  
COURSE: ID, NAME, DEPARTMENT_ID, CREDITS  
SCHEDULE: PROFESSOR_ID, COURSE_ID, SEMESTER, YEAR

The DSA problem were comparatively much easier (leetcode Medium level)

After a week a I got a call from the recruiter who informed me that I had cleared the online assessment and asked me to schedule the interviews.
I asked them to schedule it after 2 - 3 days.

Alteryx had a total of 3 interviews - 2 Technical + 1 Managerial and all the rounds are eliminatory.

Interview Round 1:
The interviewer came up with a DSA problem. It was not a standard DSA question, instead it was something where I had to design a graph data-structure which hold some properties.
He wanted to check if I had a through understanding of graph data structure. I came up with a solution in 20 minutes and coded it up in another 5 minutes.
Since 30 minutes were left, he asked me to write a SQL query. I always ignored SQL questions and yet it follows me in every interview.
It was query which involved join between 2 tables. I had a rough idea of what had to be done and with proper hints I came up with the solution.
The interviewer was very friendly and constantly trying to cover edge cases. He then asked me some rapid fire questions on CS Fundamentals which I answered comfortably.

Interview Round 2:
I had the 2nd round just a day after the 1st round. A senior engineer came to take the interview. He straight away started with a design problem. I don't remember the quesiton exactly but I can assure you if you have solved ample amount of design questions on Leetcode, you will be able to tackle the problem.
It was a long discussion. We discussed about what all data structures could be used, how to make the code more modular and discussing the trade-offs of hashing.
Overall it was a very nice interview.

Managerial Round:
This round was also scheduled a day after the 2nd round. Here a senior engineering manager came to take the interviews. He was very polite and calm.
He started off with asking about my summer internship experience, the impact that my work had, about my learnings and why I am applying to Alteryx.
Then we had a deep discussion on indexing in DBMS. Then he asked me to explain one of my project.
These were not standard questions like what tech did you use, instead he wanted to understand the architecture. So my advice to everyone out there - Build your own projects, don't copy from online resources. You never know when an interviewer goes deep into the underlying architecture.
There was no DSA question.

I got a call from the recruiter after a week that I had been selected for the internship role.

Verdict: Selected

Overall I had a very good experience interviewing with Alteryx. They are a very good company. Many may have not heard of this company but the work they do is very good.
I gave a lot of interviews. Most of the other interviewers don't turn on their camera. Alteryx is an exception. Every interviewer turned their camera on. Made it feel like a discussion and tried to help me whenever I was stuck.
To everyone out there do consider applying to such companies as well instead of the traditional FAANG.