Visa | Coding Round | Bengaluru | Senior Data Scientist
Summary
I recently interviewed for a Senior Data Scientist position at Visa in Bengaluru. This post shares learnings and specific SQL and Python coding questions from the first round of the interview.
Full Experience
Visa SDS Interview – Round 1 Learnings and Questions
Hey! Recently I interviewed for an SDS (Senior Data Scientist) position at Visa. The first round comprised of coding questions testing SQL and Python. Sharing some learnings and questions for the same below.
SQL Question
You are given the following tables:
1. WatchedMovies
| movie_id | genre |
|---|---|
| 1 | Action |
| 2 | Comedy |
| 3 | Action |
| 4 | Drama |
2. MovieActors
| movie_id | actor_id |
|---|---|
| 1 | 10 |
| 1 | 11 |
| 2 | 12 |
| 3 | 10 |
3. GenreActors
| genre | actor_id |
|---|---|
| Action | 10 |
| Comedy | 12 |
| Drama | 13 |
| Action | 11 |
4. Actors
| actor_id | age |
|---|---|
| 10 | 45 |
| 11 | 50 |
| 12 | 30 |
| 13 | 60 |
Problem Statement
Write a SQL query to find the actors you would be interested in based on your favorite genre — the genre for which you have watched the most movies.
Return their actor_id and age, sorted by age in descending order.
Python Question
You are given:
- A list of valid words that can be used as variable names in a programming language.
- A string written in CamelCase format, which may or may not start with a capital letter.
Task
Write a function that determines whether the CamelCase string can be split into individual words such that all resulting words exist in the provided list of valid words.
The function should be case-insensitive.
Example
Input
valid_words = ["my", "variable", "name", "parse", "json", "data"]
Interview Questions (2)
You are given the following tables:
1. WatchedMovies
| movie_id | genre |
|---|---|
| 1 | Action |
| 2 | Comedy |
| 3 | Action |
| 4 | Drama |
2. MovieActors
| movie_id | actor_id |
|---|---|
| 1 | 10 |
| 1 | 11 |
| 2 | 12 |
| 3 | 10 |
3. GenreActors
| genre | actor_id |
|---|---|
| Action | 10 |
| Comedy | 12 |
| Drama | 13 |
| Action | 11 |
4. Actors
| actor_id | age |
|---|---|
| 10 | 45 |
| 11 | 50 |
| 12 | 30 |
| 13 | 60 |
Problem Statement
Write a SQL query to find the actors you would be interested in based on your favorite genre — the genre for which you have watched the most movies.
Return their actor_id and age, sorted by age in descending order.
You are given:
- A list of valid words that can be used as variable names in a programming language.
- A string written in CamelCase format, which may or may not start with a capital letter.
Task
Write a function that determines whether the CamelCase string can be split into individual words such that all resulting words exist in the provided list of valid words.
The function should be case-insensitive.
Example
Input
valid_words = ["my", "variable", "name", "parse", "json", "data"]