Vishakha Group Interview Questions, Process, and Tips

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Write a 1,200-word article titled "Mental Health Awareness in Hawai‘i: Challenges, Progress, and Support." The article should be written in simple, clear, and engaging language for a general audience. It should focus on:

1. Introduction (150-200 words)

Define mental health and its importance.

Mention Hawai‘i’s beautiful environment but highlight that mental health issues still exist.

Briefly state the challenges and efforts being made to improve mental health care in Hawai‘i.



2. Mental Health Challenges in Hawai‘i (400-500 words)

Financial Stress: High cost of living and its impact on mental well-being.

Geographic Isolation: Limited mental health resources on neighbor islands.

Cultural Stigma: Traditional beliefs that prevent people from seeking help.

Youth Mental Health Issues: High suicide rates and school-related stress.



3. Progress and Solutions (400-500 words)

Telehealth and Expanded Services: Online therapy and community health programs.

Culturally Sensitive Therapy: Combining modern psychology with traditional Hawaiian healing.

Suicide Prevention Efforts: Crisis hotlines, school counseling, and support groups.

Encouraging Open Conversations: Mental health awareness campaigns and community events.



4. Where to Find Help (150-200 words)

List mental health hotlines, organizations, and support groups available in Hawai‘i.

Encourage readers to seek help if they or someone they know is struggling.



5. Conclusion (150-200 words)

Emphasize the importance of breaking the stigma around mental health.

Highlight the progress being made and the need for continued awareness.

Offer a hopeful message that help is available, and seeking support is a sign of strength.




The article should be informative, empathetic, and solution-focused, encouraging readers to take mental health seriously and seek support when needed.

Mental Health Challenges in Hawai‘i (400-500 words)

Financial Stress: High cost of living and its impact on mental well-being.

Geographic Isolation: Limited mental health resources on neighbor islands.

Cultural Stigma: Traditional beliefs that prevent people from seeking help.

Youth Mental Health Issues: High suicide rates and school-related stress.

Mental Health Awareness in Hawai‘i: Challenges, Progress, and Support

Introduction

Mental health is a growing concern across the world, and Hawai‘i is no exception. While the islands are known for their beautiful landscapes, warm weather, and relaxed culture, many residents face mental health challenges. Factors such as the high cost of living, geographic isolation, cultural stigma, and limited healthcare access can make it difficult for people to seek help.

This article explores the state of mental health in Hawai‘i, the challenges people face, and the available resources for those seeking support. Raising awareness and encouraging open conversations can help break the stigma and ensure that everyone receives the care they need.


---

Mental Health Challenges in Hawai‘i

1. High Cost of Living and Financial Stress

Hawai‘i has one of the highest costs of living in the United States. The high price of housing, food, and utilities puts financial pressure on many residents. According to a report by the Aloha United Way, nearly 42% of households in Hawai‘i are struggling to meet basic needs. This financial stress can lead to anxiety, depression, and other mental health issues.

Many families live paycheck to paycheck, worrying about rent, bills, and food expenses. The fear of job loss or unexpected medical costs can also contribute to high stress levels.

2. Geographic Isolation and Limited Access to Care

Hawai‘i’s unique geography creates additional mental health challenges. Being thousands of miles away from the U.S. mainland, the islands have limited healthcare providers and mental health professionals. Many communities, especially on neighbor islands like Moloka‘i and Lana‘i, have very few mental health services.

For those in rural areas, traveling to another island for therapy or psychiatric care can be expensive and time-consuming. Telehealth services have helped improve access, but not everyone has the internet access or technology needed for virtual therapy sessions.

3. Cultural Stigma and Traditional Beliefs

Mental health stigma remains a significant issue in Hawai‘i. In many cultures, including Native Hawaiian, Filipino, and other Asian communities, discussing mental health struggles is seen as shameful or a sign of weakness. Many people hesitate to seek help because they fear judgment from family or society.

Some traditional beliefs emphasize self-reliance and resilience, which can discourage individuals from opening up about their struggles. Instead of seeking professional help, some people turn to family, religion, or traditional healing practices. While these support systems are valuable, they may not always be enough to address serious mental health conditions like severe depression or anxiety disorders.

4. Youth and Mental Health

Young people in Hawai‘i face unique mental health challenges. According to the Hawai‘i State Department of Health, suicide is the leading cause of death for young people aged 15–24 in the state. Many teens and young adults struggle with stress, academic pressure, bullying, and social isolation.

The rise of social media has also affected mental health, with many young people experiencing cyberbullying or unrealistic beauty and lifestyle expectations. Despite these challenges, many schools and organizations are working to provide better mental health education and support for students.


