Indusa Infotech Services Interview Questions and Answers

Q1. Azure cloud platform tech
Add your answer
Q2. Informatica tech stack ques
Add your answer

Q1. Adf tech stack que
Add your answer
Q2. Scd type 2 implementation
Ans. 
SCD Type 2 implementation involves tracking historical changes in data by creating new records for each change.
• Identify the columns that need to be tracked for changes

• Add effective start and end dates to track the validity of each record

• Insert new records for changes and update end dates for previous records

• Maintain a surrogate key to uniquely identify each version of the record
Answered by AI
Add your answer

Q1. Dw related que ans
Add your answer
Q2. Solution design related que
Add your answer

Q1. Aspiration from my end
Add your answer
Q2. How soon can join
Ans. 
I can join the team within 2 weeks.
• I can start within 2 weeks of receiving the offer.

• I need to give notice to my current employer.

• I may need to relocate, which could affect my start date.
Answered by AI
Add your answer

For example, a ₹10 LPA CTC could mean an in-hand salary of ₹70,000–₹75,000 per month, depending on deductions and benefits.

✨ 𝗣𝗿𝗼 𝗧𝗶𝗽: Always request a detailed salary structure during negotiations—it’s your roadmap to making informed decisions

𝗖𝗧𝗖 𝘃𝘀 𝗜𝗻-𝗛𝗮𝗻𝗱 𝗦𝗮𝗹𝗮𝗿𝘆: 𝗧𝗵𝗲 𝗥𝗲𝗮𝗹𝗶𝘁𝘆 𝗖𝗵𝗲𝗰𝗸 𝗘𝘃𝗲𝗿𝘆 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗡𝗲𝗲𝗱𝘀!

We’ve all been there—excitedly discussing job offers and hearing about the impressive CTC (Cost to Company). But when payday arrives, you wonder

Q1. 2️⃣ 𝗜𝗻-𝗛𝗮𝗻𝗱 𝗦𝗮𝗹𝗮𝗿𝘆: This is the actual amount you take home after deductions like: • Employee’s contribution to PF • Income tax (TDS) • Professional tax
Add your answer
Q2. 𝗖𝗧𝗖 𝘃𝘀 𝗜𝗻-𝗛𝗮𝗻𝗱 𝗦𝗮𝗹𝗮𝗿𝘆: 𝗧𝗵𝗲 𝗥𝗲𝗮𝗹𝗶𝘁𝘆 𝗖𝗵𝗲𝗰𝗸 𝗘𝘃𝗲𝗿𝘆 𝗣𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝗡𝗲𝗲𝗱𝘀! We’ve all been there—excitedly discussing job offers and hearing about the impressi...read more
Add your answer

There are two main sections: foundation and advanced. The foundation section consists of three subsections: quantitative, reasoning, and verbal. If you pass the foundation section but do not clear the advanced section, you will be considered for either the ninja role or the digital role during the interview process. The advanced section includes advanced aptitude questions and two coding questions.

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. 3 to 4 questions based on database
Add your answer
Q3. 2 easy coding questions
Add your answer
Q4. Questions based on technology that I knew
Add your answer
Q5. Situation based questions
Add your answer

Q1. What are the different sizes available for a virtual warehouse in Snowflake, and which sizes are currently being utilized in your current project?
Add your answer
Q2. What are stored procedures in Snowflake, and how did you utilize them?
Add your answer

Q1. How did you verify the data after transferring it from one database to another?
Add your answer
Q2. What are the different types of duplicate checks that can be performed using SQL queries?
Add your answer

Q1. Are you open to relocating to Hyderabad?
Add your answer
Q2. What information do you have about ValueLabs?
Add your answer

It's walkin, so they conducted 1 technical mcqs round.

Q1. Multi threading
Add your answer
Q2. Internal working of hashmap
Ans. 
HashMap in Java is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values based on keys.
• HashMap uses an array of buckets to store key-value pairs.

