AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Saks OFF 5TH Senior BI Engineer Interview Questions and Answers
Saks OFF 5TH Senior BI Engineer Interview Experiences
1 interview found
ayush agrawal
Selected
I applied via Referral and was interviewed before Jul 2023. There was 1 interview round.
(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
Eklavya Mahajan
Interview Questionnaire
8 Questions
- Q1. What factors can you think of which will determine the pricing of product on our e-retail website?
- Ans.
Factors affecting pricing of products on e-retail website
Cost of production
Competitor pricing
Demand and supply
Target audience
Marketing and advertising costs
- Q2. We add a lot of products and their descriptions on a laptop webpage, it will get too cluttered if we try the same for a mobile app. What things can be done differently for a webpage on mobile app?
- Q3. Which scrolling option is the best for e-retail websites? Vertical scrolling or horizontal product scrolling or each product on a different page or something else?
- Ans.
Vertical scrolling is the best option for e-retail websites.
Vertical scrolling is more intuitive and easier to use for most users.
Horizontal scrolling can be confusing and frustrating for users.
Each product on a different page can lead to slower load times and more clicks for users.
Infinite scrolling can be a good option for some e-retail websites.
Consider the type of products being sold and the user experience when de
- Q4. What was your happiest moment in life?
- Ans.
My happiest moment was when I got accepted into my dream university.
Received the acceptance letter in the mail
Celebrated with family and friends
Felt a sense of accomplishment and excitement for the future
- Q5. Tell me about your internships in short
- Ans.
I completed internships at two different companies, one focused on web development and the other on software testing.
Interned at XYZ Company as a web developer, worked on front-end development using React and back-end development using Node.js
Interned at ABC Company as a software tester, tested various software applications and reported bugs to the development team
- Q6. Strengths and weaknesses?
- Ans.
My strengths include problem-solving, adaptability, and teamwork. My weaknesses include public speaking and time management.
Strengths: Problem-solving - I enjoy finding solutions to complex problems. Adaptability - I am able to quickly adjust to new situations. Teamwork - I work well in a team environment and value collaboration.
Weaknesses: Public speaking - I get nervous when speaking in front of large groups. Time ma...
- Q7. What are your interests beyond academics?
- Ans.
I enjoy playing sports, reading books, and volunteering in my community.
Playing basketball and soccer with friends
Reading books on technology and self-improvement
Volunteering at local food banks and animal shelters
- Q8. You seem to have a good CPI. Why are you not going for MS or MBA? Do you intend to go for any such thing some years later?
- Ans.
I believe gaining practical experience is more valuable than pursuing further education at this point in my career.
I have gained valuable experience through internships and projects
I am constantly learning and improving my skills through online courses and workshops
I may consider pursuing further education in the future if it aligns with my career goals
Interview Preparation Tips
Experience: Resume shortlist was CPI cutoff based mostly.
Tips: Highlight all your strong points in the resume and don't forget to make different resumes for different profiles you are targeting. Other than that, your resume is what you make of it in your 4 or 5 years of your stay here!
Round: Test
Experience: The test was common for software analyst as well as business analyst profile. So that was sort of a drawback for the people targeting business analyst profile. But most of the coding questions were easily solvable and required little knowledge of coding.
Tips: Just try to improve your aptitude skills and freshen up some basic C++ concepts - very basic ones. You'll do great!
Round: Puzzle Interview
Experience: Though I am not able to recall the puzzles asked, but they were moderate in difficulty level, plus the interviewers were helping a lot and were very friendly
Tips: Practice some basic puzzles, mostly the ones asked for coding interviews (you can search them online). Keep your calm and think thoroughly. Also, don't hesitate to ask for help whenever required. They would love to offer help more than you would like to get!
Round: Technical Interview
Experience: Since my background in coding was not that great, and I had already told them so, thus they mostly asked me strategic questions like the ones mentioned above.
Tips: Think logically and just spit out whatever comes to your mind would be the best option/strategy. They are looking for innovative answers and also a wide variety of alternatives, and then choose the best ones. Again, they will help you in case of any confusion or in case you need some example strategies.
Round: HR Interview
Experience: This round initially focused primarily on my internships. The interviewer seemed interested to know about the work done in internships, the accomplishments, the moments worth remembering from the foreign internships. Later she moved on to the hobbies, strengths, weaknesses and was quite involved with my life stories! She had a pad to note down my answers and judge abilities like communication skills, fluency, confidence in answers etc. At the end, I got the remark "This was by far the best interview I conducted" (and I was the last candidate to get interviewed!)
Tips: Answer the questions with total honesty and keep them involved with intriguing stories that depict your strengths or weaknesses. Interest them with your hobbies and be ready to answer questions on any hobby! Keep your stories prepared for the happiest moment, failures, things you would change in life etc. Read the book "64 HR interviews" and prepare answers for most of them. This round is mainly to see your confidence, your passion, your liveliness and your enthusiasm for the position.
General Tips: Most of the tips were discussed in respective questions. In general, I would like to say that never lose hope no matter how hard you struggle through the first few days. The moment you lose hope, things start going the wrong way. Also, give the interviews with relaxed and calm mind, after proper sleep. Take the interviews to the direction you want them to go - it can be easily done and I can tell you that from my own experiences. Be honest, otherwise you will take the interview to the direction you don't want it to go!
Skills: Confidence, Communication skills, Logical thinking , Problem solving, Brainstorming skills, Rational thinking
College Name: IIT BOMBAY
Motivation: It is a well reputed firm, a Fortune 50 company and the experience would be a good launchpad for ahead. I wanted a work-life balance slightly tilted towards "life" and Target is the company to go for that (which I came to know from my seniors, glassdoor.com etc.)
Funny Moments: There were no specific funny moments as such but overall, the interviews were relaxed and the interviewers were very friendly and cheerful. So I had some great moments while sharing my hobbies (eg. I told them I like to read poems so they asked me to recite one!) etc.
Skills evaluated in this interview
Supreet Singh
Interview Preparation Tips
Experience: Standard resume shortlisting. Almost everyone was shortlisted for the test. You were given an option to choose between software and analyst profile.
Tips: Prepare your resume well on time. Give it a month at least. Send it over to a lot of seniors for reviews.
Round: Test
Experience: Test wa fairly easy. It had two sections. One was mental ability. I am hoping any IIT student can crack these questions. Second part was basic coding questions, 2 of them. If you know basic coding, you can solve it. Nothing fancy.
Tips: Prepare well for tests immediately after resume. Brush up basic coding commands if you expect coding questions in the test. One can do preparation on the lines of cat for these tests.
General Tips: I cannot say this enough times but you have to be patient, calm and confident. You will get a job. Everyone doesn't get a job on day 1. You may also get to hear thousands of methods to prepare for jobs. Don't listen to everyone. Just choose obe or two good sources and stick to them. Else you just waste time worrying about how much you need to prepare.
Skill Tips: I prepared on a very general level for all companies. If you are fairly sure of what kind of company you want, do company specific prep.
Skills: Analytical skills, Basic coding skills
College Name: IIT BOMBAY
Motivation: The profile offered had both analytics and coding. It was like the best of both worlds for me. Also, great company. Great money.
B . Vishnu Bhargav
Interview Preparation Tips
Experience: Quant was easy , you can do all of it . just go through the indiabix or some website before going to the exam.Coding section was also easy , just brush up your basics of C thats enough , none of the high fundae DSA was asked .
Tips: - geeksforgeeks.com contains almost everything about coding you need for getting placed .- if you are done with it start coding in codechef .
Duration: 1 hr minute
Skill Tips: Focus on your Study.. Revise the subject that you have studied at the time of Interview
Skills: Technical Skills
College Name: IIT Madras
Interview Questionnaire
14 Questions
- Q1. Why do you want to come to Software profile when you studied Chemical Engineering?
- Ans.
I realized my passion for coding during my Chemical Engineering studies and pursued it further through self-learning and projects.
Discovered passion for coding during Chemical Engineering studies
Pursued coding through self-learning and projects
Believe software engineering offers more opportunities for growth and impact
- Q2. Future Plans?
- Q3. Weaknesses?
- Q4. Name a situation where you planned something but due to some other problems you have to adjust in the end?
- Ans.
While planning a project, I had to adjust the timeline due to unexpected delays in the delivery of hardware components.
Planned a project with a specific timeline
Ordered necessary hardware components
Delivery of hardware components was delayed
Adjusted the timeline to accommodate the delay
Ensured that the project was completed successfully despite the delay
- Q5. Name a situation where you had to change your behaviour according to situation?
- Ans.
During a team project, I adjusted my communication style to better collaborate with a team member.
I noticed that my team member preferred more frequent check-ins and updates than I was used to.
I adapted by scheduling regular meetings and sending progress updates more frequently.
This helped us work more effectively together and complete the project on time.
- Q6. Name a situation where you had to deal with 2-3 different groups?
- Ans.
As a project lead, I had to coordinate with the development, testing, and design teams to ensure timely delivery of a product.
Coordinated with development team to ensure timely completion of coding tasks
Worked with testing team to ensure proper testing and bug fixing
Collaborated with design team to ensure product met client's expectations
- Q7. Name a situation where you were part of group and made difference?
- Ans.
I led a team to develop a new feature for our company's flagship product.
Identified the need for the feature through customer feedback
Convinced the team and management to prioritize the feature
Coordinated with designers, developers, and testers to deliver the feature on time
Received positive feedback from customers and increased revenue for the company
- Q8. Name a situation where you took an initiative?
- Ans.
I initiated a project to automate the testing process for our team.
Identified the need for automation to save time and improve accuracy
Researched and evaluated different testing tools
Presented the proposal to the team and got their buy-in
Implemented the automation process and trained the team on its usage
- Q9. Give an experience of working as part of a team?
- Ans.
Worked as part of a team in developing a mobile application.
Collaborated with team members to define project requirements
Assigned tasks and tracked progress using project management tools
Conducted code reviews and provided feedback to team members
Resolved conflicts and ensured timely delivery of project milestones
- Q10. Name situation where you had to prepare for a speech for a special group of people?
- Ans.
Prepared a speech for a group of high school students on the importance of computer science.
Researched the audience to understand their interests and level of knowledge
Created an engaging presentation with relatable examples
Practiced the speech multiple times to ensure smooth delivery
Encouraged questions and feedback from the audience
Provided additional resources for those interested in pursuing computer science
- Q11. Focussed more about my 3rd year intern where I developed an application using VBA for STP
- Q12. Questions about Android and e-commerce
- Q13. Then asked about my football interests(I said to him I am football blogger), so asked me to explain few articles which I wrote
- Q14. All about my resume, my BTP
Interview Preparation Tips
Experience: I alotted around 3-4 days for Resume Preparation. This is very important step,especially for companies with Consultancy profile. I referred to some of my seniors resumes to get to know the format and the grammar used,especially framing of sentences.
Tips: Once your resume is prepared, don't forget to collect feedback about it from your seniors and even from some of your wing mates. Also, get to know about difference between resumes for core and non-core profiles
Round: Test
Experience: First Section was simple aptitude(20 Question),were very simple.Second Section was Programming(10 questions), were bit questions related to theory. Don't remember properly but few questions related to Binary tree were asked I guessThird section was Coding(1 question),it was simple. Question-Code a program which gives output as '1' when the number given as input can be expressed as "p^q"(where p,q are integers) and as '0' if otherwise.
Tips: Just,general CAT preparation is enough for aptitude.Regarding Coding, even knowing any 1 language is enough. Just practice few basic coding questions online and even sorting algorithms
Duration: 60 minutes
Total Questions: 31
Round: Interview
Experience: The HR interview was not easy, some of the questions were really unexpected. Such type of HR questions were not asked in any of previous HR interviews(of other companies) I attended to.
Tips: For most of the questions asked above, you can find answers from your P.O.R's(Position of Responsibilities) which you have done.Take HR round seriously and prepare for it before placements start(avoid last minute preparation).
Round: Interview
Experience: This was very comfortable, I connected very well with interviewer,especially when we were discussing about footbal as he was also a football enthusiast. I also prepared few things related to e-commerce which helped
Tips: Prepare and get to know about e-commerce field, general problems faced in it these days
Round: Interview
Experience: Was easy
Tips: Just prepare properly about everything written in resume,mainly 3rd year intern and BTP or any other projects
General Tips: Just follow all the tips mentioned earlier,avoid last minute preparation, prepare well in advance. Don't lose hope or get depressed during placement period if you fail in your initial few interviews
College Name: IIT Madras
Motivation: Wanted to work in a coding or analytics profile
I applied via LinkedIn and was interviewed in Dec 2020. There were 4 interview rounds.
Interview Questionnaire
1 Question
- Q1. How you will design an E-Commerce system
- Ans.
An E-Commerce system can be designed by identifying user requirements, selecting appropriate technologies, and implementing secure payment and shipping methods.
Identify user requirements and create user stories
Select appropriate technologies for front-end, back-end, and database
Implement secure payment and shipping methods
Design a user-friendly interface with easy navigation
Ensure scalability and performance of the sys...
Interview Preparation Tips
Second round was an assignment .
Third round was again a technical interview
Skills evaluated in this interview
I applied via Naukri.com and was interviewed before Jan 2021. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. DS/Algo question leetcode medium
- Q2. Working code with edge cases.
- Ans.
Working code with edge cases is code that has been tested with extreme inputs to ensure it functions correctly.
Edge cases are inputs that are unlikely to occur but can cause unexpected behavior if not handled properly.
Examples of edge cases include empty inputs, null values, and inputs at the limits of the data type's range.
Working code with edge cases should be thoroughly tested to ensure it functions correctly in all
Interview Preparation Tips
Core basic should be strong.
Should be ready for tricky questions.
Interview Questionnaire
2 Questions
- Q1. Why you choose this job role only
- Q2. If somebody give you the better salary but different organisation. Which will you choose
Interview Preparation Tips
Interview Questionnaire
3 Questions
- Q1. How to generate an unique id for a massive parallel system?
- Ans.
An unique id for a massive parallel system can be generated using a combination of timestamp, machine id and a random number.
Use a timestamp to ensure uniqueness
Include a machine id to avoid collisions in a distributed system
Add a random number to further increase uniqueness
Consider using a UUID (Universally Unique Identifier) for simplicity
Ensure the id generation algorithm is thread-safe
- Q2. Design a parking lot system?
- Ans.
A parking lot system that manages parking spots and vehicles.
Create a class for parking lot with attributes like total number of spots, available spots, etc.
Create a class for vehicle with attributes like license plate number, type, etc.
Implement methods for parking a vehicle, removing a vehicle, and checking availability of spots.
Use data structures like arrays and maps to store and retrieve information.
Consider imple
- Q3. Singleton ,Factory design pattern
Interview Preparation Tips
Skills evaluated in this interview
I applied via AmbitionBox and was interviewed in Oct 2022. There were 7 interview rounds.
General knowledge information
It topic general topics like online shopping is good or bad
Technical like c java html c++
Website design . Java c html online shopping
(1 Question)
- Q1. Experience of previous company
(1 Question)
- Q1. Personal information
Interview Preparation Tips
Also experienced in tech Mahindra as customer service accositive
Saks OFF 5TH Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Billing Engineer Interview Questions
- Big Data Engineer Interview Questions
- Biomedical Engineer Interview Questions
- BIM Engineer Interview Questions
- Senior Billing Engineer Interview Questions
- Software Engineer Interview Questions
- Planning & Billing Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Show more
Saks OFF 5TH Senior BI Engineer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Associate
4
salaries
|  ₹4.1 L/yr - ₹4.8 L/yr |
|
Financial Analyst
3
salaries
| ₹5.1 L/yr - ₹6.5 L/yr |
|
Assistant Manager
3
salaries
| ₹12 L/yr - ₹17 L/yr |
|
Senior Finance Associate
3
salaries
| ₹9.5 L/yr - ₹10.7 L/yr |
|
Regional HR
3
salaries
| ₹43 L/yr - ₹51 L/yr |
Reliance Retail
DMart
Future Group
Vishal Mega Mart
- Home >
- Interviews >
- Saks OFF 5TH Interview Questions >
- Saks OFF 5TH Senior BI Engineer Interview Questions
