Visa | Coding Round | Bengaluru | Senior Data Scientist
- Location
- Bengaluru
- Posted
- 9 Jul 2025
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.
How it went
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"]
Questions asked (2)
- 01
Find Actors by Favorite Genre SQL
Data Structures & Algorithms
You are given the following tables:
1.
WatchedMoviesmovie_id genre 1 Action 2 Comedy 3 Action 4 Drama 2.
MovieActorsmovie_id actor_id 1 10 1 11 2 12 3 10 3.
GenreActorsgenre actor_id Action 10 Comedy 12 Drama 13 Action 11 4.
Actorsactor_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_idandage, sorted by age in descending order. - 02
CamelCase String Split into Valid Words
Data Structures & Algorithms
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"]