Motifworks

Application

I applied through college or university. I interviewed at Motifworks.

Interview

I was shortlisted through CDAC (DBDA) for Data Analyst profile.

At first, there was Technical Aptitude round on their on Azure hosted site.
In technical, 5 questions each on modules like Python, DBMS, R, ML & Aptitude questions, both Technical & Aptitude with Negative Marking.

Cleared!

After 2-3 Days results announced & shortlisted candidates asked to be present on CDAC placement location.
Team of around 10-15 came to take Interview including Director, who gave company overview which seemed really great as they are Microsoft Gold partner. Also Director, seemed very friendly.

Next, 3 Technical+ 1 HR,
1st Technical: Started with basic introduction, project, some python code,
MySQL queries, Tableau related questions, Linux commands, Cloud computing. (around 20-30 minutes)

Cleared!

2nd Technical: This round was one of the toughest interview I have ever given.
For this round, panel of 2 out of which 1 for SQL, & other for Python+ML.
Both asked too many deep questions(+tried to confuse), you must be very clear with your basics to clear this round.
ML algorithms.
Rate yourself in Python & MySQL.
Asked, if selected, what will be your project preference, Python or My SQL?
(around 45 minutes)

Cleared!

3rd Technical: with senior, he was friendly, gave few tables & asked to write Movie Recommendation code on basis of those tables in whatever you are comfortable Python/SQL/Java/...
I explained logic verbally, how I will approach.
I written some code in Python. but failed to complete it.
Lost all hopes that I will get selected.
He again asked 1 join query, which wasn't difficult at all. But at that point, I couldn't even thought of it.

As expected, Rejected :(

Overall, it was really great interview experience, company officials made it very smooth & well managed process, but bit disappointed as I couldn't clear it!