Deloitte Interview Questions, Process, and Tips

Implementing pagination on scroll allows for loading more content as the user reaches the bottom of the page.

• Use a scroll event listener to detect when the user has reached the bottom of the page

• Make an API call to fetch more data when the bottom is reached

• Append the new data to the existing content on the page

Immediately invoked function expressions (IIFE) are functions that are executed immediately after they are created.

• IIFE is defined and invoked at the same time using parentheses at the end of the function declaration.

• Anonymous functions do not have a name and can be used as IIFE by wrapping them in parentheses.

• IIFE is commonly used to create a private scope for variables and functions.

Closures are functions that have access to variables from their outer scope even after the outer function has finished executing.

• Closures allow functions to access variables from their parent function even after the parent function has returned

• They help in creating private variables and functions in JavaScript

• Closures are commonly used in event handlers and callbacks

A promise is an object representing the eventual completion or failure of an asynchronous operation.

• Promises are used to handle asynchronous operations in JavaScript.

• They can be in one of three states: pending, fulfilled, or rejected.

• Promises can be chained using .then() method to handle success and failure callbacks.

• Example: Fetch API returns a promise when making an HTTP request.

Lazy loading is a technique used in web development to defer loading non-essential resources until they are needed.

• Lazy loading helps improve page load times by only loading resources when they are required.

• It is commonly used for images, videos, and other media files on a webpage.

• Lazy loading can be implemented using JavaScript libraries like Intersection Observer or by using native browser features like loading='lazy

Deferred revenue refers to income received by a company in advance of earning it, resulting in a liability on the balance sheet.

• Deferred revenue is also known as unearned revenue.

• It is recorded as a liability on the balance sheet until the revenue is recognized.

• Common examples include magazine subscriptions, annual maintenance contracts, and advance payments for services.

• Once the revenue is earned, it is recognized on ...read more

Reconciling bank balances involves comparing the bank statement with the company's records to identify and resolve any discrepancies.

• Obtain the bank statement and compare it with the company's records of transactions.

• Identify any discrepancies such as missing deposits or withdrawals, bank errors, or outstanding checks.

• Adjust the company's records to match the bank statement by recording any necessary corrections.

• Ensure...read more

The three major activities in cash flow statement are operating activities, investing activities, and financing activities. Purchase of fixed assets would fall under investing activities, while repayment of loans would fall under financing activities.

• Operating activities involve cash flows from day-to-day business operations, such as sales and expenses.

• Investing activities include cash flows related to the purchase and...read more

The 5 steps of Revenue recognition are identification of the contract, identification of performance obligations, determination of transaction price, allocation of transaction price, and recognition of revenue as performance obligations are satisfied.

• Identification of the contract: Determine the existence of a contract with a customer.

• Identification of performance obligations: Identify the separate performance obligati...read more

I want to join Deloitte because of its reputation for providing excellent training and career development opportunities.

• Deloitte is known for its high-quality training programs which will help me develop my skills and knowledge in auditing.

• I am impressed by Deloitte's commitment to employee growth and advancement, which aligns with my career goals.

• I believe that working at Deloitte will provide me with the opportunity ...read more

Fixed assets are audited by verifying physical existence, ownership, valuation, and depreciation methods.

• Verify physical existence by conducting physical inventory counts.

• Confirm ownership by reviewing title deeds and purchase agreements.

• Ensure accurate valuation by comparing book value to market value.

• Review depreciation methods and calculations for accuracy.

• Check for impairment indicators and assess if any assets nee...read more

Create calculated fields in Tableau to dynamically adjust to changing table columns.

• Use calculated fields to reference specific columns by name instead of position.

• Utilize parameters to allow users to select which columns to display.

• Consider using custom SQL queries to dynamically adjust to changing table structure.

Developed a predictive model to forecast customer churn for a telecommunications company.

• Utilized machine learning algorithms such as logistic regression and random forest

• Performed data preprocessing and feature engineering to improve model performance

• Collaborated with business stakeholders to understand key drivers of churn

• Achieved 85% accuracy in predicting customer churn

To swap two numbers without a third variable and built-in function in Python, use arithmetic operations.

• Use addition and subtraction to swap the numbers

• Example: a = 5, b = 10. a = a + b, b = a - b, a = a - b will swap the values

The number of zeros in the factorial of 120 is one.

• To find the number of zeros in a factorial, we need to count the number of times the factorial is divisible by 10.

• In the case of 120!, there is one zero because 120! = 120 x 119 x 118 x ... x 1 has one pair of 2 and 5, which results in one zero.

• Factors of 10 in the factorial come from pairs of 2 and 5 in the multiplication.

• For example, in 10!, there are two zeros becau...read more

To find number of incident tickets from Incidents table by each category and order them by number of incident tickets in decreasing order.

• Group the data by category

• Count the number of incident tickets for each category

• Order the results by number of incident tickets in descending order

I am a dedicated and experienced Servicenow Consultant with a strong background in IT service management.

• Over 5 years of experience implementing and customizing Servicenow solutions

• Proficient in ITIL processes and best practices

