Avohi Infotech Interview Questions and Answers

Attended the TCS NQT, depending on how many advanced questions and the test cases you pass in coding section, you'll get assigned Ninja (3L) Digital (7L) or prime (9L)

Q1. Code to get prime nos
Add your answer
Q2. What do you know about cloud computing
Add your answer
Q3. Self introduction
Add your answer
Q4. Difference between cloud computing and computer networking
Add your answer
Q5. If you know any os like linux
Add your answer
Q6. Oops based questions, very basic if you're not from it or cse related fields but they might ask advanced questions if you're related to cs/it fields
Add your answer
Q7. If you're okay Relocation
Add your answer
Q8. Questions about your projects
Add your answer

Q1. Tell me about yourself.
Add your answer
Q2. What makes you the ideal candidate for this position?
Add your answer

Q1. They will Voice test
Add your answer

Q1. Tell me about your self, what are languages you know, what do you know about phone pe
Add your answer

Q1. They will check our typing test
Add your answer

A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8

The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.

Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
Add your answer
Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
Ans. 
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
• Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.

• Subclasses of a sealed class must be either final or sealed themselves.

• Errors may occur when trying to extend a sealed class with a non-permitted subclass.
Answered by AI
Add your answer
Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
Add your answer
Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
Ans. 
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
• Create a database table to store user notifications for out-of-stock items

• Implement a service to check item availability and send notifications to subscribed users

• Provide a user interface for users to subscribe to notifications for specific items
Answered by AI
Add your answer
Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
Add your answer
Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Add your answer

Q1. What are the steps to add a shared mailbox in the Outlook client? Why might it be difficult to uninstall an application at times?
Add your answer
Q2. What steps should be taken when a URL link becomes unexpectedly inaccessible?
Add your answer
Q3. Open The outlook go to file and Click account setting and select Account setting Click email account select your account and click change Click advanced settings and click more settings. ,goto the advanc...read more
Add your answer
Q4. Check your internet connection Try different division or browser Check cmd and Ping the URL Check for DNS issue Try accessing a different URL
Add your answer

They gave a case study where the candidate had to showcase the audience segmentation, create a brochure design with content and showcase the writing skills based on a product that they gave.

Q1. How would you plan a brochure layout?
Add your answer
Q2. How would you coordinate with stakeholders for information collection?
Add your answer

Q1. What is the Entity-Relationship (ER) model?
Ans. 
The Entity-Relationship (ER) model is a data model used to describe the relationships between entities in a database.
• Entities are objects or concepts in the real world that can be distinguished from each other.

• Relationships describe how entities are related to each other.

• Attributes are properties that describe entities and relationships.

• ER diagrams visually represent the ER model, showing entities, relationships, and a...read more
Answered by AI
View 1 more answer
Q2. What are the advantages of using threads compared to processes?
Ans. 
Threads are lighter weight than processes, share memory space, and are more efficient for multitasking.
• Threads share the same memory space, making communication between them faster and more efficient.

• Threads are lighter weight than processes, as they share resources such as memory and file descriptors.

• Threads are more efficient for multitasking, as they can run concurrently within the same process.

• Threads are easier to...read more
Answered by AI
Add your answer

Google primarily focuses on pure data structures and algorithms-based questions during coding interviews. Other computer science core topics are typically not covered in Google's interviews. Therefore, it is essential to be proficient in data structures and algorithms to succeed in the Google coding interview.

An aptitude test is a tool used to evaluate a person's skills, abilities, and potential for success in a specific role or activity.

Group discussion is a process of exchanging ideas and opinions among individuals on a specific topic. It is a structured form of communication in which participants have the opportunity to express their views while also listening to others' perspectives on the same subject.

Q1. What are your strengths and weaknesses?
Ans. 
My strengths include problem-solving skills and attention to detail. My weaknesses include time management and public speaking.
• Strengths: problem-solving skills

• Strengths: attention to detail

• Weaknesses: time management

