Harbinger Group Interview Questions and Answers for Experienced

Q1. What is Data Profiling
Ans. 
Data profiling is the process of analyzing and summarizing data to gain insights into its quality, structure, and content.
• Data profiling involves examining data to understand its characteristics, such as data types, patterns, and relationships.

• It helps in identifying data quality issues, such as missing values, outliers, and inconsistencies.

• Data profiling can also reveal data distribution, frequency of values, and data...read more
Answered by AI
Add your answer
Q2. What is data modeling and it's importance
Ans. 
Data modeling is the process of creating a visual representation of data structures and relationships to help understand and analyze data.
• Data modeling helps in organizing and structuring data in a way that is easy to understand and analyze.

• It helps in identifying relationships between different data elements.

• Data modeling is important for designing databases, developing data warehouses, and improving data quality.

• Exam...read more
Answered by AI
Add your answer

Q1. Scaffold erection safety procedures
Ans. 
Scaffold erection safety procedures involve proper training, inspection, and adherence to regulations.
• Ensure all workers are properly trained on scaffold erection and safety procedures

• Inspect scaffolds before each use to ensure they are in good condition

• Adhere to OSHA regulations and guidelines for scaffold erection and use

• Use fall protection equipment when working on scaffolds at heights

• Provide proper supervision and ...read more
Answered by AI
Add your answer
Q2. What is BOCW of Tamilnadu
Ans. 
BOCW stands for Building and Other Construction Workers in Tamilnadu, referring to the regulations and welfare measures for construction workers in the state.
• BOCW Act provides for the welfare of construction workers in Tamilnadu

• It includes provisions for health, safety, and working conditions of construction workers

• Registration of construction workers under BOCW Act is mandatory

• Financial assistance, insurance, and othe
Answered by AI
Add your answer
Q3. Work at height norms and safe accessibility describe
Ans. 
Work at height norms and safe accessibility are regulations and practices put in place to ensure the safety of workers who perform tasks at elevated levels.
• Work at height norms refer to regulations and guidelines that dictate how work at height should be carried out safely.

• Safe accessibility involves ensuring that workers have proper access to elevated work areas, such as using ladders, scaffolding, or aerial lifts.

• Saf...read more
Answered by AI
Add your answer
Q4. Scaffolding tagging system describe
Ans. 
Scaffolding tagging system is a visual communication tool used to indicate the status of scaffolding structures.
• Tags are color-coded to represent different statuses such as 'in use', 'do not use', 'under inspection', etc.

• Tags are typically attached at eye level on scaffolding components for easy visibility.

• Tags should be securely attached to prevent accidental removal or tampering.

• Regular inspections should be conducte
Answered by AI
Add your answer
Q5. What is the Welding machine highest temperature?
Ans. 
The highest temperature of a welding machine can vary depending on the type and model, but it typically ranges from 5,000 to 30,000 degrees Fahrenheit.
• The highest temperature of a welding machine is determined by the type of welding process being used, such as MIG, TIG, or stick welding.

• Different types of welding machines have different maximum temperature capabilities, with some reaching up to 30,000 degrees Fahrenhei...read more
Answered by AI
Add your answer
Q6. Describe near miss report
Ans. 
A near miss report is a documented report of an incident that could have resulted in harm or damage but did not.
• Near miss reports should include details of the incident, potential consequences, and actions taken to prevent future occurrences.

• Examples of near miss incidents include a worker almost falling from a height due to a faulty ladder, a machine malfunction that could have caused an injury, or a chemical spill na...read more
Answered by AI
Add your answer
Q7. External and internal audit progress details discussions
Add your answer

Q1. What is five point PPE'S and what is the usages?
Ans. 
Five point PPE's refer to Personal Protective Equipment consisting of head protection, eye protection, hearing protection, respiratory protection, and hand protection.
• Head protection includes helmets or hard hats to protect against head injuries.

• Eye protection involves safety glasses or goggles to prevent eye injuries.

• Hearing protection includes earplugs or earmuffs to protect against noise-induced hearing loss.

• Respira...read more
Answered by AI
Add your answer
Q2. How many earthing should providing on DB box?
Ans. 
At least two earthing should be provided on a DB box for safety purposes.
• At least two earthing points should be provided on a DB box to ensure proper grounding and safety.

• The earthing points should be securely connected to the earth to prevent electrical hazards.

• Proper earthing helps in dissipating excess electrical energy and prevents electric shocks.

