Singapore Airlines Data Engineer Interview Questions and Answers

There were easy to moderate difficulty level questions

Q1. Explain your resume
Ans. 
My resume showcases my experience in data engineering, including projects involving ETL processes, data modeling, and database management.
• Experience with ETL processes, including extracting data from various sources, transforming it, and loading it into a data warehouse

• Proficiency in data modeling techniques to design efficient database structures

• Strong skills in database management, including SQL queries, performance ...read more
Answered by AI
Add your answer
Q2. Do you know about cloud
Ans. 
Yes, cloud computing refers to the delivery of computing services over the internet.
• Cloud computing allows for on-demand access to a shared pool of resources, such as servers, storage, and applications.

• Examples of cloud services include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

• Cloud computing offers scalability, flexibility, and cost-efficiency for businesses and individuals.

• Common cloud de...read more
Answered by AI
Add your answer

Q1. What is the internal implementation of Hashing and what is collision?
Ans. 
Hashing is a technique used to map data to a fixed-size array, collision occurs when two different inputs produce the same hash value.
• Hashing involves using a hash function to map data to a fixed-size array.

• Collision happens when two different inputs produce the same hash value.

• Common techniques to handle collisions include chaining and open addressing.
Answered by AI
Add your answer
Q2. Is time complexity of HashMap always O(1) ?
Ans. 
No, time complexity of HashMap is not always O(1).
• Time complexity of HashMap is O(1) on average, but can degrade to O(n) in worst case scenarios.

• Worst case scenarios include hash collisions, which can lead to linear probing and degrade performance.

• Load factor and capacity of the HashMap can also affect time complexity.

• In scenarios where many keys hash to the same index, the time complexity can degrade.
Answered by AI
Add your answer

Q1. Yet to have the interview. Ambition box is forcefully making me enter these details
Add your answer

Q1. Explain RANKX function in power bi
Ans. 
RANKX function in Power BI is used to calculate the ranking of a value in a specified column.
• RANKX function assigns a rank to each row in a table based on a specified expression.

• It can be used to rank sales performance, customer satisfaction scores, etc.

• Syntax: RANKX(table, expression, [value], [order], [ties])

• Example: RANKX(Sales, Sales[Revenue], , DESC, Dense)
Answered by AI
Add your answer

Binary Search questions

Q1. Spring Annotations
Add your answer
Q2. Java stream and related questions
Add your answer

Q1. Strength, Weakness
Add your answer
Q2. About the company
Add your answer

Q1. About your work experience
Add your answer

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer

Choose the best answer and question and answer

Tell the topic an send the assignment

1 dsa question 1 sql and 18 mcq questions

Q1. Lot of questions from resumes and projects
Add your answer
Q2. Easy DSA questions and oops questions
Add your answer