• Weaknesses: public speaking
Answered by AI
Add your answer
Q2. What reasons can you provide for why we should consider hiring you?
Ans. 
I have a strong foundation in web development, a passion for learning, and a proven track record of delivering high-quality projects.
• I have a solid understanding of HTML, CSS, and JavaScript

• I am proficient in using various web development tools and frameworks such as React and Node.js

• I have successfully completed several web development projects, including a responsive e-commerce website for a local business
Answered by AI
Add your answer

An assignment is a task or piece of work that you are given to complete, particularly as part of your job or studies. The assignment for the course includes written assignments and practical tests, similar to tasks, work, jobs, or charges.

A case study is a detailed description and assessment of a specific situation in the real world, created for the purpose of deriving generalized insights and understanding. It can focus on an individual, a group of people, an organization, or an event, among other subjects.

Q1. What do you consider your greatest accomplishment?
Ans. 
My greatest accomplishment was successfully leading a team to launch a new website for a major client ahead of schedule.
• Successfully led a team to launch a new website

• Completed the project ahead of schedule

• Received positive feedback from the client
Answered by AI
Add your answer
Q2. What factors motivate you in your professional life?
Ans. 
I am motivated by challenges, learning opportunities, and the ability to make a positive impact.
• Challenges push me to grow and improve my skills.

• Learning opportunities allow me to stay updated with the latest technologies and trends.

• Making a positive impact through my work gives me a sense of fulfillment and purpose.
Answered by AI
Add your answer

Q1. What does your ideal work environment look like?
Ans. 
My ideal work environment is a collaborative space with supportive colleagues, opportunities for growth, and a healthy work-life balance.
• Collaborative team environment where ideas are shared and valued

• Supportive colleagues who are willing to help and provide feedback

• Opportunities for growth and learning new technologies

• Healthy work-life balance with flexible hours and remote work options
Answered by AI
Add your answer
Q2. How would you impact employee retention?
Ans. 
By creating a positive work environment, offering growth opportunities, and implementing employee recognition programs.
• Creating a positive work environment through open communication and support

• Offering growth opportunities such as training programs and career advancement

• Implementing employee recognition programs to acknowledge and reward hard work

• Providing competitive salaries and benefits to attract and retain top ta
Answered by AI
Add your answer

Q1. What are real-time operating systems?
Ans. 
Real-time operating systems are designed to provide predictable response times and prioritize tasks based on timing constraints.
• Real-time operating systems prioritize tasks based on timing constraints

• They are designed to provide predictable response times

• Examples include VxWorks, QNX, and FreeRTOS
Answered by AI
Add your answer
Q2. Are the applicants first asked several questions regarding data structures and algorithms?
Add your answer

Q1. What topics are typically discussed during the final round of interviews, particularly regarding salary expectations, working hours, and other job requirements?
Add your answer
Q2. Are you comfortable working night shifts, considering that many roles at Genpact support international clients?
Ans. 
Yes, I am comfortable working night shifts to support international clients.
• I have previous experience working night shifts in a customer service role.

• I am a night owl and tend to be more productive during late hours.

• I understand the importance of supporting international clients and am willing to adjust my schedule accordingly.
Answered by AI
Add your answer

Q1. A process associate is crucial in ensuring the smooth operation of various business processes across different industries
Add your answer
Q2. What are the operational tasks necessary to maintain efficiency and quality?
Ans. 
Operational tasks for maintaining efficiency and quality include regular testing, monitoring performance, updating software, and implementing best practices.
• Regularly test website functionality to ensure it is working properly

• Monitor website performance metrics such as load times and user experience

• Update software and plugins to the latest versions to prevent security vulnerabilities

• Implement best practices for coding,
Answered by AI
Add your answer

Q1. How can you prepare examples demonstrating your leadership, conflict resolution, and prioritization skills to excel in a managerial round interview?
Ans. 
Prepare examples showcasing leadership, conflict resolution, and prioritization skills for a managerial round interview.
• Leadership: Discuss a project where you led a team to success, highlighting your ability to motivate and guide others.

• Conflict Resolution: Share a situation where you successfully resolved a conflict within a team or project, emphasizing your communication and problem-solving skills.

