Upload Button Icon Add office photos

Filter interviews by

Saks OFF 5TH Senior BI Engineer Interview Questions and Answers

Updated 3 Jul 2024

Saks OFF 5TH Senior BI Engineer Interview Experiences

1 interview found

Senior BI Engineer Interview Questions & Answers

user image ayush agrawal

posted on 3 Jul 2024

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Concat , substring in sql
  • Q2. If left and right table have same data, then will left and right join give same results

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Jan 2025.

Round 1 - Technical 

(6 Questions)

  • Q1. What is the role of exception handling in programming, and how is the 'finally' block used in this context, as well as the process of throwing exceptions?
  • Ans. 

    Exception handling is crucial in programming to handle errors and ensure proper execution. The 'finally' block is used to clean up resources, and throwing exceptions allows for error propagation.

    • Exception handling is used to manage errors and unexpected situations in a program.

    • The 'finally' block is used to execute code that should always run, regardless of whether an exception is thrown or not.

    • Throwing exceptions allo...

  • Answered by AI
  • Q2. What are the differences between SQL and NoSQL databases, and can you mention some NoSQL databases that you are familiar with?
  • Q3. What are the ACID properties implemented in your project, and can you provide a brief overview of the CAP Theorem?
  • Ans. 

    ACID properties ensure data integrity in transactions. CAP Theorem states that a distributed system can only guarantee two out of three: Consistency, Availability, Partition Tolerance.

    • ACID properties: Atomicity, Consistency, Isolation, Durability

    • Example: In a banking application, a transfer of funds should be atomic, consistent, isolated, and durable

    • CAP Theorem: Consistency, Availability, Partition Tolerance - a distri...

  • Answered by AI
  • Q4. Database disaster recovery?
  • Q5. What is the difference between Comparable and Comparator in Java? And how to Implement in Collections.
  • Ans. 

    Comparable is an interface used for natural ordering, while Comparator is used for custom ordering in Java Collections.

    • Comparable interface is used to define the natural ordering of objects. It is implemented by the class whose objects are to be sorted.

    • Comparator interface is used to define custom ordering of objects. It is implemented by a separate class.

    • To implement Comparable, the class needs to override the compare...

  • Answered by AI
  • Q6. Implementation of Generics in Java
  • Ans. 

    Generics in Java allow for creating classes, interfaces, and methods that operate on types parameterized at compile time.

    • Generics provide type safety by allowing compile-time type checking.

    • They enable code reusability and reduce the need for casting.

    • Example: List<String> list = new ArrayList<>();

  • Answered by AI
Round 2 - Technical 

