Deloitte Software QA Engineer Interview Questions and Answers

Depreciation formula calculates the decrease in value of an asset over time.

• Depreciation formula is used to calculate the decrease in value of an asset over time due to wear and tear, obsolescence, or other factors.

• The formula for straight-line depreciation is (cost of asset - salvage value) / useful life of asset.

• Other methods of depreciation include double-declining balance, sum-of-the-years' digits, and units-of-pro...read more

Digitising NBFC loan disbursement involves implementing a digital platform for loan application, approval, and disbursement.

• Develop a user-friendly digital platform for loan application and approval

• Integrate the platform with credit bureaus for credit checks and risk assessment

• Implement e-signature and e-KYC for paperless verification

• Use APIs to connect with banks for fund transfer

• Ensure data security and compliance wi...read more

Query to generate state-wise sales summary report with ranking using multiple table joins.

• Use SQL JOINs to combine sales, states, and products tables.

• Aggregate sales data using SUM() function grouped by state.

• Use RANK() or DENSE_RANK() to rank states based on total sales.

• Example SQL: SELECT state, SUM(sales) AS total_sales, RANK() OVER (ORDER BY SUM(sales) DESC) AS sales_rank FROM sales_data JOIN states ON sales_data.s...read more