CGI Interview Questions (With Answers)

509 Questions asked

Apr 2026 First seen

Sep 2026 Last seen

509 Unique questions

🥧 Difficulty mix

How hard are these questions?

Easy 77 (15%)Medium 363 (71%)Hard 69 (14%)

📊 Question type

Breakdown by interview phase

🔥 12-week activity

When candidates are asked these

Last 12 weeks →

🏷️ Top topics

Where these questions cluster

Devops 55

Ai Machine Learning 45

Cloud Devops 38

Data Engineering 32

Databases Sql 32

Algorithms Data Structures 27

Security 22

System Design 22

👤 Experience level mix

What seniority these are asked at

Fresher (0-1yr) 75Junior (1-3yr) 3Mid (3-6yr) 362Senior (6+yr) 69

📝 Recent questions

Latest 10 asked by candidates

🟡 Medium ✅

You balanced data distribution and request distribution to avoid hot partitions. What specific technique or strategy did you use, and how did you monitor CPU, memory, and request rates to ensure optimal performance?

Data Distribution Hot Partitions Monitoring

Conceptual · Asked 1× · Sep 2026

🟢 Easy ✅

Okay. What is the difference between a fact and a dimension table?

Fact Table Dimension Table Data Warehouse

Conceptual · Asked 8× · Aug 2026

🔴 Hard ✅

Imagine an AWS pipeline that now has to serve an analytics team needing low-latency SQL access on curated data, while the source tables keep changing schema over time. How would you design the ingestion and transformation layer to handle schema evolution safely while keeping the SQL layer stable?

Schema Evolution Aws Data Pipeline

System Design · Asked 1× · Jul 2026

🟡 Medium ✅

Given a list of integer IDs, return all IDs that appear more than once. Return each duplicate only once, in the order it first becomes a duplicate. Example: [1,2,3,4,2,5,1].

Arrays Hashing Duplicates

Coding · Asked 1× · Jul 2026

🔴 Hard ✅

How would you compare Java sealed classes and Java exceptions for a production system?

Java

Conceptual · Asked 1× · Jun 2026

🟡 Medium ✅

🎤 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

You balanced data distribution and request distribution to avoid hot partitions. What specific technique or strategy did you use, and how did you monitor CPU, memory, and request rates to ensure optimal performance?

Okay. What is the difference between a fact and a dimension table?

Imagine an AWS pipeline that now has to serve an analytics team needing low-latency SQL access on curated data, while the source tables keep changing schema over time. How would you design the ingestion and transformation layer to handle schema evolution safely while keeping the SQL layer stable?

Given a list of integer IDs, return all IDs that appear more than once. Return each duplicate only once, in the order it first becomes a duplicate. Example: [1,2,3,4,2,5,1].

How would you compare Java sealed classes and Java exceptions for a production system?

Which configuration choices matter most for structured?

How should a system using managers be designed for high load or concurrency?

Explain the role of type in production systems.

How would you test a component that depends on Amazon EMR?

How should a system using Athena be designed for high load or concurrency?

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