• Prioritization: Ta...read more
Answered by AI
Add your answer
Q2. How do you demonstrate adaptability, leadership, and a commitment to fostering a positive work environment?
Ans. 
I demonstrate adaptability, leadership, and commitment by actively seeking feedback, taking on new challenges, and fostering collaboration within the team.
• Seek feedback from colleagues and supervisors to continuously improve

• Volunteer for new projects or tasks to expand skills and knowledge

• Encourage open communication and teamwork among team members

• Lead by example by showing a positive attitude and willingness to help o...read more
Answered by AI
Add your answer

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

Q1. What improvements to interfaces were introduced in Java 8 that were missing in Java 7, specifically regarding static and default methods?
Ans. 
Java 8 introduced static and default methods in interfaces, allowing for method implementation and code reusability.
• Java 8 introduced static methods in interfaces, allowing for method implementation directly in the interface itself.

• Default methods were also introduced in Java 8, enabling interfaces to have method implementations without affecting implementing classes.

• Static methods in interfaces can be called using the...read more
Answered by AI
Add your answer
Q2. Explain internal working of HashMap ? How to synchronize it ?
Ans. 
HashMap is a data structure that stores key-value pairs and uses hashing to efficiently retrieve values.
• HashMap uses an array of linked lists to store key-value pairs.

• When a key-value pair is added, the key is hashed to determine the index in the array where it will be stored.

• If multiple keys hash to the same index, a linked list is used to handle collisions.

• To synchronize a HashMap, you can use the synchronizedMap() m...read more
Answered by AI
Add your answer
Q3. Given a list of employees with their ratings, how can you sort the employees based on their ratings using the Java 8 Streaming API?
Add your answer
Q4. Will the program compile if the parent class throws a runtime exception while the child class throws an arithmetic exception?
Ans. 
No, the program will not compile if the parent class throws a runtime exception while the child class throws an arithmetic exception.
• In Java, if a parent class method throws a checked exception, the child class method can only throw the same exception or its subclasses.

• ArithmeticException is an unchecked exception, so if the parent class throws a checked exception and the child class throws an unchecked exception, the ...read more
Answered by AI
Add your answer
Q5. In a Spring Boot application with two databases, how can you configure JDBC to specify which database to use?
Ans. 
Configure JDBC in Spring Boot to specify which database to use
• Define multiple DataSource beans in the configuration class

• Use @Primary annotation to specify the primary DataSource

• Use @Qualifier annotation to specify the secondary DataSource

• Inject the DataSource beans where needed in the application
Answered by AI
Add your answer
Q6. How to use a jetty server in your spring boot application ?
Ans. 
To use a Jetty server in a Spring Boot application, you can configure it as a dependency and customize its settings.
• Add Jetty server dependency in your pom.xml file

• Exclude Tomcat server dependency if it's included by default in Spring Boot

• Configure Jetty server settings in application.properties or application.yml file

• Example: Add Jetty dependency - <dependency> <groupId>org.springframework.boot</groupId...read more
Answered by AI
Add your answer
Q7. Difference between @RequestParam and @PathVariable ?
Ans. 
RequestParam is used to extract query parameters from the URL, while PathVariable is used to extract values from the URI path.
• RequestParam is used for query parameters in the URL, while PathVariable is used for values in the URI path.

• RequestParam is optional, while PathVariable is required.

• RequestParam is used with the @RequestParam annotation, while PathVariable is used with the @PathVariable annotation.

• Example: @Requ...read more
Answered by AI
Add your answer
Q8. How would you handle a scenario where one microservice is awaiting a response from another microservice that is taking an extended time to respond?
Ans. 
I would implement timeout mechanisms and retries to handle the scenario of one microservice awaiting a response from another microservice taking an extended time.
• Implement timeout mechanisms in the calling microservice to limit the waiting time for a response.

• Set up retry logic to automatically resend the request to the slow microservice if no response is received within the specified timeout period.

• Use circuit breaker...read more
Answered by AI
Add your answer