WorldQuant Software Engineer interview questions

1. Discussion on my background. Projects I did in the past. 2. Questions about MySQL and Cache. 3. Given two arrays a and b find the intersection of these two arrays. Write code in python. - Won't run the code 4. What is replication in Redis? 5. Write a SQL query to find score and Rank in a table with columns id = [1,2,3] and Score=[5,7,5] output 5:2,7:1,5:2 6. Then I was asked about source code management system. Asked to write a command to create a local branch.