(10 Questions)

  • Q1. Can you provide the code to reverse a string using recursion?
  • Ans. 

    Code to reverse a string using recursion

    • Create a recursive function that takes a string as input

    • Base case: if the string is empty or has only one character, return the string

    • Recursive case: return the last character of the string concatenated with the result of calling the function on the substring excluding the last character

  • Answered by AI
  • Q2. How does object comparison work with specific fields?
  • Ans. 

    Object comparison with specific fields involves comparing values of selected fields between two objects.

    • Object comparison can be done by comparing the values of specific fields in two objects.

    • Fields can be selected based on unique identifiers or criteria for comparison.

    • Example: Comparing the 'name' field of two person objects to check if they are the same.

  • Answered by AI
  • Q3. How does the distributed transactions being handled in a microservice?
  • Ans. 

    Distributed transactions in microservices involve using compensating transactions and event-driven architecture.

    • Microservices typically use compensating transactions to maintain consistency across multiple services.

    • Event-driven architecture can help in coordinating distributed transactions by using events to trigger actions in different services.

    • Implementing distributed transactions in microservices requires careful de...

  • Answered by AI
  • Q4. Aggregator Pattern in Microservice
  • Ans. 

    Aggregator pattern is used in microservices architecture to combine multiple service responses into a single response.

    • Aggregator pattern helps in reducing the number of client requests by combining multiple service responses.

    • It can be implemented using a separate service or within an existing service.

    • Example: A shopping website aggregating product information from different microservices like inventory, pricing, and re

  • Answered by AI
  • Q5. What is the implementation of the factory design pattern?
  • Ans. 

    Factory design pattern is a creational pattern that provides an interface for creating objects in a superclass, but allows subclasses to alter the type of objects that will be created.

    • Factory method pattern defines an interface for creating objects, but lets subclasses decide which class to instantiate.

    • It promotes loose coupling by eliminating the need to bind application-specific classes into the code.

    • Example: A car m...

  • Answered by AI
  • Q6. What is indexing in a database, and what data structures are commonly used for indexing?
  • Ans. 

    Indexing in a database is a technique to improve the speed of data retrieval by creating a data structure that allows for quick lookup.

    • Indexing involves creating a separate data structure that contains pointers to the actual data in the database.

    • Common data structures used for indexing include B-trees, hash tables, and binary search trees.

    • Indexes can be created on one or multiple columns in a database table to speed up...

  • Answered by AI
  • Q7. What is your approach to designing a system capable of handling thousands of requests?
  • Ans. 

    My approach involves using load balancing, caching, asynchronous processing, and horizontal scaling.

    • Implement load balancing to distribute requests evenly across multiple servers.

    • Utilize caching mechanisms to store frequently accessed data and reduce response times.

    • Use asynchronous processing for long-running tasks to free up resources for handling more requests.

    • Implement horizontal scaling by adding more servers to ha...

  • Answered by AI
  • Q8. What is the CQRS pattern in microservices?
  • Ans. 

    CQRS pattern in microservices separates read and write operations for improved scalability and performance.

    • CQRS stands for Command Query Responsibility Segregation

    • It separates the read and write operations into two different models

    • Write operations update the data store, while read operations query a separate data store

    • CQRS can improve performance and scalability by allowing each model to be optimized for its specific t

  • Answered by AI
  • Q9. What is the role of API Gateway in microservices architecture?
  • Ans. 

    API Gateway acts as a single entry point for all client requests in a microservices architecture.

    • API Gateway handles authentication, authorization, rate limiting, and routing of requests to appropriate microservices.

    • It helps in decoupling client applications from individual microservices, providing a more flexible and scalable architecture.

    • API Gateway can also perform tasks like request/response transformation, logging...

  • Answered by AI
  • Q10. Write SQL query to fetch data from two tables using joins?
  • Ans. 

    SQL query to fetch data from two tables using joins

    • Use the JOIN keyword to combine rows from two tables based on a related column

    • Specify the columns to select from each table in the SELECT statement

    • Use the ON keyword to specify the join condition

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare a strong foundation in System Design, NoSQL, Microservices, and Core Java.
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Walk-in and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. What is your role first to end in warehouse
  • Ans. 

    As a Sr executive in a warehouse, my role is to oversee the overall operations from receiving goods to shipping them out.

    • Manage inventory levels to ensure efficient storage and movement of goods

    • Supervise warehouse staff to ensure tasks are completed accurately and on time

    • Implement and enforce safety procedures to prevent accidents and injuries

    • Coordinate with other departments to ensure smooth flow of goods in and out o

  • Answered by AI
  • Q2. Who to motivate to empolyees
  • Ans. 

    Motivate employees by setting clear goals, providing recognition, offering opportunities for growth, and fostering a positive work environment.

    • Set clear and achievable goals for employees to work towards

    • Provide regular recognition and rewards for their hard work

    • Offer opportunities for growth and development through training and promotions

    • Foster a positive work environment by promoting teamwork, communication, and work-

  • Answered by AI
  • Q3. How to increase the transport cost??
  • Ans. 

    Increasing transport costs can be achieved through various strategies such as optimizing routes, implementing fuel surcharges, and investing in new technology.

    • Optimize routes to reduce mileage and fuel consumption

    • Implement fuel surcharges to offset rising fuel costs

    • Invest in new technology such as GPS tracking systems to improve efficiency

    • Negotiate higher rates with carriers based on increased demand or service quality

    • ...

  • Answered by AI
  • Q4. How to handle shortage and excess stock to store material??
  • Ans. 

    Shortage and excess stock can be handled by implementing efficient inventory management strategies.

    • Regularly monitor inventory levels to identify shortages and excess stock

    • Implement just-in-time inventory system to reduce excess stock

    • Utilize forecasting techniques to predict demand and prevent shortages

    • Establish relationships with multiple suppliers to mitigate shortages

    • Implement inventory control measures such as ABC

  • Answered by AI
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Dec 2024. There were 3 interview rounds.

Round 1 - Coding Test 

1.Sum numbers in linked list
2. Maximum sum subarray

Round 2 - Technical 

(2 Questions)

  • Q1. Design and code hashmap.
  • Ans. 

    Implement a hashmap data structure in code.

    • Use an array to store key-value pairs

    • Implement a hash function to map keys to indices in the array

    • Handle collisions using techniques like chaining or open addressing

  • Answered by AI
  • Q2. Questions on kafka
Round 3 - Hld 

(1 Question)

  • Q1. Design linked in
  • Ans. 

    Design a platform similar to LinkedIn for professional networking.

    • Create user profiles with work experience, education, skills, and endorsements.

    • Allow users to connect with others, join groups, and follow companies.

    • Include features like job postings, messaging, news feed, and recommendations.

    • Implement algorithms for personalized content and job suggestions.

    • Ensure data privacy and security measures are in place.

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - Coding Test 

DSA medium and Java Coding Questions

Round 2 - Coding Test 

Frontend coding questions in Js and React js

Round 3 - One-on-one 

(2 Questions)

  • Q1. What are Hooks and life cycle in React
  • Q2. Behavioural questions like leadership etc
Round 4 - HR 

(2 Questions)

  • Q1. Salary Expectations
  • Q2. Company Values and Mission