• Keys are hashed to determine the index in the array where the key-value pair will be stored.

• In case of hash collisions, a linked list or a balanced tree is used to store multiple key-value pairs in the same bucket.

• HashMap allows null keys...read more
Answered by AI
Add your answer
Q3. Spring batch related
Add your answer
Q4. Non repeating characters in a array
Ans. 
Function to find and return all non-repeating characters in an array of strings.
• Iterate through the array and count the occurrences of each character using a HashMap.

• Then iterate through the array again and check if the count of each character is 1, if so add it to the result list.

• Return the list of non-repeating characters.
Answered by AI
Add your answer
Q5. 3rd highest salary
Ans. 
To find the 3rd highest salary in a database, we can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
• Use a SQL query with 'ORDER BY salary DESC' to sort the salaries in descending order.

• Use 'LIMIT 1 OFFSET 2' to skip the first two highest salaries and retrieve the third highest salary.

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 2;
Answered by AI
Add your answer
Q6. Qualifier vs primary
Ans. 
A qualifier in Java is used to specify additional information about a primary, which is the main data type or variable.
• A primary in Java is the main data type or variable, while a qualifier provides additional information about the primary.

• Qualifiers can be used to modify the behavior or characteristics of a primary.

• For example, in Java, 'final' is a qualifier that can be used to make a variable constant.
Answered by AI
Add your answer
Q7. Controller vs restcontroller
Ans. 
The main difference is that @RestController is a specialized version of @Controller that is used for RESTful web services.
• Both @Controller and @RestController are used in Spring MVC to handle HTTP requests, but @RestController is specifically used for RESTful web services.

• @Controller is used to create web pages, while @RestController is used to return data in JSON or XML format.

• @RestController is a convenience annotati...read more
Answered by AI
Add your answer
Q8. Spring boot annotataions
Add your answer
Q9. Oops concepts with examples
Ans. 
OOP concepts include inheritance, encapsulation, polymorphism, and abstraction.
• Inheritance: Allows a class to inherit properties and behavior from another class. Example: class Dog extends Animal.

• Encapsulation: Bundling data and methods that operate on the data into a single unit. Example: private variables with public getter and setter methods.

• Polymorphism: Ability for objects to be treated as instances of their paren...read more
Answered by AI
Add your answer
Q10. Spring batch configuration
Add your answer
Q11. They covered all java, spring and Microservices
Add your answer

Q1. Microservices architecture
Add your answer
Q2. How do Microservices communicate
Ans. 
Microservices communicate with each other through various communication protocols like HTTP, messaging queues, and gRPC.
• Microservices can communicate over HTTP using RESTful APIs.

• Messaging queues like RabbitMQ or Kafka can be used for asynchronous communication between microservices.

• gRPC is a high-performance, open-source RPC framework that can be used for communication between microservices.

• Service discovery mechanism...read more
Answered by AI
Add your answer
Q3. How to access the Microservice end point
Ans. 
Microservice endpoints can be accessed using HTTP requests with the appropriate URL
• Use HTTP methods like GET, POST, PUT, DELETE to interact with the microservice

• Construct the URL with the base URL of the microservice and the specific endpoint path

• Include any necessary headers or parameters in the request for authentication or data filtering
Answered by AI
Add your answer
Q4. Why we use microservices
Ans. 
Microservices allow for modular, scalable, and flexible software development by breaking down applications into smaller, independent services.
• Microservices enable easier maintenance and updates as each service can be developed, deployed, and scaled independently.

• They improve fault isolation, as failures in one service do not necessarily affect the entire application.

• Microservices promote agility and faster time-to-mark...read more
Answered by AI
Add your answer

Q1. What are the different types of interfaces?
Ans. 
Different types of interfaces include user interfaces, hardware interfaces, and software interfaces.
• User interfaces: allow users to interact with the system, such as graphical user interfaces (GUI) and command-line interfaces (CLI)

• Hardware interfaces: connect hardware components to the system, such as USB, HDMI, and Ethernet ports

