10+ Tata Projects Interview Questions and Answers

Utkarsh Small Finance Bank is a small finance bank in India.

• It was founded in 2016 and is headquartered in Varanasi, India.

• It offers a range of banking products and services including savings accounts, current accounts, fixed deposits, and loans.

• The bank has a network of over 500 branches and banking outlets across India.

• It focuses on providing financial services to the unbanked and underbanked segments of society, particularly in rural and semi-urban areas.

• Utkarsh Small Fina...read more

Pivot table is a data summarization tool used in spreadsheets to analyze and summarize large amounts of data.

• Pivot table allows users to quickly summarize and analyze large amounts of data

• Users can easily group data by different categories and analyze trends

• Pivot table can perform calculations such as sum, average, count, etc. on the grouped data

• Pivot table is a powerful tool for data analysis and reporting

• Example: A sales team can use pivot table to analyze sales data by reg...read more

Employee engagement is the emotional commitment an employee has to their organization and its goals.

• It involves creating a positive work environment

• Encouraging open communication and feedback

• Providing opportunities for growth and development

• Recognizing and rewarding employees for their contributions

• Examples include team building activities, employee surveys, and career development programs

Labour Law in Banking terms refers to the regulations and laws that govern the relationship between banks and their employees.

• Labour laws ensure that banks provide a safe and healthy work environment for their employees

• They also regulate working hours, wages, and benefits for bank employees

• Labour laws also protect the rights of bank employees, such as the right to form unions and engage in collective bargaining

• Examples of labour laws in banking include the Fair Labor Standard...read more

Minimum employee strength for ESIC registration is 10.

• ESIC registration is mandatory for establishments with 10 or more employees.

• Employees earning less than Rs. 21,000 per month are eligible for ESIC benefits.

• ESIC provides medical, disability, maternity, and other benefits to employees.

• Employers are required to contribute 4.75% of the employee's salary towards ESIC.

• ESIC registration can be done online through the ESIC portal.

A pivot table is a data summarization tool used in Excel to condense and analyze large amounts of data.

• Pivot tables allow users to quickly and easily summarize and analyze large amounts of data

• They can be used to group data by categories, such as dates, products, or regions

• Users can also apply filters to pivot tables to focus on specific subsets of data

• Pivot tables can be customized with different calculations and formatting options

• They are a powerful tool for data analysis a...read more

NBFC stands for Non-Banking Financial Company.

• NBFCs are financial institutions that offer banking services without holding a banking license.

• They provide loans, credit facilities, and other financial services to individuals and businesses.

• NBFCs are regulated by the Reserve Bank of India (RBI) and are required to maintain a minimum amount of capital.

• Examples of NBFCs in India include Bajaj Finance, Mahindra & Mahindra Financial Services, and L&T Finance Holdings.

Gratuity is calculated based on an employee's last drawn salary and years of service.

• Gratuity is a lump sum payment made to an employee at the end of their employment.

• It is calculated as 15 days of salary for each completed year of service.

• The salary used for calculation is the last drawn salary, including basic salary and dearness allowance.

• Gratuity is applicable to all employees who have completed 5 years of continuous service.

• In case of death or disablement, gratuity is pa...read more

MIS report can be prepared by collecting relevant data, organizing it in a structured format and presenting it in a clear and concise manner.

• Identify the purpose and scope of the report

• Gather relevant data from various sources

• Organize the data in a structured format such as tables, charts or graphs

• Ensure accuracy and completeness of data

• Present the data in a clear and concise manner

• Include analysis and insights to aid decision-making

• Regularly update and review the report to e...read more