---

Progress and Solutions: How Hawai‘i is Addressing Mental Health

1. Expanding Mental Health Services

In recent years, Hawai‘i has been working to improve mental health services. Some key initiatives include:

Telehealth Programs: Online therapy and counseling services help connect people with mental health professionals, especially in rural areas.

Community Health Centers: Organizations like the Waikīkī Health Center and Hawai‘i Behavioral Health provide low-cost or free mental health services.

State and Nonprofit Support: The Hawai‘i Department of Health offers crisis intervention programs, while groups like Mental Health America of Hawai‘i work to increase awareness and provide resources.


2. Promoting Cultural Sensitivity in Therapy

Many organizations now focus on culturally appropriate mental health care. This means providing therapy that respects different cultural backgrounds and traditions. For example, some therapists incorporate Native Hawaiian healing practices like ho‘oponopono (a traditional conflict resolution and forgiveness process) into mental health treatment.

By combining modern psychology with traditional healing, mental health professionals can help more people feel comfortable seeking care.

3. Suicide Prevention Efforts

To address the high suicide rates, Hawai‘i has increased efforts in suicide prevention. Some programs include:

The Hawai‘i CARES Crisis Line: A 24/7 hotline providing support for people in distress.

School-Based Mental Health Programs: Many schools now offer counseling services and mental health education to help students recognize and address emotional struggles.

Community Workshops and Support Groups: Organizations host events to teach coping skills, stress management, and ways to support loved ones struggling with mental health issues.


4. Encouraging Open Conversations

Breaking the stigma around mental health starts with conversation. Many local groups, churches, and community centers now hold mental health awareness events to encourage people to talk about their experiences. Social media campaigns and public figures also play a role in normalizing discussions about mental health.

By sharing personal stories and showing that mental health struggles are common, Hawai‘i’s residents can create a more supportive and understanding community.


---

Where to Find Help in Hawai‘i

If you or someone you know is struggling with mental health issues, there are many resources available:

Hawai‘i CARES Crisis Line: XXXXX (O‘ahu) or XXXXX (Neighbor Islands) – Available 24/7 for crisis support.

Mental Health America of Hawai‘i: Offers support groups, educational programs, and resources for individuals and families.

The National Suicide Prevention Lifeline: 988 – A free, confidential helpline for anyone in distress.

Hawai‘i Behavioral Health: Provides therapy, counseling, and behavioral health services across the state.

Community Health Clinics: Many local clinics offer low-cost or free mental health services.


If you are unsure where to start, calling the Hawai‘i CARES Crisis Line can connect you to the right resources.


---

Conclusion

Mental health awareness in Hawai‘i is more important than ever. While challenges like financial stress, cultural stigma, and limited healthcare access remain, progress is being made through expanded services, suicide prevention programs, and open conversations.

By encouraging mental health education, reducing stigma, and increasing access to care, Hawai‘i can create a healthier and more supportive community. No one should struggle alone—help is available, and seeking support is a sign of strength.

If you or a loved one are facing mental health challenges, don’t hesitate to reach out for help. Your well-being matters, and there is always hope for healing and recovery.

Mental Health Awareness in Hawai‘i that highlight both the challenges and solutions.

Example:

1. "Despite Hawai‘i’s natural beauty, many residents struggle with mental health due to financial stress, cultural stigma, and limited healthcare access."


2. "To improve mental well-being, we need more open conversations, better mental health services, and culturally sensitive support systems."

Q1. What is federated data warehouse?
Add your answer
Q2. What is database table versioning (this is same as maintaining history SCD)?
Add your answer
Q3. How will you handle 1:M and M:M relationship in data modeling?
Add your answer
Q4. What is Lambda architecture?
Add your answer
Q5. How can you improve data warehouse/DB performance?
Add your answer
Q6. What is hyper-normalization?
Add your answer

Q1. General culture fit questions.
Add your answer

Q1. What is your notice period, and what is your current salary?
Ans. 
My notice period is 1 month, and my current salary is $60,000 per year.
• Notice period is 1 month

• Current salary is $60,000 per year
Answered by AI
Add your answer
Q2. What is your notice period?
Ans. 
My notice period is one month.
• Notice period is one month

• Standard notice period in the industry

• Can be negotiable based on circumstances
Answered by AI
Add your answer

Q1. What is an amortization entry?
Ans. 
An amortization entry is a financial transaction that spreads the cost of an intangible asset over its useful life.
• Amortization entries are used to gradually reduce the value of intangible assets on the balance sheet.

