AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Deloitte
Compare
Filter interviews by
Deloitte Business Technology Analyst Interview Questions and Answers
23 Interview questions
LogMiner is a utility provided by Oracle to analyze and mine redo log files for data changes.
LogMiner is used to analyze and extract data from redo log files generated by Oracle databases.
It can be used for tasks like auditing, troubleshooting, and recovering lost data.
LogMiner can help track changes made to the database, such as INSERT, UPDATE, and DELETE operations.
Cloning a database involves creating an exact copy of an existing database.
Use database management tools like SQL Server Management Studio or MySQL Workbench to clone a database.
Backup the existing database before cloning to avoid data loss.
Restore the backup file to create a new database with the same schema and data.
Update connection strings and configurations to point to the new cloned database.
Test the cloned ...
To use a particular type of shell like korn or bash shell in shell scripting, specify the shell at the beginning of the script.
Specify the shell at the beginning of the script using the shebang line (#!/bin/bash for bash shell, #!/bin/ksh for korn shell, etc.)
Make sure the specified shell is installed on the system where the script will be executed
Use shell-specific syntax and features in the script based on the c...
Block level corruption can be found using tools like checksums and resolved by restoring from backups or repairing the corrupted blocks.
Use checksums to detect block level corruption by comparing the checksum of the data against a known good checksum.
Regularly run integrity checks on storage devices to identify any corrupted blocks.
Restore the corrupted blocks from backups if available, or repair them using tools ...
What people are saying about Deloitte
Backup strategies are plans and procedures put in place to protect data in case of loss or corruption.
Regularly scheduled backups to ensure data is up to date
Offsite backups to protect against physical damage or theft
Incremental backups to save storage space and time
Automated backups to reduce human error
Testing backups to ensure they can be restored successfully
What are the roles & responsibilities of a Business Technology Analyst at Deloitte?
Read full roles & responsibilities 
SQL DML commands are used to manipulate data in a database.
INSERT: Adds new rows of data into a table
UPDATE: Modifies existing data in a table
DELETE: Removes rows of data from a table
Deloitte HR Interview Questions
Infor ION is a middleware platform that connects disparate systems and enables data exchange.
Infor ION uses a publish-and-subscribe model to facilitate communication between systems.
It can be implemented on a variety of projects, including ERP, CRM, and supply chain management systems.
Infor ION also includes pre-built connectors for popular systems like Salesforce and SAP.
Implementation typically involves configur...
The given HTML command is used to create a hyperlink in a webpage.
The <a> tag is used to define a hyperlink in HTML.
The href attribute specifies the URL of the page the link goes to.
Text between the opening and closing <a> tags is the clickable text of the link.
A Business Technology Analyst bridges the gap between business needs and technology solutions, ensuring effective project delivery.
Understand business requirements: Analyze and document what the business needs from technology.
Collaborate with stakeholders: Work with both technical teams and business units to ensure alignment.
Conduct market research: Stay updated on technology trends that can benefit the organizati...
Triggers in databases automate actions in response to specific events, enhancing data integrity and workflow efficiency.
Triggers can be set to activate on INSERT, UPDATE, or DELETE operations.
Example: A trigger can automatically update a 'last_modified' timestamp when a record is updated.
They can enforce business rules, such as preventing deletion of records in certain conditions.
Example: A trigger can prevent del...
Deloitte Business Technology Analyst Interview Experiences
37 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2020. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Why string is immutable?
- Q2. How can you make a class immutable in java?
- Ans.
How to make a class immutable in Java?
Make all fields private and final
Do not provide any setter methods
Make the class final
If mutable fields are present, return a copy of them in getter methods
- Q3. How hashmap works?
- Q4. Difference between hashtable and concurrent hashmap!
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Look-up oic questions
(1 Question)
- Q1. Sql plsql questions joins
Easy to medium difficulty mcq questions
(2 Questions)
- Q1. Just a minute round with a technical topic
- Q2. Use of AI in health care
Selected
I applied via Referral and was interviewed in Mar 2023. There were 5 interview rounds.
(1 Question)
- Q1. Basic testing concepts SQL joins
(1 Question)
- Q1. SQL queries using where use of having, group by Difference between DELETE & TRUNCATE
(1 Question)
- Q1. Scenario based testing concept like how will you deal if issues comes in production
(1 Question)
- Q1. Speaking, listening, reading test
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Sep 2023. There was 1 interview round.
It was a tech case where you would have to think of features to add to a product to solve a business solution.
Selected
I appeared for an interview before Sep 2023.
(6 Questions)
- Q1. How did you come to know about Deloitte?
- Q2. How do you use logminer?
- Ans.
LogMiner is a utility provided by Oracle to analyze and mine redo log files for data changes.
LogMiner is used to analyze and extract data from redo log files generated by Oracle databases.
It can be used for tasks like auditing, troubleshooting, and recovering lost data.
LogMiner can help track changes made to the database, such as INSERT, UPDATE, and DELETE operations.
- Q3. How do you clone database?
- Q4. What are the backup strategies?
- Q5. How do you find block level corruption and resolve it?
- Ans.
Block level corruption can be found using tools like checksums and resolved by restoring from backups or repairing the corrupted blocks.
Use checksums to detect block level corruption by comparing the checksum of the data against a known good checksum.
Regularly run integrity checks on storage devices to identify any corrupted blocks.
Restore the corrupted blocks from backups if available, or repair them using tools like ...
- Q6. In shell scripting how to use a particular type shell like korn or bash shell ?
- Ans.
To use a particular type of shell like korn or bash shell in shell scripting, specify the shell at the beginning of the script.
Specify the shell at the beginning of the script using the shebang line (#!/bin/bash for bash shell, #!/bin/ksh for korn shell, etc.)
Make sure the specified shell is installed on the system where the script will be executed
Use shell-specific syntax and features in the script based on the chosen...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Aug 2022. There were 4 interview rounds.
(3 Questions)
- Q1. What is BDE in Infor LN ?
- Q2. How does Infor ION works & implementation done on number of projects
- Ans.
Infor ION is a middleware platform that connects disparate systems and enables data exchange.
Infor ION uses a publish-and-subscribe model to facilitate communication between systems.
It can be implemented on a variety of projects, including ERP, CRM, and supply chain management systems.
Infor ION also includes pre-built connectors for popular systems like Salesforce and SAP.
Implementation typically involves configuring t...
- Q3. Basics of ERP LN & Cloudsuite
(1 Question)
- Q1. Basics of ERP Implementation
(1 Question)
- Q1. Basics of ERP Implementation
(1 Question)
- Q1. Basics of ERP Implementation
Interview Preparation Tips
- ERP Implementation
- INFOR ION
- Infor Cloudsuite
Selected
I applied via Approached by Company and was interviewed before May 2017. There were 6 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Salary discussion and negotiation
- Q2. Java related questions were asked.
- Q3. Selenium waits and some program
- Q4. Asked about Collection Framework and different usecases
- Q5. Different testing Methodologies where they checking code skills
- Q6. Questions around different scenario based coding
- Q7. Asked about project and work done with the experience
- Q8. Given exam in some app where you need to write, speak and hear english senetences.
Selected
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
It was a basic aptitude test , that can be solved be 10th class maths.
(1 Question)
- Q1. It was more of a company fit round, with beginner level questions of coding. interview was more of resume focused.
Interview Preparation Tips
GAUTAM
Selected
I applied via Recruitment Consulltant and was interviewed before Aug 2023. There was 1 interview round.
(1 Question)
- Q1. Tell me about your project?
I applied via Campus Placement
(2 Questions)
- Q1. Tell me about this internship?
- Q2. Tell me about this project.
Interview Preparation Tips
Deloitte Interview FAQs
Some of the top questions asked at the Deloitte Business Technology Analyst interview -
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Data Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 13 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Deloitte Business Technology Analyst Reviews and Ratings
based on 272 reviews
Rating in categories
|
Consultant
41.8k
salaries
|  ₹10.4 L/yr - ₹21.7 L/yr |
|
Senior Consultant
25.8k
salaries
| ₹16.3 L/yr - ₹33.6 L/yr |
|
Analyst
17.1k
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Assistant Manager
11.6k
salaries
| ₹12.1 L/yr - ₹22.4 L/yr |
|
Manager
8.2k
salaries
| ₹24.6 L/yr - ₹44 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions
