Meghmani Lifesciences Interview Questions and Answers

Q1. Self intro and project architecture
Add your answer
Q2. What are the data sources used?
Add your answer
Q3. Bigquery architecture
Add your answer
Q4. Partition vs clustering
Add your answer
Q5. Bq commands on create table and load csv file
Add your answer
Q6. Bq commands on show the schema of the table
Add your answer
Q7. Explain about leaf nodes and columnar storage.
Add your answer
Q8. How many slots are there in bigquery?
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. Current CTC, Expected CTC, Notice Period, Skill set
Add your answer
Q2. Open for Fixed term hire? Open for working from client location at Gurgaon? (3 days from office)
Ans. 
Yes, open for fixed term hire and working from client location at Gurgaon for 3 days a week.
• Open for fixed term hire

• Willing to work from client location at Gurgaon for 3 days a week
Answered by AI
Add your answer

Q1. Introduction, Current role and responsibilities
Add your answer
Q2. List out the achievements in current project, Tools used
Ans. 
Implemented automated testing using Selenium WebDriver and JUnit in Agile environment
• Implemented automated testing framework using Selenium WebDriver

• Utilized JUnit for test case management

• Worked in Agile environment to ensure continuous testing and integration
Answered by AI
Add your answer
Q3. Pilot vs Beta testing. How can newly developed functionality be tested via automation rather doing it manually?
Ans. 
Pilot testing is done by a small group of users before the full release, while beta testing is done by a larger group of users. Automation testing can be used for regression testing, smoke testing, and performance testing.
• Pilot testing involves a small group of users testing the functionality in a controlled environment.

• Beta testing involves a larger group of users testing the functionality in a real-world environment.

• ...read more
Answered by AI
Add your answer
Q4. Primary key vs Unique key in SQL, Query to find row having last id in sql
Ans. 
Primary key uniquely identifies a record, while unique key allows only one instance of a value in a column. Query to find last id involves using ORDER BY and LIMIT.
• Primary key enforces uniqueness and not null constraint on a column

• Unique key enforces uniqueness but allows null values

• To find row with last id, use ORDER BY id DESC LIMIT 1 in SQL query
Answered by AI
Add your answer
Q5. Explain Software Testing Life Cycle, Defect Life Cycle
Ans. 
Software Testing Life Cycle (STLC) involves planning, designing, executing, and reporting on tests. Defect Life Cycle includes identification, logging, fixing, and retesting defects.
• STLC includes requirements analysis, test planning, test design, test execution, and test closure.

• Defect Life Cycle involves defect identification, defect logging, defect fixing, defect retesting, and defect closure.

• STLC ensures that the so...read more
Answered by AI
Add your answer
Q6. What's the meaning of 303 status code in API? Put vs Delete method in API What is 3 point estimation technique in Agile?
Ans. 
303 status code in API means 'See Other'. PUT method is used to update data, while DELETE method is used to remove data. 3 point estimation technique in Agile is used to estimate tasks.
• 303 status code indicates that the resource can be found at a different URI and should be retrieved from there

• PUT method is used to update an existing resource in the API

• DELETE method is used to remove a resource from the API

• 3 point esti...read more
Answered by AI
Add your answer
Q7. What kind of links and labels can be tagged to a bug in jira?
Ans. 
Links and labels that can be tagged to a bug in Jira
• Links: related issues, documents, websites

• Labels: priority, severity, type, status
Answered by AI
Add your answer
Q8. Have you done shell scripting? What does grep, href commands do in unix?
Ans. 
Shell scripting is a way to automate tasks in Unix/Linux systems. Grep is used to search for specific patterns in text files. Href is not a standard Unix command.
• Shell scripting automates tasks by writing scripts in a Unix/Linux environment

• Grep command is used to search for specific patterns in text files

• Example: grep 'search_pattern' file.txt

• Href is not a standard Unix command, it may be a typo or a custom script
Answered by AI
Add your answer
Q9. As a lead, how would you resolve conflict with a team member? As a lead, if you are given plenty of tasks to be completed with in a limited time frame. What would be your approach in doing them?
Ans. 
To resolve conflict with a team member, communication is key. Prioritize understanding, address the issue calmly, find common ground, and work towards a solution together.
• Listen to the team member's perspective and concerns

• Communicate openly and calmly about the issue

• Find common ground and areas of agreement

• Work together to find a solution that benefits both parties

• Seek input from other team members or a mediator if ne
Answered by AI
Add your answer
Q10. Open for relocating to Bangalore and working from client's office? (with no relocation bonus) Open for working in night / rotational shift? (with no additional compensation) Open for working in long exten...read more
Ans. 
Open to relocating to Bangalore, working in night shifts, long hours, and 24X7 culture. Goal is to excel in automation testing.
• Yes, open to relocating to Bangalore and working from client's office

• Yes, open to working in night/rotational shifts

• Yes, open to working in long extendable hours or 24X7 culture

• Goal is to excel in automation testing
Answered by AI
Add your answer

Q1. How many variance in sap?
View 1 more answer
Q2. We cac explain the all accounts receivable and accounts payable
View 2 more answers
Q3. What is the cost element and cost center?
View 2 more answers
Q4. How many we have currencies in sap?
View 1 more answer
Q5. How many types of projects
View 1 more answer