Automated video questions : Explain most challenging project you worked on and what was the outcome? Describe a situation when you did "out of box" thinking and whst was the result? Why do you want to join statefarm? Why you think you are the right person for this job? Actual interview : Mostly behavioral and situational questions such as how do you manage conflicts, priorities, approach towards a technical problem, etc. There were few questions pertaining to AWS, no sql vs sql, dynamo DB, kinesis, etc