Upload Button Icon Add office photos

Soho House Mumbai

Compare button icon Compare button icon Compare

Filter interviews by

Soho House Mumbai Senior ETL Developer Interview Questions and Answers for Experienced

Updated 2 Apr 2022

Soho House Mumbai Senior ETL Developer Interview Experiences for Experienced

1 interview found

I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. What difference between temporary table and global temporary table?
  • Ans. 

    Temporary tables are session-specific while global temporary tables are accessible across sessions.

    • Temporary tables are created in a user's temporary tablespace and are automatically dropped at the end of the session.

    • Global temporary tables are created in a user's temporary tablespace but are not automatically dropped at the end of the session.

    • Temporary tables are only accessible within the session that created them.

    • Gl...

  • Answered by AI
  • Q2. Different between function and Store procedure?
  • Ans. 

    Functions return a single value while stored procedures can return multiple values and perform complex operations.

    • Functions are used to perform a single operation and return a single value.

    • Stored procedures can perform complex operations and return multiple values.

    • Functions can be used in SQL statements while stored procedures cannot.

    • Functions are faster than stored procedures as they do not require compilation.

    • Stored ...

  • Answered by AI
  • Q3. Drawback of SSIS packages?
  • Ans. 

    SSIS packages can be complex and difficult to troubleshoot.

    • Debugging can be time-consuming and challenging.

    • SSIS packages can be resource-intensive and slow down other processes.

    • Version control can be difficult to manage.

    • SSIS packages may not be suitable for real-time data integration.

    • SSIS packages may require additional licensing costs for advanced features.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn new things and understand basic knowledge of Sql

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
2w
toobluntforu
·
works at
Cvent
Can speak English, can’t deliver in interviews
I feel like I can't speak fluently during interviews. I do know english well and use it daily to communicate, but the moment I'm in an interview, I just get stuck. since it's not my first language, I struggle to express what I actually feel. I know the answer in my head, but I just can’t deliver it properly at that moment. Please guide me
Got a question about Soho House Mumbai?
Ask anonymously on communities.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. What is jvm ?
  • Q2. What is oops ?
  • Q3. What is collection ?
  • Q4. What is exception handling in java ?
  • Q5. What is multi threading ?
  • Ans. 

    Multi threading is a programming concept where multiple threads run concurrently within a single process.

    • Allows for parallel execution of tasks

    • Improves performance by utilizing multiple CPU cores

    • Requires synchronization to prevent race conditions

    • Examples: running multiple tasks simultaneously in a web server, processing data in parallel

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just preapre well for the basic and all fundamentals should be clear and updated

Skills evaluated in this interview

Senior ETL Developer Interview Questions Asked at Other Companies for Experienced

Q1. What is the difference between a temporary table and a global tem ... read more
Q2. What is the difference between a function and a stored procedure?
Q3. What are the drawbacks of SSIS packages?

I applied via Walk-in and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is food cost
  • Ans. 

    Food cost refers to the total cost of ingredients and supplies used to prepare a dish or menu item.

    • Food cost is calculated by adding up the cost of all the ingredients and supplies used in a recipe or menu item.

    • It is an important metric for restaurants and food establishments to track and manage their expenses.

    • Food cost can be expressed as a percentage by dividing the cost of ingredients by the selling price of the dis...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Cost of the food sold

I appeared for an interview in Apr 2017.

Interview Questionnaire 

1 Question

  • Q1. Family ,occupation,motivation & experience

Interview Preparation Tips

Round: HR
Experience: Done

Round: HR Interview
Experience: Done

Round: Branch manager
Experience: Done

Skills: Sales, Client Pitch Presentation

I applied via Recruitment Consultant and was interviewed before Jul 2017. There were 5 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. 35mint
  • Q2. 50mint
  • Q3. 2hour

Interview Preparation Tips

Round: Test
Experience: System screen test

General Tips: Very easily interview. ...
Skills: Good condition , Body Language, Analytical Skills, Decision Making Skills
Duration: <1 week

Interview Questionnaire 

3 Questions

  • Q1. What u do??
  • Q2. Why u applied for this??
  • Ans. 

    I applied for this internship because I am passionate about gaining practical experience in the field and developing my skills.

    • Passionate about gaining practical experience

    • Desire to develop skills in the field

    • Opportunity to learn from professionals

    • Interest in the company's work and values

  • Answered by AI
  • Q3. What is there in today's newspaper??
  • Ans. 

    The newspaper contains news articles, opinion pieces, advertisements, and other information.

    • News articles covering current events

    • Opinion pieces discussing various topics

    • Advertisements for products and services

    • Sports section with updates on games and matches

    • Weather forecast for the day

    • Local events and community news

    • Business section with stock market updates

    • Entertainment section featuring movie reviews and celebrity news

  • Answered by AI

