Aishwarya Civiltech Interview Questions and Answers

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. What is correlation and parameterization?
Add your answer
Q2. Explain load, stress, all testing?
Add your answer
Q3. Explain PTLC?
Add your answer
Q4. Loadrunner scripting, execution and reports issue faced and how to process?
Add your answer
Q5. LG calculation and workload modelling process?
Add your answer
Q6. NFR scenarios?
Add your answer

Q1. Loadrunner questions
Add your answer

Q1. Check your soft skills
Add your answer

Q1. Complete your details
Add your answer

A case study in an Optum interview typically revolves around solving a real-world problem related to healthcare, data analysis, technology, or business strategy, given Optum’s focus on healthcare services and technology solutions. Here are some tips on how to approach a case study interview at Optum and a sample example:

Steps to Approach an Optum Case Study:

1. Understand the Problem Statement:

Take time to read the case study carefully and make sure you understand the key issue or question.

Identify the stakeholders involved (patients, healthcare providers, insurance companies, etc.) and the objective (cost reduction, improving patient outcomes, increasing efficiency, etc.).



2. Clarify Assumptions:

If there are any ambiguous elements, ask questions to clarify the problem.

You can also state your assumptions if you're making any, but be clear that these are assumptions.



3. Break Down the Problem:

Identify key data points you would need to analyze.

Break the problem into smaller pieces that can be addressed step-by-step.



4. Analyze:

Use frameworks like SWOT analysis, PESTLE analysis, or Porter’s Five Forces if applicable to the case.

In case of a data-related problem, try to identify key metrics (such as patient satisfaction, cost, quality of care, etc.) and how they can be improved or measured.

For technology-related cases, consider aspects like scalability, security, user experience, and integration with existing systems.



5. Propose a Solution:

Present your findings logically and suggest a solution based on your analysis.

Make sure to consider both short-term and long-term impacts on patient

Q1. When interviewing with Optum, you can expect a mix of technical, behavioral, and situational questions, especially considering their focus on healthcare services, technology, and data analysis. Here are so...read more
Add your answer
Q2. Done
Add your answer

Computer typing should be 40 wpm. And optional question answer multiple choice questions

Online assessment (Technical, English, Reasoning)

Q1. Difference between Balance sheet and trial balance
Ans. 
Balance sheet shows assets, liabilities, and equity at a specific point in time. Trial balance lists all ledger accounts with their balances.
• Balance sheet is a snapshot of a company's financial position at a specific point in time.

• Trial balance is a list of all ledger accounts with their balances to ensure debits equal credits.

• Balance sheet includes assets, liabilities, and equity sections.

• Trial balance is used to prep...read more
Answered by AI
Add your answer
Q2. Standard costing formula
Ans. 
Standard costing formula calculates the expected cost of a product based on predetermined standards.
• Standard costing formula includes direct materials, direct labor, and overhead costs.

• It helps in comparing actual costs with standard costs to identify variances.

• Formula: Standard Cost = Standard Quantity of Inputs x Standard Price of Inputs
Answered by AI
Add your answer
Q3. Journal entries for Prepaid Accruals Depreciation with accumulated depreciation concept Provision for Bad debts DTA and DTL
Ans. 
Explanation of journal entries for Prepaid, Accruals, Depreciation, Provision for Bad debts, DTA, and DTL.
• Prepaid expenses are initially recorded as assets and then expensed over time as they are used up.

• Accruals are expenses incurred but not yet paid or revenue earned but not yet received.

• Depreciation is the allocation of the cost of a fixed asset over its useful life, with accumulated depreciation representing the to...read more
Answered by AI
Add your answer
Q4. Case study on Ind AS 115
Add your answer
Q5. Preparation of balance sheet and computation of various ratios
Ans. 
Preparation of balance sheet involves listing assets, liabilities, and equity. Ratios are computed using financial data from the balance sheet.
• List all assets, liabilities, and equity on the balance sheet

• Calculate various financial ratios such as current ratio, debt to equity ratio, and return on equity

• Use formulae like Current Ratio = Current Assets / Current Liabilities

• Interpret the ratios to analyze the financial he
Answered by AI
Add your answer
Q6. Accounting principles
Add your answer

Q1. What is DTA and DTL
Ans. 
DTA stands for Deferred Tax Asset and DTL stands for Deferred Tax Liability.
• DTA is an asset recorded on a company's balance sheet that may be used to reduce taxable income in the future.

• DTL is a liability recorded on a company's balance sheet that represents taxes that have been accrued but not yet paid.

• DTA arises when a company has overpaid taxes or has tax deductions that exceed its taxable income.