• They are typically recorded as a debit to amortization expense and a credit to the intangible asset account.

• Examples of intangible assets that may require amortization entries include patents, trademarks,
Answered by AI
Add your answer
Q2. What is the process for recording a depreciation entry in accounting?
Ans. 
Depreciation entry in accounting involves allocating the cost of an asset over its useful life.
• Calculate the depreciation expense using a chosen method (straight-line, double-declining balance, units of production, etc.)

• Debit the depreciation expense account and credit the accumulated depreciation account

• Adjust the book value of the asset on the balance sheet

• Repeat the process each accounting period until the asset is
Answered by AI
Add your answer
Q3. What are the types of reconstruction currently being undertaken?
Ans. 
Types of reconstruction currently being undertaken include urban, environmental, and infrastructure reconstruction.
• Urban reconstruction - rebuilding of cities and towns after natural disasters or conflicts

• Environmental reconstruction - restoration of ecosystems and habitats

• Infrastructure reconstruction - repairing or upgrading of roads, bridges, and utilities

• Examples: rebuilding of New Orleans after Hurricane Katrina, ...read more
Answered by AI
Add your answer
Q4. What is your reason for seeking a job change?
Ans. 
Seeking new challenges and growth opportunities in a dynamic work environment.
• Looking for new challenges and opportunities for growth

• Seeking a more dynamic work environment

• Interested in taking on more responsibilities as an Assistant Manager
Answered by AI
Add your answer
Q5. What automation ideas have you implemented or suggested in your current processes?
Ans. 
Implemented automation ideas include introducing automated email notifications for order status updates and setting up automated data backups.
• Introduced automated email notifications for order status updates to improve communication with customers

• Set up automated data backups to ensure data security and prevent loss

• Suggested implementing automated inventory management system to streamline operations and reduce manual e
Answered by AI
Add your answer
Q6. What is the accounting entry for prepaid expenses?
Ans. 
Prepaid expenses are assets paid for in advance but not yet used, so the accounting entry involves debiting an asset account and crediting a liability account.
• Debit the Prepaid Expense account (asset account) to increase its balance

• Credit the Cash/Bank account or Accounts Payable account to decrease the balance

• As the prepaid expense is used up, it is recognized as an expense on the income statement

• Examples: Prepaid ren
Answered by AI
Add your answer

Q1. What is the amortization entry?
Ans. 
Amortization entry is a financial accounting process of spreading the cost of an intangible asset over its useful life.
• Amortization entry is used to allocate the cost of intangible assets such as patents, copyrights, and trademarks over their useful life.

• It helps in matching the expense of the asset with the revenue it generates.

• The entry typically involves debiting amortization expense and crediting accumulated amorti...read more
Answered by AI
Add your answer
Q2. What is your understanding of Lean?
Ans. 
Lean is a methodology focused on maximizing customer value while minimizing waste.
• Lean is about continuously improving processes to eliminate waste and increase efficiency.

• It involves identifying value from the customer's perspective and streamlining operations to deliver that value.

• Lean principles include Kaizen (continuous improvement), Just-in-Time production, and Jidoka (automation with a human touch).

• Examples of L...read more
Answered by AI
Add your answer
Q3. What is your understanding of Six Sigma
Ans. 
Six Sigma is a data-driven methodology used to improve processes by reducing defects and variations.
• Six Sigma aims to achieve near perfection in processes by identifying and eliminating causes of defects or errors.

• It uses statistical tools and techniques to measure and analyze process performance.

• The goal of Six Sigma is to reduce variation and improve efficiency, ultimately leading to cost savings and customer satisfa...read more
Answered by AI
Add your answer
Q4. What are the techniques used in Six Sigma?
Ans. 
Six Sigma techniques include DMAIC, Lean Six Sigma, Root Cause Analysis, and Statistical Process Control.
• DMAIC (Define, Measure, Analyze, Improve, Control) is a structured problem-solving methodology used to improve processes.

• Lean Six Sigma combines Six Sigma methods with Lean manufacturing principles to reduce waste and improve efficiency.

• Root Cause Analysis is a technique used to identify the underlying cause of a pr...read more
Answered by AI
Add your answer
Q5. What is a service level?
Ans. 
A service level is a metric used to measure the performance of a service provider in meeting customer expectations.
• Service level agreements (SLAs) define the expected level of service to be provided

• Service levels are often expressed as a percentage of time that a service is available or delivered within a certain timeframe

• Monitoring and reporting on service levels helps identify areas for improvement