Interview Preparation Tips

Round: Group Discussion
Experience: we entered. introduced ourselves. then given a task in which we need to know the nxt person sitting to us and then we have to describe them.
Tips: Here they check what kind of communication skills you are having and how much you can convince a person to gain knowledge
Duration: 5 minutes

I applied via Campus Placement and was interviewed before Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself.
  • Q2. Why do you want to work here
  • Ans. 

    I want to work here because of the company's innovative approach, strong values, and commitment to employee growth and customer satisfaction.

    • Innovative Culture: The company is known for its cutting-edge solutions, like the recent launch of a new product that revolutionized customer engagement.

    • Strong Values: I admire the company's commitment to integrity and transparency, which aligns with my personal values and work et...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It's pretty simple to crack the interview of mahindra holidays, just be prepared with some basic knowledge of sales if your fresher and if your experienced then they will ask you about your past experience
Are these interview questions helpful?

I applied via Approached by Company and was interviewed before Nov 2021. There were 2 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 - One-on-one 

(3 Questions)

  • Q1. Tell about convincing a customer
  • Ans. 

    Convincing a customer requires understanding their needs and providing a solution that meets those needs.

    • Listen actively to the customer's concerns and needs

    • Provide relevant information and benefits of the product/service

    • Address any objections or hesitations the customer may have

    • Offer a solution that meets the customer's needs and budget

    • Follow up with the customer to ensure satisfaction and address any further concerns

  • Answered by AI
  • Q2. Then relationshipanagement
  • Q3. Personal details and work

Interview Preparation Tips

Interview preparation tips for other job seekers - Good if you a passion for sales and relationship management

I applied via Walk-in and was interviewed before Sep 2021. There were 2 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 - One-on-one 

(2 Questions)

  • Q1. Crucial quality of a sales person?
  • Q2. Difference between sales and marketing?

Interview Preparation Tips

Interview preparation tips for other job seekers - More than answers... they need you to be confident while talking

Interview Questionnaire 

1 Question

  • Q1. How u do growth of organization
  • Ans. 

    To drive the growth of an organization, I would focus on strategic planning, effective leadership, employee development, customer satisfaction, and innovation.

    • Developing and implementing a strategic plan to identify growth opportunities and set clear objectives.

    • Providing strong leadership and guidance to motivate and inspire employees towards achieving organizational goals.

    • Investing in employee development and training...

  • Answered by AI

Soho House Mumbai Interview FAQs

How many rounds are there in Soho House Mumbai Senior ETL Developer interview for experienced candidates?
Soho House Mumbai interview process for experienced candidates usually has 1 rounds. The most common rounds in the Soho House Mumbai interview process for experienced candidates are Technical.
What are the top questions asked in Soho House Mumbai Senior ETL Developer interview for experienced candidates?

Some of the top questions asked at the Soho House Mumbai Senior ETL Developer interview for experienced candidates -

  1. What difference between temporary table and global temporary tab...read more
  2. Different between function and Store procedu...read more
  3. Drawback of SSIS packag...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Burger King Interview Questions
3.9
 • 81 Interviews
Cafe Coffee Day Interview Questions
3.7
 • 70 Interviews
Hyatt Regency Interview Questions
4.2
 • 45 Interviews
Pizza Hut Interview Questions
3.9
 • 44 Interviews
JW Marriott Interview Questions
4.1
 • 44 Interviews
View all
Bartender
7 salaries
unlock blur

₹2.4 L/yr - ₹4.5 L/yr

Assistant Waiter
7 salaries
unlock blur

₹1.1 L/yr - ₹2.2 L/yr

Housekeeping Supervisor
6 salaries
unlock blur

₹3 L/yr - ₹3.5 L/yr

Commis Chef
5 salaries
unlock blur

₹1.6 L/yr - ₹2.5 L/yr

Commie 2
5 salaries
unlock blur

₹3 L/yr - ₹10.1 L/yr

Explore more salaries
Compare Soho House Mumbai with

Jubilant Foods Works

3.7
Compare

Mahindra Holidays & Resorts

3.5
Compare

Cafe Coffee Day

3.7
Compare

Marriott International

4.1
Compare
write
Share an Interview