NatWest Group
30+ AVT McCormick Ingredients Interview Questions and Answers
Q1. Explain the Constructor, Destructor, Generators
Constructor creates and initializes an object, Destructor destroys an object, Generators are functions that return iterators.
Constructor is a special method that is called when an object is created. It initializes the object's properties and allocates memory.
Destructor is a special method that is called when an object is destroyed. It frees up any resources that the object was using.
Generators are functions that use the yield keyword to return an iterator. They allow for lazy...read more
Q2. How does Python handle memory
Python uses automatic memory management through garbage collection.
Python uses reference counting to keep track of objects in memory.
When an object's reference count reaches zero, it is immediately deleted.
Python also uses a garbage collector to clean up circular references.
Memory allocation is handled by the Python memory manager.
Python provides tools like sys.getsizeof() to monitor memory usage.
Q3. Write a program for Binary Search
Program for Binary Search
Binary search is an efficient algorithm for finding an element in a sorted array.
It works by repeatedly dividing the search space in half.
The array must be sorted in ascending order for binary search to work.
The algorithm compares the target value with the middle element of the array.
If they are equal, the search is successful. If not, the search continues in the left or right half of the array.
Q4. Bsics of python and spark
Python is a high-level programming language used for various applications. Spark is a distributed computing framework for big data processing.
Python is easy to learn and has a large community for support.
Spark is used for processing large datasets and can handle data from various sources.
Python can be used with Spark to perform data analysis and machine learning tasks.
Spark provides APIs for programming in Java, Scala, and Python.
Python has libraries like NumPy, Pandas, and M...read more
Q5. Explain Java code compile process
Java code compile process involves several steps including preprocessing, compilation, and bytecode generation.
Java code is first preprocessed to handle import statements and macros.
The code is then compiled into bytecode using the Java compiler (javac).
The bytecode is platform-independent and can be executed on any Java Virtual Machine (JVM).
During compilation, the code is checked for syntax errors and type safety.
The compiled bytecode is stored in .class files.
At runtime, t...read more
Q6. 2. What is OOPs
OOPs stands for Object-Oriented Programming. It is a programming paradigm that uses objects to represent and manipulate data.
OOPs focuses on creating reusable code by organizing data and behavior into objects.
It emphasizes the concepts of encapsulation, inheritance, and polymorphism.
Objects are instances of classes, which define their properties (attributes) and behaviors (methods).
Inheritance allows classes to inherit properties and behaviors from other classes.
Polymorphism ...read more
Q7. Current task in currents organisation
Developing a new feature for the company's website to improve user experience.
Implementing front-end changes using React.js
Collaborating with UX designers to ensure design consistency
Testing the feature for bugs and performance issues
Q8. Explain JVM, JRE, JDK
JVM is a virtual machine that executes Java bytecode. JRE is a runtime environment that includes JVM and libraries. JDK is a development kit that includes JRE and tools for developing Java applications.
JVM stands for Java Virtual Machine and is responsible for executing Java bytecode.
JRE stands for Java Runtime Environment and includes JVM, libraries, and other components required to run Java applications.
JDK stands for Java Development Kit and includes JRE along with tools a...read more
Q9. What is balance sheet , income statement, difference between them,
Balance sheet and income statement are financial statements used to track a company's financial performance.
Balance sheet shows a company's assets, liabilities, and equity at a specific point in time.
Income statement shows a company's revenue, expenses, and net income over a period of time.
Balance sheet is a snapshot while income statement is a movie.
Balance sheet helps to determine a company's liquidity and solvency while income statement helps to determine its profitability...read more
Q10. Explain the software architecture of the project I am working on. Why certain design decisions are made.
The software architecture of the project involves a microservices-based approach with a combination of RESTful APIs and message queues for communication.
The project follows a microservices architecture to enable scalability and flexibility.
RESTful APIs are used for communication between different services.
Message queues like Kafka or RabbitMQ are utilized for asynchronous communication and decoupling of services.
Certain design decisions were made to ensure high availability, ...read more
Q11. How to ingest information, replicate environment, and migrate data in one of the Records Management system.
To ingest information, replicate environment, and migrate data in Records Management system, follow these steps:
Identify the source and target environments
Create a backup of the source environment
Replicate the source environment in the target environment
Migrate the data from the source to the target environment
Verify the data migration was successful
Q12. What action the Naukri will take on such a fake JD?
Naukri will take strict action against fake JDs by removing them and blacklisting the company.
The fake JD will be removed from the website immediately.
The company posting the fake JD will be blacklisted and banned from using Naukri services.
Naukri will also take legal action against the company if necessary.
The user who reported the fake JD will be notified of the action taken.
Naukri will continue to monitor for any further fraudulent activity.
Q13. What is current ratio, liquidity ratio etc.
Current ratio and liquidity ratio are financial ratios used to measure a company's ability to pay its short-term obligations.
Current ratio is calculated by dividing current assets by current liabilities and measures a company's ability to pay its short-term debts.
Liquidity ratio is calculated by dividing current assets minus inventory by current liabilities and measures a company's ability to pay its short-term debts without relying on inventory.
Other liquidity ratios include...read more
Q14. Provide a approach to develop ETL pipeline where csv file is dropped in S3 and transform through airflow and load to snowflake.
Develop ETL pipeline using Airflow to process CSV files in S3 and load data into Snowflake.
Set up an S3 sensor in Airflow to detect when a new CSV file is dropped in the specified bucket.
Create a custom Python operator in Airflow to read the CSV file from S3, perform necessary transformations, and load data into Snowflake.
Use SnowflakeHook in Airflow to establish connection with Snowflake and execute SQL queries to load data.
Schedule the ETL pipeline in Airflow to run at spec...read more
Q15. Does the JD from RBS cross checked properly by Naukri?
Yes, Naukri cross checks the JD from RBS before posting it on their website.
Naukri has a verification process in place to ensure the authenticity of job postings.
They verify the company and the job details before posting it on their website.
This helps in preventing fraudulent job postings and ensures job seekers get genuine job opportunities.
For example, Naukri verifies the company's registration details, website, and contact information before posting the job.
They also verif...read more
Q16. What tool you are using for monitering your Performance testing
We use JMeter for monitoring performance testing.
We use JMeter to simulate load on our system and monitor its performance.
JMeter provides various performance metrics like response time, throughput, and error rate.
We analyze the results from JMeter to identify bottlenecks and optimize performance.
JMeter allows us to create and execute performance test scripts for different scenarios.
Q17. Diffrence between server side and client side teating
Server side testing is done on the server side of an application to ensure its functionality, performance, and security, while client side testing is done on the client side to validate the user interface and user experience.
Server side testing focuses on backend functionality such as database interactions, server APIs, and server performance.
Client side testing focuses on frontend functionality such as user interface elements, user interactions, and browser compatibility.
Exa...read more
Q18. - Previous experience - Write basic program in Selenium
I have experience writing basic programs in Selenium for automation testing.
Use Selenium WebDriver to open a browser and navigate to a webpage
Locate elements on the webpage using various locators like ID, class name, xpath, etc.
Perform actions on the elements like clicking buttons, entering text, etc.
Use assertions to verify expected outcomes
Q19. What is heap memory
Heap memory is a region of a computer's memory that is used for dynamic memory allocation.
Heap memory is managed by the programmer and is not automatically cleaned up like stack memory.
It is used for storing objects and data structures that need to be allocated and deallocated at runtime.
Common functions for heap memory management include malloc(), calloc(), realloc(), and free().
Q20. How would you analyse a company if tou want to give term loan? What if cashflow is negative, will yo lend? Dscr How would you analyse a company
To analyze a company for a term loan, consider factors like cash flow, debt service coverage ratio (DSCR), financial statements, industry trends, and management quality.
Examine the company's financial statements to assess its profitability, liquidity, and leverage.
Calculate the debt service coverage ratio (DSCR) to determine if the company generates enough cash flow to cover its debt obligations.
Evaluate the company's industry trends and competitive position to assess its fut...read more
Q21. Do remember the difference between reconciliation and substantiation
Reconciliation involves comparing two sets of records to ensure they are in agreement, while substantiation involves providing evidence or support for a claim or statement.
Reconciliation is typically done between financial records, such as bank statements and accounting records, to identify and resolve discrepancies.
Substantiation involves providing documentation or evidence to support a claim or transaction.
Reconciliation focuses on ensuring accuracy and consistency between ...read more
Q22. Response code of creation
Response code of creation refers to the HTTP status code that indicates a successful creation of a resource.
The response code of creation is typically 201 (Created)
It is used when a new resource is successfully created on the server
Other possible response codes for creation include 202 (Accepted) and 204 (No Content)
Q23. Normal CPC behaviour
Normal CPC behaviour refers to the expected behavior of cost-per-click advertising campaigns.
Normal CPC behaviour involves a consistent cost-per-click rate for a given ad campaign.
Factors that can affect CPC behaviour include competition, ad relevance, and bid amount.
Abnormal CPC behaviour may indicate issues with the ad campaign or external factors such as click fraud.
Monitoring and analyzing CPC behaviour is important for optimizing ad campaigns and maximizing ROI.
Q24. Explained Natwest expectations.
Natwest expects high levels of customer service and operational efficiency from their Customer Service and Operations Executive.
Natwest expects the Customer Service and Operations Executive to provide excellent customer service to clients
They should ensure smooth operations and efficiency in daily tasks
The executive should be able to handle customer inquiries and complaints effectively
Natwest expects the executive to have strong communication and problem-solving skills
They sh...read more
Q25. What is the role of treasury
Q26. Explain Project's architecture
The project's architecture is designed to ensure scalability, reliability, and performance.
The architecture follows a microservices approach, with each component responsible for a specific function.
It utilizes a combination of cloud services and on-premise servers for optimal resource allocation.
Data is stored in a distributed database for high availability and fault tolerance.
Communication between components is done through RESTful APIs for flexibility and ease of integratio...read more
Q27. Tell me about sql queries
SQL queries are used to retrieve data from a database using specific criteria.
SQL stands for Structured Query Language
Queries can be used to retrieve data from one or multiple tables
Queries can also be used to update or delete data from a database
Examples of SQL queries include SELECT, INSERT, UPDATE, and DELETE
Q28. Likely range of variability
Q29. Slection of cohort year
Q30. Explain PD model
Top HR Questions asked in AVT McCormick Ingredients
Interview Process at AVT McCormick Ingredients
Top Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month