• DTL arises when a c...read more
Answered by AI
Add your answer
Q2. Accounting entry for accumulated depreciation
Ans. 
Accumulated depreciation is a contra asset account that represents the total depreciation expense taken on an asset since it was acquired.
• Accumulated depreciation is recorded on the balance sheet as a reduction from the gross amount of fixed assets to arrive at the net book value.

• The accounting entry for accumulated depreciation involves debiting the depreciation expense account and crediting the accumulated depreciati...read more
Answered by AI
Add your answer
Q3. Few resume based questions
Add your answer
Q4. Standard costing formula
Ans. 
Standard costing formula calculates the expected cost of a product based on predetermined standards.
• Standard costing formula = Standard cost of direct materials + Standard cost of direct labor + Standard manufacturing overhead cost

• Standard cost of direct materials = Standard quantity of materials x Standard price per unit

• Standard cost of direct labor = Standard hours of labor x Standard rate per hour

• Standard manufactur...read more
Answered by AI
Add your answer
Q5. Difference between budgeting and forecasting
Ans. 
Budgeting involves setting financial goals and allocating resources, while forecasting predicts future financial outcomes based on past data and trends.
• Budgeting is a plan for how to allocate resources and achieve financial goals

• Forecasting predicts future financial outcomes based on past data and trends

• Budgeting is typically done on an annual basis, while forecasting can be done on a shorter or longer term basis

• Budget...read more
Answered by AI
Add your answer
Q6. Meaning of variance analysis
Ans. 
Variance analysis is a technique used to identify and analyze the difference between planned financial outcomes and actual results.
• Variance analysis helps in understanding the reasons for deviations from budgeted or expected figures.

• It involves comparing actual financial performance with budgeted or standard performance.

• Common types of variances include price variance, quantity variance, and mix variance.

• Variance analy...read more
Answered by AI
Add your answer

Q1. Good interview and best interview I have took.
Add your answer

Q1. Chat assessment for non voice roles..
Add your answer

Q1. Personal questions and other to discuss about the perks and salaries.
Add your answer

Test that assesses a person's skills and abilities in a particular area. They are used in schools, by employers, and to help people decide on a career.
Types of aptitude tests
Logical reasoning: Measures a person's ability to analyze information and draw conclusions
Situational judgment: Assesses how a person would respond to real-life work scenarios
Abstract reasoning: Measures a person's ability to identify patterns, logical rules, and data trends
Spatial reasoning: Measures a person's ability to understand and manipulate 2D or 3D objects
Diagrammatic reasoning: Measures a person's problem-solving, abstract reasoning, and critical thinking abilities
Inductive reasoning: Measures a person's ability to see the underlying logic in patterns
Critical thinking: Measures a person's ability to solve complex problems and make the right decision
Tips for taking aptitude tests Understand the underlying concepts and formulas, Practice regularly, Use elimination to narrow down multiple-choice options, Work backwards to solve problems, and Practice solving questions within a time limit.

Coding test is a programming challenge that assesses a candidate's coding skills and problem-solving abilities. It's a common part of the technical recruitment process for programmers and developers.
Purpose To evaluate a candidate's programming skills, To screen potential candidates, To reduce time to hire, and To increase efficiency.
How they're used
To assess a candidate's ability to solve problems
To assess a candidate's understanding of coding
To assess a candidate's ability to debug
To assess a candidate's ability to design systems
To assess a candidate's ability to organize and manage data
How to prepare
Learn basic algorithms and data structures
Understand the Big-O Notation
Practice coding in writing
Practice common data structures and algorithms
Study problem-solving patterns
Practice with mock tests
How to solve coding problems
Understand the problem
Break the problem down into smaller steps
Write the code
Test your code with examples
Optimize if necessary
Handle mistakes gracefully
This video can also help you learn how to pass a coding assessment test:


1m


Online Training for Everyone
YouTube · 26 Sept 2023

Q1. Basic question on the tool I use in previous company and ask question on the components of it.
Add your answer

Q1. More on what is my role and managerial round.
Add your answer

Q1. 2 hour long interview with a panel of 4. Possibly every single question that can be asked and repeatedly same things. They tried understanding the process and functions elaborately way too much which was ...read more
Add your answer

Q1. Everything was already asked. But they need to drench and waste time of the candidate and themselves so they set up another round of technical to ask the same questions again and again.
Add your answer

Q1. Hdfc bank job retirement
Add your answer
Q2. I am applying for this your company job
Add your answer
Q3. I am Interested this job
Add your answer
Q4. What is process this company
Add your answer
Q5. My profile this mach your company
Add your answer