Citi Interview Questions (9+ Questions)
Last Updated: June 8, 2026 • 9 Questions • Real Company Interviews
Prepare for your Citi interview with our comprehensive collection of 9+ real interview questions and detailed answers. These questions have been curated from actual Citi technical interviews across various roles including DevOps Engineer, Data Engineer, QA Engineer, and more.
Table of Contents
- Debug Failed Service Startup (medium) 🔒
- Stage File for Commit (easy) 🔒
- Add User to Sudo Group (easy) 🔒
- Count Implementation (easy) 🔒
- Set Operation: EXCEPT (medium) 🔒
- Dynamic Employee Turnover Monitor (easy) 🔒
- Product Stock Replenishment Predictor (medium) 🔒
- Null-Safe Calculation with ISNULL (easy) 🔒
- Rolling Average Profit with Window Function (medium) 🔒
Our Citi interview questions cover a wide range of technical topics and difficulty levels, from entry-level positions to senior roles. Each question includes detailed explanations and answers to help you understand the concepts and prepare effectively for your interview.
💡 Pro Tips for Citi Interviews
- Practice each question and understand the underlying concepts
- Review Citi's specific technologies and methodologies
- Prepare follow-up questions and edge cases
- Practice explaining your solutions clearly and concisely
Interview Questions & Answers
1. Debug Failed Service Startup
Diagnose systemd service startup failures using exit codes and journal logs. Learn how to interpret systemd status output showing exit codes and signals, extract root cause errors from the systemd journal, and fix common service failures like missing configuration files, permission errors, port conflicts, and invalid settings. This guide covers understanding exit code meanings, correlating systemd status with application logs, identifying why services fail immediately on startup, and verifying recovery. Essential for troubleshooting production service outages, deployment failures, and rapid crash recovery in systemd-managed environments.
2. Stage File for Commit
Prepare files for commitment by staging untracked files into the Git index. Use git add to include files in the next commit, verify staging status, and control which changes are committed. Essential for selective file inclusion, deliberate commit preparation, and maintaining fine-grained control over what is included in each commit.
3. Add User to Sudo Group
Add an existing user to the sudo group to grant administrative privileges while preserving their membership in other groups.
4. Count Implementation
Creating Kubernetes ConfigMaps with Terraform is a common task that demonstrates your ability to manage infrastructure as code. Here, we'll walk through a scenario where you need to deploy multiple ConfigMaps for different application instances using sequential naming. This guide will help you under...
🔒 Premium Content
Detailed explanation and solution available for premium members.
5. Set Operation: EXCEPT
How to Retrieve Orders from 2023 Exceeding $1,000 without Approved Refunds
When faced with the task of retrieving all orders from the year 2023 with an amount exceeding $1,000 that have not been approved for a refund, it’s essential to develop an efficient SQL query that leverages the provided ...
🔒 Premium Content
Detailed explanation and solution available for premium members.
6. Dynamic Employee Turnover Monitor
Calculate Employee Turnover Rate for Departments in SQL
Are you preparing for a SQL interview or aiming to enhance your database management skills? A common interview question is to calculate the employee turnover rate for each department. Here, we break down the steps necessary to write an effi...
🔒 Premium Content
Detailed explanation and solution available for premium members.
7. Product Stock Replenishment Predictor
Objective
The objective of this SQL interview question is to create a query that efficiently calculates the average daily sales for each product, and then determines the number of days until reordering is required based on the current stock, reorder point, and average daily sales. The final outp...
🔒 Premium Content
Detailed explanation and solution available for premium members.
8. Null-Safe Calculation with ISNULL
How to Write a SQL Query to Retrieve Product Name, Adjusted Profit, and Data Status from a Sales Table
In this guide, we will create a SQL query that retrieves essential details from a sales table. We aim to fetch the product's name, its adjusted profit, and the data status by checking the prof...
🔒 Premium Content
Detailed explanation and solution available for premium members.
9. Rolling Average Profit with Window Function
How to Calculate a 7-Day Rolling Average of Profits Using SQL
In this comprehensive guide, we'll tackle a common SQL interview question that requires calculating the 7-day rolling average of profits for each date starting from '2023-01-01'. The goal is to write an SQL query that accurately compu...
🔒 Premium Content
Detailed explanation and solution available for premium members.
Ready to Practice More?
Explore interview questions from other companies or try our hands-on labs to build practical experience.