FYND INTERVIEW EXPERIENCE

LOCATION - MUMBAI
ROLE - SDE - 1
TOTAL EXPERIENCE - 1.1 year as SDE- 1 and 15 months as SDE intern
CURRENT COMPANY - RARIO ( PART OF DREAM 11 GROUP )

DSA QUESTION

https://leetcode.com/problems/boats-to-save-people/

NOSQL VS SQL

ACID PROPERTIES ( with example )

CAP THEOREM

Discussion around indexes 
 - what are indexes ? What they are use for ?
 - should we create or not create indexes on every column of table?

CDN and Cloudfront related questions ( because it was mentioned on resume )

SQL QUERIES

Question 1) Find max salary of each department

Table Employee
id   dep_id      salary    name

Table Department
id       name

OutPut should be like

dept_name max_salary


Question 2) Find unsettlement transactions ids ( transaction ids that are not present in settlement table )

Table Transaction                          Table Settlement
id  date amount                             txn_id  timestamp

outPut should be like this 
id


VERDICT - Rejected

( Interview went pretty well and interviewer was also friendly but they wanted someone who had experience of working in pyhton and I had no experience of working in pyhton )