Deloitte Trainee Analyst Interview Questions and Answers

I have worked on multiple projects using various programming languages. My long term goal is to become a data analyst and my preferred technologies are Python and SQL.

• Projects: E-commerce website using PHP, Inventory management system using Java, Data analysis of customer behavior using Python

• Programming languages: Python, Java, PHP, SQL

• Program: Python program to calculate the factorial of a number

• Long term goal: To become a data analyst

• Preferred technologies: Python and SQL

Program to swap substrings of two strings

• Create a function that takes in two strings and two indices representing the start and end of the substrings to swap

• Use string slicing to extract the substrings and swap them

• Combine the modified substrings with the rest of the strings to get the final swapped strings

Program to reverse a string

• Create a function that takes a string as input

• Use a loop to iterate through the characters of the string in reverse order

• Append each character to a new string to build the reversed string

Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity.

• 1NF (First Normal Form) - Each column in a table must contain atomic values, and each row must be unique.

• 2NF (Second Normal Form) - Table is in 1NF and all non-key attributes are fully functional dependent on the primary key.

The OSI (Open Systems Interconnection) model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven distinct layers.

• Layer 1 - Physical layer: Deals with physical connections and transmission of raw data.

• Layer 2 - Data link layer: Manages data frames and error detection.

• Layer 3 - Network layer: Handles routing and logical addressing.

• Layer 4 - Transport layer: Ensures end-to-end communication and error recovery.

• Layer 5 - ...read more