• Examples of earthing methods include using copper rods or strips bur...read more
Answered by AI
Add your answer
Q3. What is permit,types of permits and its norms?
Ans. 
Permits are official documents that allow individuals or companies to perform certain activities or operations. There are various types of permits with specific norms and regulations.
• Permits are required for activities such as construction, demolition, events, and hazardous material handling.

• Types of permits include building permits, environmental permits, event permits, and occupational permits.

• Norms for permits typic...read more
Answered by AI
Add your answer
Q4. IS 3969 part 1 and part 2 define
Ans. 
IS 3969 part 1 and part 2 are Indian Standards that define safety requirements for industrial trucks.
• IS 3969 part 1 covers safety requirements for electrically operated industrial trucks.

• IS 3969 part 2 covers safety requirements for internal combustion engine operated industrial trucks.

• These standards specify safety requirements for design, construction, operation, and maintenance of industrial trucks.

• Compliance with I...read more
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Q1. Ques -> Can you define difference b/w Azure data lake and Delta lake.
Ans. 
Azure Data Lake is a cloud-based storage and analytics service, while Delta Lake is an open-source storage layer that adds reliability to data lakes.
• Azure Data Lake is a service provided by Microsoft Azure for storing and analyzing large amounts of data.

• Delta Lake is an open-source storage layer that adds ACID transactions and schema enforcement to data lakes.

• Azure Data Lake is a cloud-based solution, while Delta Lake ...read more
Answered by AI
Add your answer
Q2. How to implemented Primary key and foreign key in delta tables.
Ans. 
Primary keys and foreign keys can be implemented in delta tables using constraints and references.
• Primary keys can be implemented using the PRIMARY KEY constraint, which ensures that each record in the table has a unique identifier.

• Foreign keys can be implemented using the FOREIGN KEY constraint, which establishes a link between two tables based on a common column.

• The referenced table must have a primary key defined, a...read more
Answered by AI
Add your answer
Q3. How to handle exception in python?
Ans. 
Exception handling in Python allows for the graceful handling of errors and prevents program crashes.
• Use try-except blocks to catch and handle exceptions.

• Multiple except blocks can be used to handle different types of exceptions.

• The finally block is executed regardless of whether an exception occurred or not.

• Exceptions can be raised using the 'raise' keyword.

• Custom exceptions can be defined by creating a new class that
Answered by AI
Add your answer
Q4. What is star schema and snowflake schema
Ans. 
Star schema is a data modeling technique where a central fact table is connected to multiple dimension tables. Snowflake schema is an extension of star schema with normalized dimension tables.
• Star schema is a simple and denormalized structure

• It consists of a central fact table connected to multiple dimension tables

• Dimension tables contain descriptive attributes

• Star schema is easy to understand and query, but can lead t...read more
Answered by AI
Add your answer
Q5. Which are the most frequently change
Ans. 
The most frequently changing data
• Customer preferences

• Market trends

• Weather data

• Stock prices

• Social media trends
Answered by AI
Add your answer

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer

De/algo leetcode medium level

Q1. There was no technical questions all very basic not for senior data engineer role questions only 3 questions( what is DB, Data Mart, Data warehouse)and he said i am done ... The. worst interview in my expe...read more
Add your answer

Q1. Name Place Occupation Experiences Basic introduction
Ans. 
My name is Sarah, I am from New York and I work as an HR Recruiter. I have 5 years of experience in recruitment.
• Name: Sarah

• Place: New York

• Occupation: HR Recruiter

• Experiences: 5 years in recruitment
Answered by AI
Add your answer
Q2. Past experience Basic introduction
Add your answer
Q3. Basic introduction Name Place Occupation
Add your answer
Q4. Name Place Occupational atuff
Ans. 
My name is John Smith, I am from New York City, and I have experience in recruiting for various industries.
• Name: John Smith

• Place: New York City

• Occupational stuff: Recruiting for various industries

• Example: Recruited for tech companies, healthcare organizations, and financial institutions
Answered by AI
Add your answer
Q5. Name Place Experiences Occupation
Ans. 
My name is Sarah, I am from New York City. I have 5 years of experience in HR recruitment. Currently, I work as an HR Recruiter at XYZ Company.
• Name: Sarah

• Place: New York City

• Experiences: 5 years in HR recruitment

• Occupation: HR Recruiter at XYZ Company
Answered by AI
Add your answer