visa logo
Visa· Senior Data Scientist

Visa | Coding Round | Bengaluru | Senior Data Scientist

Location
Bengaluru
Posted
9 Jul 2025
435 reads

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_idgenre
1Action
2Comedy
3Action
4Drama

2. MovieActors

movie_idactor_id
110
111
212
310

3. GenreActors

genreactor_id
Action10
Comedy12
Drama13
Action11

4. Actors

actor_idage
1045
1150
1230
1360

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)

  1. 01

    Find Actors by Favorite Genre SQL

    Data Structures & Algorithms

    You are given the following tables:

    1. WatchedMovies

    movie_idgenre
    1Action
    2Comedy
    3Action
    4Drama

    2. MovieActors

    movie_idactor_id
    110
    111
    212
    310

    3. GenreActors

    genreactor_id
    Action10
    Comedy12
    Drama13
    Action11

    4. Actors

    actor_idage
    1045
    1150
    1230
    1360

    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.

  2. 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"]
    

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Visa recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!