• Software interfaces: define how software components interact with each other, such as appl...read more
Answered by AI
Add your answer
Q2. What is the output of the program when the expression is evaluated as 0 divided by 7?
Ans. 
The output of the program when 0 is divided by 7 is 0.
• Division of 0 by any number results in 0.

• In programming languages, dividing by 0 usually results in an error or undefined behavior.
Answered by AI
Add your answer
Q3. What are coroutines, scope functions, and visibility modifiers?
Ans. 
Coroutines, scope functions, and visibility modifiers are key concepts in Kotlin programming for Android development.
• Coroutines are a way to perform asynchronous programming in a sequential manner. They allow for non-blocking operations.

• Scope functions are functions that allow you to execute a block of code within the context of an object. Examples include 'let', 'apply', 'run', 'also', and 'with'.

• Visibility modifiers ...read more
Answered by AI
Add your answer

Q1. What is the MVVM (Model-View-ViewModel) architectural pattern?
Ans. 
MVVM is an architectural pattern that separates the user interface from the business logic and data handling in Android development.
• Model represents the data and business logic of the application.

• View is responsible for displaying the UI elements and sending user interactions to the ViewModel.

• ViewModel acts as a mediator between the Model and the View, handling the communication and data flow.

• MVVM helps in achieving se...read more
Answered by AI
Add your answer
Q2. What are the reasons for using that, and what are its pros and cons?
Ans. 
Using dependency injection in Android development can improve code maintainability and testability.
• Pros: easier to manage dependencies, promotes code reusability, facilitates unit testing

• Cons: initial setup can be complex, may introduce overhead in smaller projects

• Example: Using Dagger 2 for dependency injection in an Android project
Answered by AI
Add your answer
Q3. Questions related Dependency injection dagger-hilt / koin
Add your answer

Q1. What are the reasons for using the Border Gateway Protocol (BGP)?
Ans. 
BGP is used for routing and exchanging routing information between different autonomous systems.
• BGP allows for dynamic routing between different autonomous systems

• It provides redundancy and load balancing by choosing the best path for data traffic

• BGP helps in preventing network loops and ensuring efficient data routing

• It is commonly used by Internet Service Providers (ISPs) to exchange routing information

• BGP is essenti...read more
Answered by AI
Add your answer
Q2. What is a switch stack?
Ans. 
A switch stack is a group of network switches that are interconnected and operate as a single unit.
• Switch stack simplifies network management by allowing multiple switches to be managed as one entity.

• It provides high availability and redundancy by allowing one switch to take over if another fails.

• Switch stack can also increase network performance by load balancing traffic across multiple switches.

• Examples of switch sta...read more
Answered by AI
Add your answer
Q3. What are the configurations required in wireless networking?
Ans. 
Configurations required in wireless networking include SSID, security settings, encryption type, and channel selection.
• Set up a unique SSID to identify the network

• Choose appropriate security settings such as WPA2-PSK

• Select encryption type like AES for secure data transmission

• Optimize channel selection to avoid interference
Answered by AI
Add your answer
Q4. What are the different types of VPNs?
Ans. 
Different types of VPNs include remote access VPN, site-to-site VPN, and client-to-site VPN.
• Remote access VPN allows individual users to connect to a private network remotely.

• Site-to-site VPN connects multiple networks together over the internet.

• Client-to-site VPN allows individual devices to connect to a private network remotely.

• Other types include MPLS VPN, SSL VPN, and IPsec VPN.
Answered by AI
Add your answer
Q5. What is the purpose of native VLAN?
Ans. 
The purpose of native VLAN is to carry untagged traffic across a trunk link.
• Native VLAN is used for untagged traffic on a trunk link

• It allows devices that do not support VLAN tagging to communicate over the trunk link

• Native VLAN should be the same on both ends of the trunk link to avoid VLAN hopping attacks
Answered by AI
Add your answer

10 min, simple question on programming skills

