MSCI Interview Question

Written test included advanced sql, java, with multiple optional tests in perl, advanced python(specific libraries), finances.