Agam Interview Questions and Answers

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

The Aptitude Test session accesses mathematical and logical reasoning abilities

Q1. What is Vlookup
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Vlookup stands for 'Vertical Lookup'

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searc...read more
Answered by AI
Add your answer
Q2. Some IF else Question in Excel
Add your answer
Q3. What does your day in your previous organization look like?
Ans. 
My day in my previous organization involved analyzing large datasets, creating reports, and presenting findings to stakeholders.
• Reviewing and cleaning large datasets to ensure accuracy

• Creating visualizations and reports to communicate insights

• Collaborating with team members to identify trends and patterns

• Presenting findings to stakeholders in meetings or presentations
Answered by AI
Add your answer
Q4. Could you share the technical skills you possess?
Ans. 
I possess strong technical skills in data analysis, including proficiency in programming languages, statistical analysis, and data visualization tools.
• Proficient in programming languages such as Python, R, SQL

• Skilled in statistical analysis and data modeling techniques

• Experience with data visualization tools like Tableau, Power BI

• Knowledge of machine learning algorithms and techniques
Answered by AI
Add your answer
Q5. Can you explain what a Pivot Table is?
Ans. 
A Pivot Table is a data summarization tool used in spreadsheet programs to analyze, summarize, and present data in a tabular format.
• Pivot tables allow users to reorganize and summarize selected columns and rows of data to obtain desired insights.

• Users can easily group and filter data, perform calculations, and create visualizations using pivot tables.

• Pivot tables are commonly used in Excel and other spreadsheet program...read more
Answered by AI
Add your answer
Q6. Find the Highest-paid employee in each department along with their salary and department name.
Ans. 
To find the highest-paid employee in each department, we need to group employees by department and then select the employee with the highest salary in each group.
• Group employees by department

• Find the employee with the highest salary in each group

• Retrieve the employee's name, salary, and department name
Answered by AI
Add your answer

Q1. What are the key topics related to Generative AI, specifically focusing on Retrieval-Augmented Generation (RAG) and Large Language Models (LLM)?
Add your answer
Q2. What is your understanding of the existing project and the technology stacks used?
Add your answer

Q1. What has been your contribution to existing work and the technologies used in that context?
Add your answer
Q2. ML, DL, Gen AI implementation and flow
Add your answer
Q3. Python Coding logic and semantics
Add your answer

Q1. What are the existing work challenges you face, and what solutions have you implemented to address them?
Add your answer
Q2. What is your understanding of Generative AI and Natural Language Processing (NLP), and can you provide examples of their use cases?
Add your answer

Difference between soft skills and hard skills

Q1. What is manual testing
Add your answer
Q2. What is defect life cycleif
Add your answer

Q1. What is the main thing should have for a test engineer
Add your answer
Q2. What's your opinion on testing
Add your answer

Q1. Are you ok with rotational shifts?
Add your answer
Q2. Are you ok with the work location?
Add your answer

Q1. What is the impact of purchase of inventory on financial statements
Add your answer
Q2. Accounting concepts
Add your answer
Q3. What do u know about USGAAP
Add your answer
Q4. Since I mentioned in my resume that i have mutual funds and derivatives knowledge he asked me about these topics a bit
Add your answer

Q1. What do you know about optum
Add your answer
Q2. How well do you know the excel
Add your answer
Q3. You may have to learn various softwares, are you fine with it
Add your answer

Q1. Can you describe your previous experience?
Add your answer
Q2. What is your expected salary for this position?
Add your answer

Q1. Can you describe your previous work experience?
Add your answer
Q2. What do you know about inventory management?
Add your answer

Q1. Can you describe your previous professional experience?
Add your answer
Q2. What are the key principles of inventory management and auditing?
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. It was technical questions in relevant area
Add your answer
Q2. The questions relevant to my skill set and experience
Add your answer

Q1. The questions relevant to my skills and experience
Add your answer
Q2. The questions relevant to job requirements
Add your answer

Q1. General discussion about the profession and career
Add your answer
Q2. Discussed job location and client
Add your answer

Q1. Discussed about client and company
Add your answer
Q2. Orientation related things discussed.
Add your answer