Interview experience
3
Average
Difficulty level
Hard
Process Duration
-
Result
-

I was interviewed in Dec 2024.

Round 1 - Coding Test 

The assessment consisted of an online round lasting one hour, during which there were 33 questions, all of which were challenging, including the multiple-choice questions. The questions were divided into six subsections: 1. Data Structures and Algorithms (DSA) - with a problem related to dynamic programming or recursion; 2. Java; 3. Java 8; 4. Spring; 5. Spring Boot; 6. Microservices.

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - HR 

(5 Questions)

  • Q1. How to improve to grow work together
  • Ans. 

    Improving teamwork requires clear communication, setting common goals, fostering trust, and providing opportunities for collaboration.

    • Establish clear communication channels to ensure everyone is on the same page

    • Set common goals and objectives for the team to work towards

    • Foster trust among team members by encouraging open communication and transparency

    • Provide opportunities for collaboration through team-building activit...

  • Answered by AI
  • Q2. Well management
  • Q3. Learning to improve skills to improve to person is great
  • Q4. Great things to always always big dreams to make sure
  • Q5. Success to improve
  • Ans. 

    Success to improve involves setting clear goals, measuring progress, seeking feedback, and making adjustments.

    • Set specific, measurable, achievable, relevant, and time-bound (SMART) goals.

    • Regularly track progress towards goals and adjust strategies as needed.

    • Seek feedback from stakeholders and incorporate suggestions for improvement.

    • Continuously learn and adapt to changing circumstances.

    • Celebrate successes and learn fro

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - change your mindset keep learning to growth

I applied via AmbitionBox and was interviewed in Oct 2022. There were 7 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

General knowledge information

Round 3 - Group Discussion 

It topic general topics like online shopping is good or bad

Round 4 - Coding Test 

Technical like c java html c++

Round 5 - Coding Test 

Website design . Java c html online shopping

Round 6 - HR 

(1 Question)

  • Q1. Experience of previous company
Round 7 - One-on-one 

(1 Question)

  • Q1. Personal information

Interview Preparation Tips

Interview preparation tips for other job seekers - I have done BE in computer science and engineering
Also experienced in tech Mahindra as customer service accositive
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I was interviewed before Oct 2022.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(6 Questions)

  • Q1. What's your experience for coustomer executive
  • Q2. I know sir super
  • Q3. Good communication skills
  • Q4. Good coustomer executive
  • Q5. Supporting of coustomer
  • Ans. 

    Supporting customers is crucial for business success. It involves providing excellent service, addressing concerns promptly, and building strong relationships.

    • Provide excellent customer service by being responsive and helpful

    • Address customer concerns promptly and effectively

    • Build strong relationships with customers to foster loyalty and repeat business

  • Answered by AI
  • Q6. And finally good

Interview Preparation Tips

Interview preparation tips for other job seekers - Coustomer executive, yes i know superb

I applied via Referral and was interviewed in Jun 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What were the challenges you faced while working with team members and how you resolved it.

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare your basics well.

Saks OFF 5TH Interview FAQs

How many rounds are there in Saks OFF 5TH Senior BI Engineer interview?
Saks OFF 5TH interview process usually has 1 rounds. The most common rounds in the Saks OFF 5TH interview process are Technical.
What are the top questions asked in Saks OFF 5TH Senior BI Engineer interview?

Some of the top questions asked at the Saks OFF 5TH Senior BI Engineer interview -

  1. If left and right table have same data, then will left and right join give same...read more
  2. Concat , substring in ...read more

Tell us how to improve this page.

Saks OFF 5TH Senior BI Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Reliance Retail Interview Questions
3.9
 • 1.5k Interviews
Walmart Interview Questions
3.8
 • 408 Interviews
DMart Interview Questions
3.9
 • 398 Interviews
Vishal Mega Mart Interview Questions
3.8
 • 157 Interviews
Landmark Group Interview Questions
4.0
 • 146 Interviews
V-Mart Interview Questions
4.1
 • 145 Interviews
Lowe's Interview Questions
4.2
 • 130 Interviews
Target Interview Questions
4.2
 • 117 Interviews
Shoppers Stop Interview Questions
4.1
 • 110 Interviews
View all
Associate
4 salaries
unlock blur

₹4.1 L/yr - ₹4.8 L/yr

Financial Analyst
3 salaries
unlock blur

₹5.1 L/yr - ₹6.5 L/yr

Assistant Manager
3 salaries
unlock blur

₹12 L/yr - ₹17 L/yr

Senior Finance Associate
3 salaries
unlock blur

₹9.5 L/yr - ₹10.7 L/yr

Regional HR
3 salaries
unlock blur

₹43 L/yr - ₹51 L/yr

Explore more salaries
Compare Saks OFF 5TH with

Brand Factory

4.5
Compare

Reliance Trends

4.2
Compare

Lifestyle

4.3
Compare

Pantaloons

4.2
Compare
Did you find this page helpful?
Yes No
write
Share an Interview