• Example: A service ...read more
Answered by AI
Add your answer
Q6. What are Service Level Agreements (SLAs)?
Ans. 
SLAs are agreements between a service provider and a customer that outline the level of service expected.
• SLAs define the scope, quality, and responsibilities of the service provider.

• They include metrics such as response time, resolution time, and uptime guarantees.

• Penalties may be specified for failing to meet SLA requirements.

• Examples include a web hosting company guaranteeing 99.9% uptime or a call center promising t
Answered by AI
Add your answer
Q7. What automation ideas have you proposed for the current processes?
Ans. 
I have proposed implementing robotic process automation (RPA) for repetitive tasks, using workflow automation tools, and integrating AI for data analysis.
• Proposed implementing robotic process automation (RPA) for repetitive tasks to increase efficiency

• Suggested using workflow automation tools to streamline processes and reduce manual errors

• Recommended integrating AI for data analysis to improve decision-making and fore
Answered by AI
Add your answer
Q8. What is the case study regarding the entry for accrued expenses?
Ans. 
Accrued expenses refer to expenses that have been incurred but not yet paid.
• Accrued expenses are recorded as liabilities on the balance sheet.

• They are typically recognized at the end of an accounting period.

• Examples include accrued salaries, interest, and utilities.

• Accrued expenses are important for accurate financial reporting.
Answered by AI
Add your answer

Basic quant and reasoning questions
Selenium MCQ
Java programs with MCQ

Q1. Tell me about yourself
Add your answer
Q2. Where you initialise driver
Ans. 
The driver is typically initialized in the setup method of a test automation framework.
• Driver initialization is usually done in a setup method before test execution.

• Commonly used methods for driver initialization include WebDriverManager, System.setProperty, and driver instantiation.

• Example: WebDriverManager.chromedriver().setup();
Answered by AI
Add your answer
Q3. Driver is static or non static
Ans. 
Driver can be both static and non-static depending on the context of its usage.
• Driver class can be static if it is used to initiate the WebDriver instance in a test automation framework.

• Driver class can be non-static if it is used as an instance variable within a test class.

• Static driver can be accessed directly without creating an object of the class.

• Non-static driver requires an object of the class to be created befo
Answered by AI
Add your answer
Q4. Difference between static and non static
Ans. 
Static variables belong to the class itself, while non-static variables belong to instances of the class.
• Static variables are shared among all instances of a class

• Non-static variables are unique to each instance of a class

• Static variables are initialized only once, at the start of the program

• Non-static variables are initialized separately for each instance of the class
Answered by AI
Add your answer
Q5. Disadvantages of static and non static
Ans. 
Static and non-static have their own disadvantages in QA automation testing.
• Static methods cannot be overridden or inherited, making it difficult to create flexible test cases.

• Non-static methods require an instance of the class to be created, which can lead to increased memory usage.

• Static methods can lead to tight coupling between classes, making it harder to maintain and update the code.

• Non-static methods may have de...read more
Answered by AI
Add your answer
Q6. Parallel execution in TestNG
Ans. 
TestNG allows parallel execution of test cases to save time and improve efficiency.
• TestNG provides the 'parallel' attribute in the testng.xml file to specify the level of parallelism for test execution.

• Parallel execution can be achieved at the test level, class level, method level, or suite level.

• TestNG also supports parallel execution of tests across multiple classes or suites using the 'parallel' attribute in the sui...read more
Answered by AI
Add your answer
Q7. Write the code for Parallel testing in TestNG
Ans. 
Parallel testing in TestNG allows running tests concurrently for faster execution.
• Use 'parallel' attribute in testng.xml file to specify parallel execution mode.

• Set 'parallel' attribute to 'methods', 'classes', or 'tests' based on the level of parallelism needed.

• Example: <suite name='MySuite' parallel='tests'>

• Use 'thread-count' attribute to specify the number of threads to use for parallel execution.
Answered by AI
Add your answer
Q8. Difference between parallel methods and parallel tests
Ans. 
Parallel methods run multiple methods concurrently within a single test, while parallel tests run multiple tests concurrently.
• Parallel methods execute multiple methods within a single test class concurrently.

• Parallel tests execute multiple test classes concurrently.

• Parallel methods are useful for speeding up the execution of a single test, while parallel tests are useful for running multiple tests faster.

• Example: Runni...read more
Answered by AI
Add your answer
Q9. Upload file using rest assured
Ans. 
Use Rest Assured to upload a file
• Use the given file path to create a File object

• Use MultiPartSpecBuilder to build the request with the file

