Add office photos
HSBC Group
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
HSBC Group Hadoop Developer Interview Questions, Process, and Tips
HSBC Group Hadoop Developer Interview Experiences
1 interview found
Interview Questionnaire
4 Questions
- Q1. How to ingest csv file to spark dataframe and write it to hive table.
- Ans.
Ingest CSV file to Spark dataframe and write to Hive table.
Create SparkSession object
Read CSV file using SparkSession.read.csv() method
Create a dataframe from the CSV file
Create a Hive table using SparkSession.sql() method
Write the dataframe to the Hive table using dataframe.write.saveAsTable() method
- Q2. What is Managed table and External table in hive
- Ans.
Managed tables are physically stored in Hive's warehouse directory while external tables are not.
Managed tables are created and managed by Hive while external tables are created outside of Hive.
Managed tables are physically stored in Hive's warehouse directory while external tables are not.
Managed tables are deleted when the table is dropped while external tables are not.
Managed tables are used for internal purposes wh...
- Q3. What is the role of boundary query in sqoop
- Ans.
Boundary query in Sqoop is used to import data within a specific range of values.
Boundary query is used to import data within a specific range of values
It is used with the --boundary-query option in Sqoop
It is useful when importing large datasets and you only need a subset of the data
For example, importing data from a database table where the values in a particular column fall within a specific range
- Q4. What is top command in shell scripting
- Ans.
Top command is a Linux utility that displays the system's processes in real-time.
Displays the processes running on the system
Updates the list of processes in real-time
Provides information on CPU usage, memory usage, and process IDs
Can be used to monitor system performance and identify resource-intensive processes
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
1 coding question based on DP for 25 minutes and 30 MCQs on Java , OOPS and code snippet questions also some basic questions based on trees like number of leaf nodes in a complete binary tree with n nodes.
(3 Questions)
- Q1. Write code for finding palindrome of a string
- Ans.
Code to find palindrome of a string
Iterate through the string from both ends and compare characters
Use two pointers, one starting from the beginning and one from the end
If characters at both pointers match, continue checking until they meet in the middle
If all characters match, the string is a palindrome
- Q2. What is dynamic memory allocation in Java
- Ans.
Dynamic memory allocation in Java refers to the process of allocating memory for objects at runtime.
Dynamic memory allocation allows for objects to be created and destroyed during program execution.
The 'new' keyword is used to dynamically allocate memory for objects in Java.
Dynamic memory allocation helps in managing memory efficiently by allocating memory only when needed.
Example: int[] arr = new int[5]; dynamically a
- Q3. You are designing an e commerce website which database will you choose and what will you use for authentication given that you can't use JWT or even third party like Google authentication
- Ans.
I would choose a relational database like MySQL and implement a custom authentication system using session management.
Choose a relational database like MySQL for storing user data, product information, and orders.
Implement a custom authentication system using session management to securely authenticate users without JWT or third-party services.
Use encryption techniques to store and validate user passwords securely.
Util...
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
(1 Question)
- Q1. Explain your work in current project
- Ans.
I am currently working on developing a web application for a client in the e-commerce industry.
Developing front-end using React.js
Implementing back-end functionalities using Node.js and Express
Integrating payment gateway for online transactions
Optimizing performance and user experience
(1 Question)
- Q1. Explain the design of the current project
- Ans.
The current project is a web application for managing inventory and sales.
The project uses a client-server architecture with a front-end built using React and a back-end built using Node.js and MongoDB.
The front-end communicates with the back-end through RESTful APIs.
The project includes features such as user authentication, product management, sales tracking, and reporting.
The design follows a modular approach with se...
Interview Preparation Tips
Aptitude was very basic.
(2 Questions)
- Q1. What is constant?
- Ans.
A constant is a value that does not change during the execution of a program.
Constants are used to store values that remain the same throughout the program.
They are declared using the 'const' keyword in many programming languages.
Examples include mathematical constants like pi (3.14159) or physical constants like the speed of light (299,792,458 m/s).
- Q2. What is object oriented programming?
- Ans.
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
Objects are instances of classes, which define the structure and behavior of the objects.
Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.
Example: Inheritance allows a subclass to inherit attributes and methods from a superclass.
(2 Questions)
- Q1. Salary Negotiation
- Q2. Work culture description
- Ans.
Our work culture is collaborative, innovative, and focused on continuous learning and growth.
Encourages teamwork and open communication
Emphasizes creativity and problem-solving
Provides opportunities for professional development
Values diversity and inclusion
Promotes a healthy work-life balance
Skills evaluated in this interview
Riya Vats
(3 Questions)
- Q1. Spring related questions
- Q2. Java related questions
- Q3. Couple of coding questions (Easy)
MCQs on DN and SQL etc.
2 coding questions, 7 debugging questions.
(2 Questions)
- Q1. Python core question
- Q2. DSA question on BFS
(2 Questions)
- Q1. Design discussion
- Q2. Resume question
I applied via LinkedIn and was interviewed in Apr 2024. There were 2 interview rounds.
Basic program with stream
(2 Questions)
- Q1. Microservice architecture
- Q2. Crud operations
General apti questions
Work-life balance and career progression
Software Engineer Interview Questions & Answers
State Street Corporation
Anonymous
posted on 23 Oct 2024
I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.
(2 Questions)
- Q1. Tell me about yourself
- Q2. Which language are you comfortable with and more than 10 questions on that language
Hackerrank medium level questiobs
(1 Question)
- Q1. DB low level design, spring data jpa associations
(1 Question)
- Q1. Design questions microservices spring cloud
(1 Question)
- Q1. Basic introduction discussion
Interview Preparation Tips
HSBC Group Interview FAQs
Tell us how to improve this page.
HSBC Group Interviews By Designations
- HSBC Group Assistant Manager Interview Questions
- HSBC Group Software Engineer Interview Questions
- HSBC Group Analyst Interview Questions
- HSBC Group Business Analyst Interview Questions
- HSBC Group Senior Software Engineer Interview Questions
- HSBC Group Software Engineer Trainee Interview Questions
- HSBC Group Software Developer Interview Questions
- HSBC Group Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Hadoop Administrator Interview Questions
- Bigdata and Hadoop Developer Interview Questions
- System Engineer Hardware Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Technical Lead Interview Questions
- Associate Software Engineer Interview Questions
- System Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Assistant Manager
2.6k
salaries
|  ₹4.5 L/yr - ₹15 L/yr |
|
Manager
2.1k
salaries
| ₹8 L/yr - ₹28.1 L/yr |
|
Senior Software Engineer
1.5k
salaries
| ₹7.2 L/yr - ₹28 L/yr |
|
Assistant Vice President
1.5k
salaries
| ₹16.9 L/yr - ₹45 L/yr |
|
Software Engineer
1.3k
salaries
| ₹4.9 L/yr - ₹14.4 L/yr |
Standard Chartered
ICICI Bank
Axis Bank
HDFC Bank
- Home >
- Interviews >
- HSBC Group Interview Questions >
- HSBC Group Hadoop Developer Interview Questions