• Skilled in configuring workflows, forms, and reports

• Strong communication and problem-solving skills

• Certified in Servicenow Administration and Implementation

I am currently working as a Servicenow Consultant responsible for implementing and customizing Servicenow solutions for clients.

• Designing and implementing Servicenow modules based on client requirements

• Customizing workflows, forms, and reports in Servicenow platform

• Providing technical support and training to end users

• Collaborating with cross-functional teams to ensure successful implementation

• Participating in project p

The order of execution of ACLs is determined by the sequence number assigned to each ACL rule.

• ACL rules are executed in numerical order based on the sequence number assigned to them.

• Lower sequence numbers are executed before higher sequence numbers.

• If multiple ACL rules have the same sequence number, the order of execution is determined by the order in which they were created.

• ACL rules with a sequence number of 10000 o...read more

ACLs (Access Control Lists) are permissions that define what users or groups can access or modify specific resources in a system.

• ACLs are used to control access to data and functionality within a system.

• They are typically defined at the object level and specify which users or groups have access to perform certain actions.

• ACLs can be set to restrict or allow read, write, create, delete, or execute permissions.

• For exampl...read more

Syntax for including Mail Script in a notification body

• Use ${mail_script} to include the Mail Script in a notification body

• Ensure the Mail Script is properly formatted and enclosed in ${}

• Example: Hello, ${mail_script} is the Mail Script for this notification

Substitute record values/Link in the mail body using placeholders.

• Use placeholders in the mail body template to substitute record values or links.

• Retrieve the record values or links from the database or API.

• Replace the placeholders with the actual values before sending the email.

Different ways to implement REST APIs integration

• Using HTTP methods like GET, POST, PUT, DELETE

• Using authentication methods like OAuth, API keys

• Using webhooks for real-time data updates

• Implementing rate limiting to prevent abuse

• Leveraging API gateways for security and monitoring

• Using API documentation tools like Swagger or Postman

I am a highly skilled Servicenow Consultant with 5+ years of experience in implementing and customizing Servicenow solutions.

• 5+ years of experience in Servicenow implementation and customization

• Strong knowledge of IT service management processes

• Certified Servicenow Administrator and Developer

• Experience in integrating Servicenow with other systems such as Jira and Salesforce

Implemented ServiceNow ITSM solution for a Fortune 500 company resulting in 30% increase in efficiency.

• Led a team in successfully implementing ServiceNow ITSM solution for a Fortune 500 company

• Achieved a 30% increase in efficiency through the implementation

• Received recognition from senior management for the successful project completion

One of the difficulties I faced in my current project was inadequate communication among team members.

• Lack of clear communication led to misunderstandings and delays in project delivery

• Team members were not aligned on project goals and priorities

• Difficulty in coordinating tasks and dependencies due to poor communication

• Challenges in resolving issues and making decisions without effective communication

Seeking new challenges and growth opportunities.

• Looking for a new challenge to further develop my skills and knowledge.

• Interested in exploring new technologies and methodologies that my current company does not offer.

• Seeking a company culture that aligns better with my values and career goals.

Experienced Servicenow Consultant with 5+ years of implementing and optimizing ITSM solutions for various clients.

• Implemented ITSM solutions for Fortune 500 companies

• Expertise in Service Catalog, Incident Management, and Change Management modules

• Certified in Servicenow Administration and Development

• Strong communication and problem-solving skills

I would use simple and non-technical language to explain the application to the client.

• Start by understanding the client's level of technical knowledge

• Avoid using jargon and technical terms

• Use analogies or real-life examples to explain complex concepts

• Provide hands-on demonstrations or visual aids if possible

• Encourage the client to ask questions and clarify any doubts

The 3 factors to discuss with a client before implementing something in ServiceNow

• Understand the client's specific requirements and goals

• Assess the impact on existing processes and systems

• Discuss the timeline, budget, and resources needed for implementation

I have worked on integrations with various third-party tools such as JIRA, Slack, and Azure DevOps.

• Integrated ServiceNow with JIRA for seamless issue tracking

• Implemented integration between ServiceNow and Slack for real-time notifications

• Established integration between ServiceNow and Azure DevOps for streamlined development processes

Experienced Servicenow Consultant with a background in IT service management and process automation.

• Over 5 years of experience implementing Servicenow solutions for various clients

• Skilled in configuring and customizing Servicenow modules such as Incident, Problem, Change, and Service Catalog

• Strong understanding of ITIL framework and best practices

• Certified Servicenow System Administrator and Implementation Specialist

• Ex

Seeking new challenges and growth opportunities.

• Looking for a new challenge to further develop my skills and knowledge

• Interested in exploring new technologies and methodologies

• Seeking opportunities for career advancement and growth

• Want to work in a more collaborative and innovative environment

I am open to relocation for the right opportunity.

• Open to relocation for the right opportunity

• Flexible with location preferences

• Willing to consider different locations

My LWD is 30th September 2021.

• My last working day is on 30th September 2021.

• I will be transitioning out of my current role by the end of September.

• I have already informed my current employer about my LWD.