• Send the request using Rest Assured's given(), when(), and post() methods
Answered by AI
Add your answer
Q10. Postman basic questions
Add your answer
Q11. Parameter for post method in postman
Ans. 
The parameter for a POST method in Postman is typically sent in the request body.
• Parameters are sent in the request body in key-value pairs

• Parameters can be sent as form-data, x-www-form-urlencoded, or raw JSON

• Example: {"key": "value"}
Answered by AI
Add your answer
Q12. BDD Framework cucumber
Add your answer
Q13. Cucumber execution process
Add your answer
Q14. How cucumber know step defination file placed
Ans. 
Cucumber knows the step definition file based on the annotations provided in the feature files.
• Cucumber uses annotations like @Given, @When, @Then to map steps in feature files to corresponding step definition methods.

• Step definition files are typically placed in a separate package or directory within the project structure.

• Cucumber scans the project directory for step definition files based on the package structure and
Answered by AI
Add your answer
Q15. Parameters used in cucumber
Ans. 
Parameters used in cucumber are used to pass values to the step definitions in feature files.
• Parameters are defined in feature files using < > syntax

• Parameters can be passed to step definitions using Regular Expressions

• Parameters can be used to make scenarios more reusable and dynamic
Answered by AI
Add your answer
Q16. Datatable in cucumber
Ans. 
Datatable in Cucumber is used to pass multiple sets of data to a step definition in a scenario.
• Datatables are defined using pipes (|) to separate values

• Each row in the datatable represents a set of data passed to the step definition

• Datatables can be used for parameterization and data-driven testing
Answered by AI
Add your answer
Q17. Have u created the testplan document when porject was started
Ans. 
Yes, I have created the test plan document at the start of the project.
• Yes, I always create a test plan document at the beginning of a project to outline the testing approach and strategy.

• The test plan document includes details on scope, objectives, resources, schedule, and test cases.

• It helps in ensuring that all stakeholders are aligned on the testing process and expectations.

• For example, in my previous project, I cr...read more
Answered by AI
Add your answer
Q18. Testing cycle when project was on initial level
Ans. 
During the initial testing cycle of a project, focus is on establishing test cases, setting up test environments, and identifying potential issues.
• Creating test cases based on requirements

• Setting up test environments

• Identifying potential issues and risks

• Executing test cases and reporting defects

• Collaborating with developers to resolve issues
Answered by AI
Add your answer
Q19. Risk management and risk based testing
Add your answer
Q20. Which estimate technique you follow , if fibonacci then why it is in 1 2 3 5 8 13 ?? Not in 12345678
Ans. 
Fibonacci sequence is a mathematical pattern where each number is the sum of the two preceding ones.
• Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones.

• The sequence starts with 1, 2, then each subsequent number is the sum of the two previous numbers (1+2=3, 2+3=5, 3+5=8, and so on).

• This sequence is used in estimating because it reflects natural growth patterns found in natur
Answered by AI
Add your answer
Q21. What is testing matrix and automation ROI
Ans. 
Testing matrix is a tool used to track test coverage and automation ROI is the return on investment from implementing automation testing.
• Testing matrix is a visual representation of test cases, test scenarios, and their coverage across different platforms, browsers, devices, etc.

• Automation ROI is the measure of the benefits gained from automation testing compared to the costs incurred in implementing and maintaining th...read more
Answered by AI
Add your answer
Q22. Cicd tool
Add your answer
Q23. Handle team ?
Add your answer

Q1. I have 4.6 years experience, 2 years supervisor, middle mail experience in flipkart, 1 year fast mile zepto shift incharge, 8 months FRN, Large flipkart, blue colour. Current time working zepto shift incha...read more
Add your answer
Q2. Do you need employees like us?
Ans. 
Yes, we are always looking for talented and dedicated employees to join our team.
• We are constantly seeking individuals with the right skills and experience to contribute to our organization.

• Having employees like you who are motivated and passionate about their work is essential for our success.

• We value diversity and are committed to creating a supportive and inclusive work environment.

• Examples: We are currently hiring ...read more
Answered by AI
Add your answer
Q3. I have 4.6 years of experience, do you need it?
Ans. 
Yes, your 4.6 years of experience is relevant to the position.
• Your experience can bring valuable skills and knowledge to the role.

• Highlight specific achievements or projects from your 4.6 years of experience.

• Demonstrate how your experience aligns with the requirements of the position.

• Emphasize how your experience can contribute to the success of the team or organization.
Answered by AI
Add your answer
Q4. I pass fast mail and middle mile and last mail rider tema handlein team worki experience do you need it
Add your answer