Nityo Infotech Interview Questions and Answers

Q1. Major Questions about technical and Approach to the problem, skills SQL, Snowflake, AWS
Add your answer
Q2. Data modeling is another area, they watch for
Add your answer

Q1. Why do you want to change the company
Add your answer

Q1. Can we sort hashmap? How to secure webservices?
Ans. 
Yes, we can sort a hashmap using TreeMap. To secure webservices, we can use SSL/TLS encryption and implement authentication and authorization mechanisms.
• To sort a hashmap, we can create a TreeMap and pass the hashmap to its constructor. The keys will be automatically sorted.

• To secure webservices, we can use SSL/TLS encryption to encrypt the data in transit. We can also implement authentication and authorization mechani...read more
Answered by AI
Add your answer
Q2. Write a program to sort an array using insertion sort algorithm?
Ans. 
Program to sort an array using insertion sort algorithm
• Iterate through the array from index 1 to n-1

• Compare each element with the previous elements and swap if necessary

• Repeat until the array is sorted
Answered by AI
Add your answer
Q3. Main focus was on Data Structure and Algorithms(coding)
Add your answer

Q1. Questions on core java and frameworks
Add your answer

Programs mostly on Java 8, 11

Q1. Talking about salary only
Add your answer

Q1. Tell me something about yourself?
Ans. I am a IT Professional for 14 years and earned certification like Project Management Professional, Agile Scrum Master, Certified Information System Security Professional and Google Cloud Certified. I have learned the importance continuous development to competitive in this industry.
Answered Anonymously
Add your answer

Q1. Walk me Through to your experience.
Add your answer

Q1. Oops concepts of JS
Ans. 
Oops concepts in JS include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance allows objects to inherit properties and methods from a parent object.

• Encapsulation is the practice of keeping properties and methods private to prevent external access.

• Polymorphism allows objects to take on multiple forms and behave differently based on context.

• Abstraction involves hiding complex implementation details an...read more
Answered by AI
Add your answer
Q2. Angular life cycle hooks
Add your answer

Q1. How to debug packages in SSIS
Ans. 
Debugging packages in SSIS involves using breakpoints, data viewers, logging, and error outputs.
• Set breakpoints in control flow tasks to pause package execution for inspection.

• Use data viewers to see data at various points in the package.

• Enable logging to capture detailed information about package execution.

• Redirect error outputs to handle and troubleshoot errors effectively.
Answered by AI
Add your answer
Q2. SCD Implementation in SSIS
Ans. 
SCD implementation in SSIS involves using Slowly Changing Dimension transformations to handle changing data in data warehouse.
• Use Slowly Changing Dimension (SCD) transformations in SSIS to handle changing data in data warehouse

• Identify Type 1, Type 2, or Type 3 changes and implement appropriate SCD logic

• Utilize Lookup and Conditional Split components to compare incoming data with existing data and determine the type of...read more
Answered by AI
Add your answer
Q3. Different type of transformation and explanation
Ans. 
Different types of transformations in data engineering
• Extract: Selecting specific columns from a dataset

• Filter: Removing rows that do not meet certain criteria

• Join: Combining two or more datasets based on a common key

• Aggregate: Grouping data and performing calculations on groups

• Normalize: Restructuring data into a standardized format
Answered by AI
Add your answer
Q4. Diff among container in SSIS
Ans. 
Containers in SSIS are used to group related tasks and provide a way to manage the flow of data and control the execution of tasks.
• Containers help in organizing and managing tasks in SSIS packages.

• There are different types of containers in SSIS such as Sequence Container, For Loop Container, Foreach Loop Container, and Task Host Container.

• Sequence Container is used to group tasks and define the order of execution.

• For L...read more
Answered by AI
Add your answer