Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Deloitte Team. If you also belong to the team, you can get access from here

Deloitte Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 17.2k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Deloitte DBA Manager Interview Questions and Answers

Updated 21 Aug 2024

Deloitte DBA Manager Interview Experiences

1 interview found

DBA Manager Interview Questions & Answers

user image Anonymous

posted on 21 Aug 2024

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

I was interviewed in Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. How to Migrate to AWS
  • Ans. 

    Migrating to AWS involves planning, preparation, and execution of a structured migration strategy.

    • Assess current infrastructure and applications to determine compatibility with AWS

    • Create a detailed migration plan outlining timelines, resources, and dependencies

    • Use AWS Migration Hub to track the progress of migration

    • Utilize AWS Database Migration Service for database migration

    • Consider using AWS Server Migration Service ...

  • Answered by AI
  • Q2. Ho to migrate to Azure
  • Ans. 

    Migrating to Azure involves planning, assessment, preparation, migration, and post-migration tasks.

    • Assess current infrastructure and applications for compatibility with Azure

    • Plan the migration strategy including timelines, resources, and potential challenges

    • Prepare by setting up Azure environment, configuring networking, and ensuring data security

    • Migrate data and applications using tools like Azure Site Recovery or Azu...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

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

I was interviewed before Feb 2024.

Round 1 - Technical 

(5 Questions)

  • Q1. What is the SQL query using PIVOT to transform the given input table into the expected output?
  • Q2. What is the process flow for implementing an incremental load?
  • Q3. What are the steps involved in query optimization?
  • Q4. What is the process flow of Slowly Changing Dimension Type 2 (SCD 2), and what are the associated post commands?
  • Q5. Difference Between dimension tables and fact tables.Which one loaded firs?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Stored Procedure to get user input
  • Q2. Use error handling method with Stored Procedure
Round 2 - One-on-one 

(1 Question)

  • Q1. Details about company and previous Projects

ETL Developer Interview Questions & Answers

ZS user image Aatmikta Sirothiya

posted on 25 Oct 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Situation based questions, by giving some data and about the dedup logic by using sql
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Job Portal and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - Coding Test 

On the sql, python and other puzzles

Interview Preparation Tips

Interview preparation tips for other job seekers - asked on the sql problems like joins, group, window function, database and warehouse diff
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2023. 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 - Technical 

(2 Questions)

  • Q1. Questions related to Oracle database
  • Q2. AWS, Postgres, Sql, DMS

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview will happen in night during US timings.

Deloitte Interview FAQs

How many rounds are there in Deloitte DBA Manager interview?
Deloitte interview process usually has 1 rounds. The most common rounds in the Deloitte interview process are One-on-one Round.
What are the top questions asked in Deloitte DBA Manager interview?

Some of the top questions asked at the Deloitte DBA Manager interview -

  1. How to Migrate to ...read more
  2. Ho to migrate to Az...read more

Tell us how to improve this page.

Deloitte DBA Manager Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.3k Interviews
Accenture Interview Questions
3.9
 • 8.1k Interviews
Capgemini Interview Questions
3.8
 • 4.8k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
PwC Interview Questions
3.4
 • 1.4k Interviews
Ernst & Young Interview Questions
3.5
 • 1.1k Interviews
KPMG India Interview Questions
3.5
 • 790 Interviews
ZS Interview Questions
3.4
 • 479 Interviews
BCG Interview Questions
3.8
 • 195 Interviews
View all
Consultant
33k salaries
unlock blur

₹6.2 L/yr - ₹23 L/yr

Senior Consultant
20.7k salaries
unlock blur

₹11 L/yr - ₹42 L/yr

Analyst
14k salaries
unlock blur

₹3.7 L/yr - ₹12.4 L/yr

Assistant Manager
10k salaries
unlock blur

₹7.8 L/yr - ₹24 L/yr

Manager
7k salaries
unlock blur

₹15.8 L/yr - ₹52 L/yr

Explore more salaries
Compare Deloitte with

Accenture

3.9
Compare

PwC

3.4
Compare

Ernst & Young

3.4
Compare

Cognizant

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