AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
LatentView Analytics Analyst 1 Interview Questions and Answers
LatentView Analytics Analyst 1 Interview Experiences
1 interview found
Anonymous
I applied via Campus Placement and was interviewed before Jul 2022. There were 5 interview rounds.
The test was for 1hr around. Topics: Quantitative Analysis, Verbal, Reasoning, and Basic Programming.
The group discussion was held on the topic of "Is online business a Boon or a Bane? Support or oppose the motion with reasons."
(3 Questions)
- Q1. SQL: 2nd max number from a column stored in a table.
- Ans.
Use SQL query with ORDER BY and LIMIT to find 2nd max number from a column in a table.
Use SELECT MAX(column_name) to find the max number in the column.
Use SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1,1 to find the 2nd max number.
Example: SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1,1;
- Q2. SQL: Select all employees whose employee IDs are odd.
- Ans.
Use SQL query to select employees with odd employee IDs.
Use the modulo operator (%) to check if employee ID is odd (e.g. id % 2 = 1)
Write SQL query like 'SELECT * FROM employees WHERE employee_id % 2 = 1;'
- Q3. SQL: Group all employees by department whose salary is greater than 50,000.
- Ans.
Group employees by department with salary > 50,000 in SQL.
Use GROUP BY clause to group employees by department.
Use WHERE clause to filter employees with salary > 50,000.
Example: SELECT department, COUNT(employee_id) FROM employees WHERE salary > 50000 GROUP BY department;
(1 Question)
- Q1. It had mostly behavioral questions and salary expectations.
Skills evaluated in this interview
Interview questions from similar companies
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
Coding Questions on one of the preffered programming language. Most importantly Data Structures and algorithms.
Interview Preparation Tips
(2 Questions)
- Q1. Profile description and KRA's
- Q2. Joining duration
Create a PPT Deck and write requirements from the case study
(2 Questions)
- Q1. Ambition and Client management skills
- Q2. How do you manage CR's
- Ans.
I manage Change Requests (CRs) by assessing, prioritizing, and communicating effectively with stakeholders.
Assess the impact of the CR on existing processes and systems. For example, evaluate how a new feature affects user experience.
Prioritize CRs based on urgency and business value. For instance, a CR that addresses a critical bug would take precedence over a minor enhancement.
Communicate with stakeholders to gather ...
I applied via Naukri.com and was interviewed in Mar 2023. There were 3 interview rounds.
Case study regarding BA role in Insurance business
(2 Questions)
- Q1. Technical round
- Q2. Quesirons related to Insurance P&C claims process
Interview Questionnaire
1 Question
- Q1. Three to four rounds of interview. 2t and 1m and 1hr round
Selected
I applied via Referral and was interviewed in Jan 2024. There were 3 interview rounds.
3 SQL questions of basic, intermediate and advance level respectively.
(1 Question)
- Q1. Technical Questions related to past work
(1 Question)
- Q1. Salary negotiation and offer.
Interview Preparation Tips
Consultant Interview Questions & Answers
Neudesic Technologies
vivekvardhan Shanigaram
posted on 27 Aug 2024
Selected
I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.
Asked to write Selenium code to launch flipkart and handle the popup that shows up and asked to write code to reverse an entire string later asked reverse each word in that string without reversing the relative order of that string
(1 Question)
- Q1. Basic questions
(1 Question)
- Q1. Technical BA questions
(1 Question)
- Q1. Technical and Functional questions
Interview Preparation Tips
Harshita Rai
(2 Questions)
- Q1. Give an introduction about yourself
- Ans.
Experienced Business Analyst with a background in data analysis and process improvement.
Over 5 years of experience in analyzing business processes and identifying areas for improvement
Skilled in data analysis tools such as Excel, SQL, and Tableau
Strong communication and presentation skills, able to effectively communicate findings to stakeholders
Certified in Business Analysis Professional (CBAP)
Previous projects includ...
- Q2. PAst BA experience in the previous company
- Ans.
I have 3 years of experience as a Business Analyst in my previous company.
Led requirements gathering sessions with stakeholders
Created and maintained documentation such as BRD and FRD
Worked closely with development team to ensure requirements were met
Performed data analysis to identify trends and make recommendations
(2 Questions)
- Q1. Current expectations from this company
- Q2. Listing your strengths and weaknesses
- Ans.
Strengths: Analytical thinker, attention to detail. Weaknesses: Impatient, perfectionist.
Strengths: Analytical thinker - able to break down complex problems into manageable parts
Strengths: Attention to detail - thorough in reviewing and analyzing data
Weaknesses: Impatient - may rush through tasks to get quick results
Weaknesses: Perfectionist - may spend too much time on minor details
(2 Questions)
- Q1. Giving your expected salary
- Q2. Final round of negotiations
Selected
I applied via Naukri.com and was interviewed before Oct 2022. There were 4 interview rounds.
It was a 30 minutes round questions on Python, SQL, Pyspark - scenario based question to write the code.
(4 Questions)
- Q1. Here you will be asked few theoretical question like defination, where to use, what is the advantage etc. - Focused on Azure (ADF,ADLS,Synapse), SQL, Pyspark,python
- Q2. SQL Optimization
- Q3. Dynamic file ingestion in ADF
- Ans.
Dynamic file ingestion in ADF involves using parameters to dynamically load files into Azure Data Factory.
Use parameters to specify the file path and name dynamically
Utilize expressions to dynamically generate file paths
Implement dynamic mapping data flows to handle different file structures
- Q4. Agregation in databricks
- Ans.
Aggregation in Databricks refers to the process of combining and summarizing data in a Spark environment.
Aggregation functions like sum, count, avg, min, max can be used in Databricks to summarize data.
Grouping data based on certain columns and then applying aggregation functions is a common practice.
Aggregation can be performed on large datasets efficiently using Databricks' distributed computing capabilities.
(1 Question)
- Q1. It would be basic HR round to understand your expectation and expertise.
Interview Preparation Tips
Skills evaluated in this interview
LatentView Analytics Interview FAQs
Tell us how to improve this page.
LatentView Analytics Interviews By Designations
- LatentView Analytics Analyst Interview Questions
- LatentView Analytics Data Analyst Interview Questions
- LatentView Analytics Senior Analyst Interview Questions
- LatentView Analytics Data Engineer Interview Questions
- LatentView Analytics Senior Data Engineer Interview Questions
- LatentView Analytics Software Developer Interview Questions
- LatentView Analytics Business Analyst Interview Questions
- LatentView Analytics Senior Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
LatentView Analytics Analyst 1 Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Analyst
333
salaries
|  ₹7.2 L/yr - ₹19 L/yr |
|
Data Analyst
299
salaries
| ₹5 L/yr - ₹11 L/yr |
|
Analyst
244
salaries
| ₹4 L/yr - ₹12.8 L/yr |
|
Assistant Manager
241
salaries
| ₹14 L/yr - ₹27 L/yr |
|
Data Engineer
121
salaries
| ₹5 L/yr - ₹13.8 L/yr |
Tekwissen
Damco Solutions
smartData Enterprises
In Time Tec Visionsoft
- Home >
- Interviews >
- LatentView Analytics Interview Questions >
- LatentView Analytics Analyst 1 Interview Questions
