Amantya Technologies Senior Analyst Interview Questions and Answers

Q1. About Previous organizations
Add your answer
Q2. Personal Information
Add your answer

Q1. About Linux basics and shell scripting
Add your answer
Q2. Sql basics queries like joins,Index, Constraints
Add your answer
Q3. Issues faced during productions ad there resolutions
Ans. 
Production issues are common and require quick resolution to minimize downtime and losses.
• Equipment breakdowns can cause delays and require maintenance or replacement.

• Supply chain disruptions can lead to shortages and delays in production.

• Quality control issues can result in defective products and require process improvements.

• Communication breakdowns between departments can cause delays and errors.

• Regular maintenance a...read more
Answered by AI
Add your answer

It includes the topics of aptitude and coding pattern output question

Q1. What is payment gateway suggest some examples
Add your answer
Q2. What is afiliate marketing
Add your answer

Q1. Is artificial intelligence good for the market or not
Add your answer

Q1. What is BRD,RACI MATRIX, FRD, SDLC,AGILE
Ans. 
BRD, RACI MATRIX, FRD, SDLC, and AGILE are common terms used in business analysis and project management.
• BRD stands for Business Requirements Document, which outlines the business solution for a project.

• RACI MATRIX is a tool used to define roles and responsibilities for project tasks.

• FRD stands for Functional Requirements Document, which details the functional specifications of a project.

• SDLC stands for Software Develo...read more
Answered by AI
Add your answer
Q2. SPRINTS, KANBAN,SCRUM,PHASES OF SDLC.
Add your answer

Q1. Highlight the odd cells in excel
Ans. 
Use conditional formatting to highlight odd cells in Excel
• Select the range of cells you want to highlight

• Go to the 'Home' tab and click on 'Conditional Formatting'

• Choose 'New Rule' and select 'Use a formula to determine which cells to format'

• Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)

• Choose the formatting style you want for the odd cells
Answered by AI
Add your answer
Q2. What are Joins in SQL, explain different joins and their outputs
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FU...read more
Answered by AI
Add your answer
Q3. Query to give running sum of salary
Ans. 
Use window function to calculate running sum of salary in SQL
• Use window function like SUM() with OVER() clause

• Partition the data by employee ID if needed

• Order the data by date or any other relevant column
Answered by AI
Add your answer

Q1. Explain recent project
Ans. 
Developed a predictive model for customer churn in a telecom company
• Collected and cleaned customer data from various sources

• Performed exploratory data analysis to identify patterns and trends

• Built a machine learning model using logistic regression to predict customer churn

• Evaluated the model's performance using metrics such as accuracy, precision, and recall
Answered by AI
Add your answer
Q2. Cloud technologies used
Ans. 
Various cloud technologies like AWS, Azure, and Google Cloud are commonly used for data analysis.
• AWS (Amazon Web Services)

• Azure (Microsoft Azure)

• Google Cloud Platform
Answered by AI
Add your answer

Performance based questions

Q1. General questions about Business analysis, Documentations and tools
Add your answer
Q2. What is BRD ?
Ans. 
BRD stands for Business Requirements Document, which outlines the business needs and requirements for a project.
• BRD is a formal document that describes the business needs and requirements for a project.

• It serves as a reference point for the project team to ensure that the project meets the business objectives.

• BRD typically includes sections such as project scope, objectives, stakeholders, functional requirements, non-f...read more
Answered by AI
Add your answer
Q3. What are other documents prepared?
Ans. 
Various documents prepared include business requirements document, functional requirements document, use cases, process flows, and data models.
• Business Requirements Document (BRD) outlines the business problem, objectives, and proposed solution.

• Functional Requirements Document (FRD) details the system functionalities and features.

• Use Cases describe interactions between users and the system.

• Process Flows illustrate the ...read more
Answered by AI
Add your answer

Q1. Introduction, Projects handled and roles played. Different types of requirements and how to ensure all requirements met. Tools and technologies handled and scenario based questions etc
Add your answer

Q1. Compensation and benefits and negotiation of salary
Add your answer

2 coding questions in 45 min

Q1. Basics of java and frameworks
Add your answer
Q2. Basics of SQL and types of queries
Add your answer

30 min of logical reasoning and basic aptitude

30 min of GD over a general topic to check your communication skills

Q1. Why do you want to join our company
Add your answer
Q2. Why should we hire you
Add your answer