Everesttech Interview Questions (With Answers)

5 Questions asked

Jul 2026 First seen

Jul 2026 Last seen

5 Unique questions

🥧 Difficulty mix

How hard are these questions?

Easy 1 (20%)Medium 4 (80%)

📊 Question type

Breakdown by interview phase

🔥 12-week activity

When candidates are asked these

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Joins 2

Scd Type 2 2

Etl 2

Database 1

Source-target 1

Sql 1

Snowflake 1

Data Comparison 1

👤 Experience level mix

What seniority these are asked at

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

📝 Recent questions

Latest 10 asked by candidates

🟡 Medium ✅

What is a source‑target join, and how would you implement it?

Joins Database Source-target

Conceptual · Asked 1× · Jul 2026

🟢 Easy ✅

Which type of join will you use?

Joins Sql

Conceptual · Asked 1× · Jul 2026

🟡 Medium ✅

I want to know how to implement a logical comparison using Snowflake utilities to compare source and target data, identify changes, and add old records with close dates and new active records. Can you explain this scenario, and how SNFKT values are used?

Snowflake Data Comparison Scd Type 2

Conceptual · Asked 1× · Jul 2026

🟡 Medium ✅

Source data is in the bronze layer. We need to implement SCD type 2 in the target layer. If data arrives daily in batch and the bronze layer is refreshed each day, what logic would you use between the bronze and target layers to achieve SCD type 2?

Data Lake Scd Type 2 Etl

Conceptual · Asked 1× · Jul 2026

🟡 Medium ✅

How would you implement logic for three ordered tiers (Bronze, Silver, Gold) in a target table?

Data Pipeline Data Warehousing Etl

Conceptual · Asked 1× · Jul 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