Q1. Which Microservice communication pattern you have used?
Ans. 
I have used the asynchronous messaging pattern for Microservice communication.
• Implemented messaging queues like RabbitMQ or Kafka for decoupled communication

• Used message brokers to enable communication between Microservices

• Leveraged event-driven architecture for real-time updates and scalability
Answered by AI
Add your answer
Q2. Which Application Insight tool you have used?
Ans. 
I have used Application Insights for monitoring and analyzing the performance of .NET applications.
• Used Application Insights to track application performance metrics

• Analyzed telemetry data to identify performance bottlenecks

• Set up alerts and notifications for critical issues

• Integrated Application Insights with Azure DevOps for continuous monitoring
Answered by AI
Add your answer
Q3. Caching Technique is used in your project
Ans. 
We use in-memory caching technique in our project to improve performance and reduce database load.
• In-memory caching is used to store frequently accessed data in memory for quick retrieval

• Helps reduce database load and improve application performance

• Examples: using MemoryCache in .NET, Redis caching, caching frequently accessed data like user profiles or product information
Answered by AI
Add your answer
Q4. Api Gateways is used in MicrosServices
Ans. 
Yes, API Gateways are used in Microservices to manage and secure communication between services.
• API Gateways act as a single entry point for clients to access multiple microservices

• They handle authentication, authorization, rate limiting, logging, and monitoring

• Examples of API Gateways include Kong, Apigee, and AWS API Gateway
Answered by AI
Add your answer
Q5. Which single sign on technology/Mechanism is used in project
Ans. 
We are using OAuth 2.0 for single sign on in the project.
• OAuth 2.0 is a widely used authorization framework that enables a third-party application to obtain limited access to an HTTP service.

• It allows users to log in once and access multiple applications without having to log in again.

• OAuth 2.0 provides secure delegated access to resources without sharing user credentials.
Answered by AI
Add your answer
Q6. What is JWT token,why we use it
Ans. 
JWT token is a JSON Web Token used for secure transmission of information between parties.
• JWT token is a compact and self-contained way to transmit information between parties.

• It is digitally signed to verify its authenticity and integrity.

• JWT tokens consist of three parts: header, payload, and signature.

• They are commonly used for authentication and information exchange in web applications.

• Example: JWT tokens are often
Answered by AI
Add your answer
Q7. How to implement exception handling and filters in .net core web api
Ans. 
Exception handling and filters in .NET Core Web API
• Use try-catch blocks to handle exceptions in the code

• Implement global exception handling middleware to catch unhandled exceptions

• Use filters like [Authorize] for authentication and [ValidateAntiForgeryToken] for CSRF protection

• Create custom exception filters by implementing IExceptionFilter interface
Answered by AI
Add your answer

Online MCQ test of dbms c java oops and aptitude

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in business administration and a passion for marketing.
• Recent graduate with a degree in business administration

• Passionate about marketing

• Strong communication and organizational skills
Answered by AI
Add your answer

Q1. Introduce yourself
Ans. 
I am a recent graduate with a degree in business administration and a passion for marketing and sales.
• Recent graduate with a degree in business administration

• Passionate about marketing and sales

• Strong communication and interpersonal skills

• Experience in customer service and retail sales
Answered by AI
Add your answer
Q2. Tell me about your project which you have done in final year
Ans. 
Developed a mobile application for tracking daily water intake and hydration levels
• Researched the importance of hydration for overall health

• Designed user-friendly interface for inputting water intake

• Implemented reminders and notifications to encourage regular hydration

• Conducted user testing to gather feedback for improvements
Answered by AI
Add your answer
Q3. What is inheritance explain its type
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Inheritance allows for code reusability and promotes the concept of hierarchy in programming.

• There are different types of inheritance such as single inheritance, multiple inheritance, multilevel inheritance, and hierarchical inheritance.

• Example: A 'Car' class can inherit attributes and methods fro...read more
Answered by AI
Add your answer
Q4. SQL query related questions
Add your answer