Avantha Business Solutions 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

Q1. Write a code for febonacci series
Add your answer
Q2. Dynamic webElements handling using Xpath?
Add your answer
Q3. What is spike in agile?
Add your answer
Q4. Difference between agile and waterfall based model?
Add your answer
Q5. Sprint point system? Explain?
Add your answer
Q6. Payment failure by debit card in e-commerce site? Make test scenarios?
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 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

Q1. What is the architecture of the Java Virtual Machine (JVM)?
Ans. 
The Java Virtual Machine (JVM) is an abstract computing machine that enables a computer to run Java programs.
• JVM is platform-independent and converts Java bytecode into machine code.

• It consists of class loader, runtime data areas, execution engine, and native method interface.

• JVM memory is divided into method area, heap, stack, and PC register.

• Examples of JVM implementations include Oracle HotSpot, OpenJ9, and GraalVM.
Answered by AI
Add your answer
Q2. What is the default connection pooling in Spring Boot, and how can it be customized?
Ans. 
The default connection pooling in Spring Boot is HikariCP, which can be customized through properties in the application.properties file.
• HikariCP is the default connection pooling library in Spring Boot, known for its high performance and low overhead.

• To customize the connection pooling, you can modify properties like 'spring.datasource.hikari.*' in the application.properties file.

• For example, you can set maximum pool ...read more
Answered by AI
Add your answer
Q3. What are the best practices for optimizing a Spring Boot application?
Ans. 
Best practices for optimizing a Spring Boot application
• Use Spring Boot Actuator to monitor and manage application performance

• Implement caching mechanisms like Spring Cache to reduce database calls

• Optimize database queries and indexes for better performance

• Use asynchronous processing with Spring's @Async annotation for non-blocking operations

• Profile and analyze application performance using tools like VisualVM or JProfi
Answered by AI
Add your answer
Q4. What is a heap dump, and how can it be used to identify memory leaks?
Ans. 
A heap dump is a snapshot of the memory usage of a Java application at a specific point in time.
• Heap dumps can be generated using tools like jmap or VisualVM.

• They provide detailed information about objects in memory, their sizes, and references.

• Analyzing a heap dump can help identify memory leaks by pinpointing objects that are consuming excessive memory.

• Common signs of memory leaks in a heap dump include a large numbe...read more
Answered by AI
Add your answer
Q5. How can you diagonally iterate through and print the elements of a 2D array?program
Ans. 
Diagonally iterate through and print elements of a 2D array of strings.
• Use nested loops to iterate through rows and columns of the 2D array.

• Calculate the diagonal elements by incrementing row and column indices together.

• Print the elements as you iterate through the diagonal of the array.
Answered by AI
Add your answer

Q1. Generic Regulatory related
Add your answer
Q2. Medical devices class, medical regulatory and medical devices standards
Add your answer

Q1. Verification process
Add your answer
Q2. Regulatory affairs, Risk management
Add your answer

Q1. Pyspark architecture
Add your answer
Q2. Optimisation in pyspark
Add your answer
Q3. Null handling in spark
Add your answer
Q4. Operators in airflow
Add your answer
Q5. Sql coding for average rolling , lead lag
Add your answer
Q6. Mysql to gcs ,how to move 10 tables at a time?
Add your answer
Q7. Explode json data
Add your answer
Q8. Error logs
Add your answer

Q1. What is polymorphism,generator,decorator? List vs tuple?
Ans. 
Polymorphism allows objects of different classes to be treated as objects of a common superclass. Generators produce items one at a time. Decorators add functionality to existing functions or methods.
• Polymorphism: Enables objects of different classes to be treated as objects of a common superclass. Example: Animal superclass with Dog and Cat subclasses.

• Generator: Produces items one at a time, allowing for efficient mem...read more
Answered by AI
Add your answer
Q2. TFIDF, BOW What is embedding why important how to craete embeddings?
Ans. 
Embeddings are a way to represent words or phrases as vectors in a high-dimensional space, capturing semantic relationships.
• Embeddings are important for tasks like natural language processing, where words need to be represented in a meaningful way.

• They can be created using techniques like Word2Vec, GloVe, or using neural networks like Word Embeddings.

• Embeddings help in capturing semantic relationships between words, al...read more
Answered by AI
Add your answer
Q3. What is Encoder decoder explain with example?
Ans. 
Encoder-decoder is a neural network architecture used for tasks like machine translation.
• Encoder processes input data and generates a fixed-length representation

• Decoder uses the representation to generate output sequence

• Example: Seq2Seq model for translating English to French
Answered by AI
Add your answer
Q4. What is stop word? We need to remove in every application or not tell me example when stop words are importan?
Add your answer

Q1. Realted to o365 theory
Add your answer
Q2. Regarding litigation hold and retention policies with mailflow and structure and some scenario based questions
Add your answer

Q1. Regarding technical questions and scenario based
Add your answer
Q2. Teams issues and outlook
Add your answer

Q1. Salary discussion
Add your answer
Q2. Description of working culture and ethics
Add your answer