Visa | Coding Round | Bengaluru | Senior Data Scientist
Anonymous User
1732
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"]Other Interviews:
- First Round | SWE III ML | Bengaluru
- Googleyness Round | SWE III ML
- Hiring Manager Round | Gemini Applications Team
Other Tech Firms
- Amazon | Interview (1st Round) | Applied Data Scientist | Bengaluru
- Freshworks | OA (1st Round) | Data Scientist | Bengaluru
- Razorpay | OA (1st Round) | Senior MLE | Bengaluru
- Avaamo | Interview | Senior MLE | Bengaluru
- Visa | Coding Round | Senior Data Role | Bengaluru
Compensation
Offer / Compensation Discussions
Comments (2)