HCLTech Interview Questions and Answers

The first transatlantic radio broadcast occurred in the 1900s.

• The first transatlantic radio broadcast took place in the early 1900s.

• It was achieved by Guglielmo Marconi in 1901.

• Marconi successfully transmitted a radio signal from Cornwall, England to Newfoundland, Canada.

• This breakthrough in communication technology paved the way for future advancements in global communication.

BMS system stands for Building Management System, which is a computer-based control system that manages and monitors a building's mechanical and electrical equipment.

• Controls and monitors HVAC systems, lighting, security, fire alarms, and other building systems

• Helps optimize energy usage and improve building efficiency

• Provides real-time data and analytics for better decision-making

• Can be integrated with other systems like access control and energy management

• Examples: Siemens ...read more

Yes, I am an expert in MS Excel and can clean and present datasets effectively.

• Proficient in using Excel functions and formulas for data cleaning and analysis

• Experienced in creating pivot tables, charts, and graphs to present data visually

• Skilled in data validation and conditional formatting to ensure accuracy and consistency

• Familiar with advanced Excel features like VLOOKUP, INDEX-MATCH, and macros

• Can handle large datasets efficiently and organize them for easy interpretatio...read more

DGS capacity refers to the maximum amount of data that can be processed by a Direct-Attached Storage system.

• DGS capacity is determined by the storage capacity of the disks in the system.

• Factors such as RAID configuration and disk speed can also impact DGS capacity.

• For example, a DGS system with 4TB disks in a RAID 5 configuration will have a different capacity than one with 2TB disks in a RAID 10 configuration.

Choke in tube light is used to regulate the current flow and provide a stable voltage to the tube.

• Choke is an inductor that limits the current flow in the circuit.

• It helps to provide a stable voltage to the tube.

• It also helps to prevent flickering of the tube light.

• Choke is placed in series with the tube light.

• It is also known as ballast in some countries.

I have created various interactive dashboards using Tableau and Power BI to visualize sales performance, customer trends, and operational KPIs.

• Utilized Tableau and Power BI to create interactive dashboards

• Visualized sales performance, customer trends, and operational KPIs

• Implemented filters, drill-down capabilities, and dynamic visuals

• Designed user-friendly interfaces for easy data interpretation