Visa Interview Questions (With Answers)

12 Questions asked

Sep 2026 First seen

Sep 2026 Last seen

12 Unique questions

🥧 Difficulty mix

How hard are these questions?

Easy 2 (17%)Medium 10 (83%)

📊 Question type

Breakdown by interview phase

🔥 12-week activity

When candidates are asked these

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Sql 7

Window Functions 5

Rolling Average 4

Data Modeling 3

Etl 3

Dimensional Modeling 2

Fact Tables 1

Dimension Tables 1

👤 Experience level mix

What seniority these are asked at

Junior (1-3yr) 6Mid (3-6yr) 6

📝 Recent questions

Latest 10 asked by candidates

🟡 Medium ✅

At the table level, can you explain the difference between fact and dimension tables, how you define relationships between them, and what a primary key is? Also, how do you handle surrogate keys?

Dimensional Modeling Fact Tables Dimension Tables Primary Key Surrogate Key

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?

Slowly Changing Dimensions Sql Data Warehousing

Conceptual · Asked 1× · Sep 2026

🟢 Easy ✅

Will this logic still work if the underlying data schema changes?

Data Modeling Logic Schema Changes

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

How would you add a column that calculates the rolling average of revenue per transaction timestamp, given that you only have a transaction timestamp column and no order date?

Sql Window Functions Rolling Average

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

How would you compute a 7‑day rolling average of daily revenue when there can be multiple transactions per day, using transaction timestamps?

Sql Window Functions Aggregation Rolling Average

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

How would you modify your query to compute a 30‑day rolling average of daily revenue when you only have a transaction timestamp column and no order date?

Sql Window Functions Rolling Average Timestamp

Coding · Asked 1× · Sep 2026

🟡 Medium ✅

Write an SQL query to compute a 7‑day rolling average of daily revenue using a window function.

Sql Window Functions Rolling Average Revenue

Coding · Asked 1× · Sep 2026

🟢 Easy ✅

What is the purpose of the load_ts column in this query, and how does it differ from transaction_ts?

Sql Etl Data Modeling

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

How does this query calculate the rolling 7‑day average revenue using a window function?

Sql Window Functions Analytics

Conceptual · Asked 1× · Sep 2026

🟡 Medium ✅

How would you read and process this raw transaction log file in a Spark or Pandas ETL job?

Spark Pandas Etl

Conceptual · Asked 1× · Sep 2026

🎤 Want these answered in real-time during your interview?

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

🥧 Difficulty mix

📊 Question type

🔥 12-week activity

🏷️ Top topics

👤 Experience level mix

📝 Recent questions

At the table level, can you explain the difference between fact and dimension tables, how you define relationships between them, and what a primary key is? Also, how do you handle surrogate keys?

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?

Will this logic still work if the underlying data schema changes?

How would you add a column that calculates the rolling average of revenue per transaction timestamp, given that you only have a transaction timestamp column and no order date?

How would you compute a 7‑day rolling average of daily revenue when there can be multiple transactions per day, using transaction timestamps?

How would you modify your query to compute a 30‑day rolling average of daily revenue when you only have a transaction timestamp column and no order date?

Write an SQL query to compute a 7‑day rolling average of daily revenue using a window function.

What is the purpose of the load_ts column in this query, and how does it differ from transaction_ts?

How does this query calculate the rolling 7‑day average revenue using a window function?

How would you read and process this raw transaction log file in a Spark or Pandas ETL job?

🎤 Want these answered in real-time during your interview?

When implementing slowly changing dimensions, how do you decide whether to count changes that occur within seven days versus those that occur after seven days? Also, can you walk through the SQL syntax you would use for handling SCD type 2?