Avise Analytics Interview Questions and Answers

Q1. Project Experience and end to end architecture
Ans. 
I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.
• Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

• Developed applications using AWS SDKs and integrated with other AWS services.

• Performed testing and debugging of applications on AWS infrastructure.

• Deployed applications on AWS using CI/CD pipel...read more
Answered by AI
Add your answer
Q2. PySpark Coding question to Extract Transform & Load
Add your answer
Q3. Cost Optimization on Snowflake
Ans. 
Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.
• Utilize virtual warehouses efficiently based on workload requirements

• Enable auto-suspend to automatically pause warehouses when not in use

• Monitor resource usage and adjust configurations accordingly
Answered by AI
Add your answer

Q1. Project end to end
Add your answer
Q2. How to connect to a share point database
Ans. 
To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.
• Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

• Authenticate using OAuth tokens to access SharePoint resources securely.

• Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

• Ensure proper permissions are set up for the application accessing the Sha
Answered by AI
Add your answer
Q3. Normalization & de normalization
Add your answer
Q4. Questions on SQL Joins
Add your answer
Q5. Question to find the 2nd highest salary using window function
Ans. 
Use window function to find 2nd highest salary in SQL
• Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

• Filter the results where the row number is 2 to get the 2nd highest salary
Answered by AI
Add your answer

Q1. Why are you looking for a job change
Add your answer
Q2. How was the experience at previous company
Add your answer
Q3. Expected CTC at Scatterpie
Ans. 
Expected CTC at Scatterpie
• Research industry standards for AWS Developer roles at Scatterpie

• Consider your experience, skills, and qualifications

• Factor in location, company size, and benefits package

• Negotiate based on market trends and personal value
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer

Q1. What services are you familiar with in Amazon Web Services (AWS)?
Add your answer

Q1. How many projects have you worked on, and which tools have you used?
Add your answer

Q1. Laboratory technician
Add your answer
Q2. Laboratory technician qualified
Add your answer

Q1. Laboratory technician
Add your answer
Q2. Laboratory technician Qualify
Add your answer

Q1. Quality control
Add your answer
Q2. Complete process
Add your answer

Q1. Psi mins full form
Ans. 
PSI stands for Pounds per Square Inch, a unit of pressure measurement commonly used in engineering and physics.
• PSI is used to measure pressure in various systems, such as in pneumatic tools, hydraulic systems, and air compressors.

• 1 PSI is equal to 0.068046 atmospheres or 6,894.76 Pascals.

• For example, a car tire may require inflation to 32 PSI for optimal performance.
Answered by AI
Add your answer
Q2. Firing strocks position
Ans. 
Firing strokes position refers to the position of the firing strokes in an engine.
• Firing strokes position is crucial for the proper functioning of the engine.

• The firing order of the engine determines the position of the firing strokes.

• Incorrect firing strokes position can lead to engine misfires or damage.

• Common firing orders include 1-3-4-2 for a 4-cylinder engine and 1-8-4-3-6-5-7-2 for a V8 engine.
Answered by AI
Add your answer
Q3. How to work hyd.pump
Ans. 
To work a hydraulic pump, you need to understand its components and operation.
• Understand the basic components of a hydraulic pump such as the inlet, outlet, and pistons.

• Ensure the pump is properly connected to a power source and the hydraulic system.

• Monitor the pump's pressure and flow rate to ensure optimal performance.

• Regularly check and maintain the pump to prevent any malfunctions or breakdowns.

• Examples: Gear pump,
Answered by AI
Add your answer
Q4. Injectors leack off test
Add your answer
Q5. How to use torque gun
Ans. 
A torque gun is a tool used to apply torque to fasteners such as nuts and bolts.
• Ensure the torque gun is set to the correct torque value for the fastener being tightened.

• Hold the torque gun perpendicular to the fastener and apply pressure while pulling the trigger.

• Listen for the click or beep indicating the desired torque has been reached.

• Do not over-tighten the fastener as it can cause damage.

• Regularly calibrate and m
Answered by AI
Add your answer

Market size and value of India diagnostics market

Q1. Talk about your previous experience and gave your presentation of the assignment
Add your answer
Q2. Talk about yourself
Ans. 
I am a detail-oriented and analytical individual with a strong background in data analysis and problem-solving.
• Graduated with a degree in Statistics

• Proficient in statistical software such as R and Python

• Experience in analyzing large datasets to derive insights

• Strong communication skills for presenting findings to stakeholders
Answered by AI
Add your answer
Q3. What were your previous projects related custom and syndicate
Ans. 
I have worked on various custom and syndicate projects in my previous roles.
• Led a team in developing a custom market research report for a pharmaceutical company

• Contributed to syndicate reports on consumer behavior trends in the tech industry

• Collaborated with clients to tailor research findings to their specific needs
Answered by AI
Add your answer

Q1. Anatomy questions
Add your answer
Q2. Abrrevation prefix sufix
Add your answer

Q1. What is off page Seo
Ans. 
Off page SEO refers to activities done outside of your website to improve its search engine rankings.
• Building backlinks from reputable websites

• Social media marketing

• Guest blogging on relevant websites

• Online reputation management

• Local SEO strategies
Answered by AI
Add your answer
Q2. What is on page seo
Ans. 
On-page SEO refers to the practice of optimizing individual web pages to rank higher and earn more relevant traffic in search engines.
• Includes optimizing content, meta tags, headings, images, and URLs

• Focuses on improving user experience and relevance

• Helps search engines understand the content of a page and its relevance to users

• Examples: keyword optimization, internal linking, mobile optimization
Answered by AI
Add your answer
Q3. Type of digital marketing
Ans. 
Digital marketing encompasses various online strategies to promote products or services.
• Search engine optimization (SEO) - optimizing website content to rank higher in search engine results

• Social media marketing - using platforms like Facebook, Instagram, and Twitter to engage with audiences

• Email marketing - sending targeted emails to potential customers

• Content marketing - creating and sharing valuable content to attra...read more
Answered by AI
Add your answer

Q1. Types of research, qualitative and quantitative?
Add your answer

Q1. Basic details personal information experience
Add your answer

Write up on topic given by them