Nihilent Interview Questions, Process, and Tips

Q1. More of Architecture blocks and integration related
Add your answer

Q1. Approach to design architecture and optimization
Ans. 
I approach architecture design by focusing on scalability, performance, security, and maintainability.
• Start by understanding the requirements and constraints of the project

• Identify key components and their interactions

• Consider scalability by designing for future growth

• Optimize performance through efficient algorithms and technologies

• Implement security measures to protect data and systems

• Prioritize maintainability for e
Answered by AI
Add your answer

Q1. Family background and future vision for next 3-5 years to understand what mindset the candidate is coming up with.
Add your answer

Q1. Explain about normalize component
Ans. 
Normalize component is used in Abinitio to standardize and transform data into a consistent format.
• Normalize component is used to remove redundancy and inconsistencies in data.

• It helps in transforming data into a consistent format by applying rules and transformations.

• Normalization can involve splitting data into multiple tables, removing duplicate records, or standardizing values.

• Example: Normalizing a customer databa...read more
Answered by AI
Add your answer
Q2. Explain fact and dimension
Ans. 
Fact and dimension are two types of data in a data warehouse.
• Fact: Represents the measurable and numerical data in a data warehouse.

• Dimension: Represents the descriptive attributes of the data in a data warehouse.

• Fact tables contain foreign keys to dimension tables.

• Example: In a sales data warehouse, the fact table may contain sales amount, quantity sold, and date, while the dimension table may contain product, custome
Answered by AI
Add your answer
Q3. Introduction of the project
Add your answer

It was aptitude round

Q1. What are OOPS in java?
Ans. 
OOPS in Java stands for Object-Oriented Programming concepts which include inheritance, encapsulation, polymorphism, and abstraction.
• OOPS stands for Object-Oriented Programming concepts

• Includes inheritance, encapsulation, polymorphism, and abstraction

• Encourages modular and reusable code

• Allows for easier maintenance and updates

• Example: Creating classes and objects in Java
Answered by AI
Add your answer
Q2. Explain exception handling in java
Ans. 
Exception handling in Java is a mechanism to handle runtime errors and prevent program crashes.
• Use try-catch blocks to handle exceptions

• Use finally block to execute code regardless of exception

• Use throw keyword to manually throw exceptions

• Use throws keyword in method signature to declare exceptions that can be thrown
Answered by AI
Add your answer

Normal aptitude questions.

Q1. Technical questions related to basics of languages and OOPS concepts.
Add your answer

Q1. Normal HR questions nothing specific.
Add your answer

Q1. Testing process
Add your answer
Q2. Other stuff abt testing
Add your answer

Q1. Salary discussion and collection of previous employer details
Add your answer

Union and union all difference

Q1. Union and union all difference
Ans. 
Union combines and removes duplicates, Union All combines all rows including duplicates.
• Union removes duplicates, Union All includes duplicates

• Union is slower than Union All as it has to remove duplicates

• Union requires the same number of columns in both queries

• Union All does not require the same number of columns in both queries
Answered by AI
Add your answer