Add office photos
Filter interviews by
Citibank Big Data Engineer Interview Questions and Answers
Citibank Big Data Engineer Interview Experiences
2 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Oct 2022. There were 3 interview rounds.
Had coding test on Python which comprises of 2 questions in which one had 8 test cases and the other had 7 test cases, in order to clear the round we have to get a minimum percentage of 50 and above.
(2 Questions)
- Q1. Difference between Internal and External table in Hive
- Ans.
Internal tables store data in a Hive-managed warehouse while external tables store data outside of Hive.
Internal tables are managed by Hive and are stored in a Hive warehouse directory
External tables are not managed by Hive and can be stored in any location accessible by Hive
Dropping an internal table also drops the data while dropping an external table only drops the metadata
Internal tables are faster for querying as ...
- Q2. Explain about Hadoop Architecture
- Ans.
Hadoop Architecture is a distributed computing framework that allows for the processing of large data sets.
Hadoop consists of two main components: Hadoop Distributed File System (HDFS) and MapReduce.
HDFS is responsible for storing data across multiple nodes in a cluster.
MapReduce is responsible for processing the data stored in HDFS by dividing it into smaller chunks and processing them in parallel.
Hadoop also includes...
Interview Preparation Tips
- Hadoop
- SQL
- Python
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jan 2018. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. If there is something useful that I can say in one line what would be - learn all you can. Don't just mug things up. Take your time and dwelve deep into the concepts.
- Q2. You can be asked any and everything. This is where your learning matters.
Interview Preparation Tips
Experience: Technical, functional and your communication skills will be tested. Be confident and precise. My personal advice - when you are not sure of something admit it instead of beating about the bush.
General Tips: If there is something useful that I can say in one line what would be - learn all you can. Don't just mug things up. Take your time and dwelve deep into the concepts.
Duration: 1-4 weeks
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Pyspark scenario questions
I applied via Approached by Company and was interviewed before Oct 2022. There were 3 interview rounds.
(1 Question)
- Q1. Python coding questions
(1 Question)
- Q1. Python moderate level coding questions
Interview Preparation Tips
I applied via Walk-in and was interviewed in Oct 2024. There were 2 interview rounds.
Easy on cyber security
(2 Questions)
- Q1. Introduce yourself this is
- Q2. What is your work experience
Interview Preparation Tips
Hello Neeaccount
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Asked regarding sql to make a table and given some queries to solve over the table
- Q2. Given easy code to solve before them very easy
(2 Questions)
- Q1. Regarding place
- Q2. Regarding night shifts
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Load 60 GB of csv file and perform transformation.
- Ans.
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
Use Apache Spark to distribute the workload across multiple nodes for faster processing.
Utilize Spark's DataFrame API to read the CSV file and apply transformations.
Consider partitioning the data to optimize performance.
Use Spark SQL for complex transformations and aggregations.
Leverage in-memory processing capabi
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Nov 2024. There were 2 interview rounds.
It consists of resume-based skill questions.
(2 Questions)
- Q1. Why do you want to join ICICI Bank?
- Ans.
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service
I am impressed by ICICI Bank's focus on technology and digital banking solutions
I believe that working at ICICI Bank will provide me with opportunities for career growth an...
- Q2. Can you tell me about your projects?
- Ans.
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
Developed predictive models to optimize marketing strategies
Utilized clustering techniques for customer segmentation
Built time series models for sales forecasting
Harshit Tiwari
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
A coding test is an assessment used to evaluate a candidate's programming skills and problem-solving abilities. It typically involves solving problems using code within a specified time frame, often through platforms like HackerRank or LeetCode. The tests assess language proficiency, coding efficiency, and logical thinking.
An aptitude test is an assessment designed to evaluate a person's ability to perform specific tasks and react to a range of different situations. It measures cognitive abilities, problem-solving skills, logical reasoning, and sometimes specific skill sets relevant to a job or educational setting. These tests are commonly used in hiring processes, educational admissions, and career guidance.
Interview Preparation Tips
- Data Analysis
- Python programming
Network Actively
Prepare for Interviews
Keep Learning
GAURI Jadhav
I applied via Campus Placement
Basic maths questions
Basic topics movies vs series
(2 Questions)
- Q1. Sql Queries were asked
- Q2. Was based on resume
(2 Questions)
- Q1. Based on resume the questions were
- Q2. Questions about family
Citibank Interview FAQs
Tell us how to improve this page.
Citibank Interviews By Designations
- Citibank Software Developer Interview Questions
- Citibank Assistant Manager Interview Questions
- Citibank Analyst Interview Questions
- Citibank AVP Interview Questions
- Citibank Assistant Vice President Interview Questions
- Citibank Associate Vice President Interview Questions
- Citibank Officer Interview Questions
- Citibank Phone Banking Officer Interview Questions
- Show more
Interview Questions for Popular Designations
People are getting interviews through
Interview Questions from Similar Companies
Fast track your campus placements
Citibank Big Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Assistant Manager
1.2k
salaries
|  ₹4.8 L/yr - ₹18.8 L/yr |
|
Assistant Vice President
1.2k
salaries
| ₹17 L/yr - ₹45.5 L/yr |
|
Vice President
726
salaries
| ₹22.3 L/yr - ₹70 L/yr |
|
Manager
697
salaries
| ₹10 L/yr - ₹30.5 L/yr |
|
Officer
485
salaries
| ₹9.9 L/yr - ₹33 L/yr |
HDFC Bank
ICICI Bank
Axis Bank
State Bank of India
Calculate your in-hand salary
- Home >
- Interviews >
- Citibank Interview Questions >
- Citibank Big Data Engineer Interview Questions
