AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Anblicks
Compare
Filter interviews by
Anblicks Data Analyst Interview Questions and Answers
Anblicks Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.
Coding questions and aptitude questions will be asked
(2 Questions)
- Q1. Explain spark architecture
- Ans.
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
Spark architecture includes a driver program that manages the execution of tasks and interacts with the cluster manager.
Cluster manager allocates resources and schedules tasks on worker nodes.
Worker nodes execute the tasks and return the results to the driver program.
Spark architecture supports f...
- Q2. Explain broadcast joun
- Ans.
Broadcast join is a method used in distributed computing to combine data from multiple sources by broadcasting smaller tables to all nodes.
Broadcast join is commonly used in distributed systems like Apache Spark to improve performance by reducing data shuffling.
It involves broadcasting the smaller table to all nodes in the cluster, so that each node can perform the join operation locally.
This method is efficient when o...
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Complex sql scenarios and their results
- Ans.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
Interview Preparation Tips
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(1 Question)
- Q1. 3rd largest salary from each department(window function)
Interview Preparation Tips
I applied via Company Website and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Self Introduction
- Q2. Salary Expectation
(1 Question)
- Q1. 14 questions in excel formulas
Interview Preparation Tips
Srinivasa moorthy
(1 Question)
- Q1. Explain process in adf
- Ans.
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.
You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.
ADF supports a wide range of d...
Skills evaluated in this interview
Data Engineer Interview Questions & Answers
Saama Technologies
Gautamee Jakinkar
posted on 29 May 2024
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries
(1 Question)
- Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...
Interview Preparation Tips
- SQL
- Python
- Pyspark
(1 Question)
- Q1. Related to data warehouse
(1 Question)
- Q1. Python, data warehouse, data modelling
I appeared for an interview in Sep 2024, where I was asked the following questions.
- Q1. Basic MYSQL queries and questions
- Q2. Python core questions
Selected
I applied via Referral and was interviewed before Feb 2022. There were 3 interview rounds.
2 hr duration test it was. It had the topics like reasoning, number system. Technical section was also there which has sql questions
(11 Questions)
- Q1. Based on my final year project. Some questions based the programming language I added in my resume and other questions asked on sql queries on joins, union, union all difference.
- Q2. Then HR round was there in which asked some behavioral questions and tested some decision making skills
- Q3. Tell me about your final year project is a common question that every interviewer ask for fresher
- Q4. What is inheritance and type of inheritance? if you mentioned c or Java as your skill
- Q5. Tell me about yourself?
- Q6. What are your hobbies?
- Q7. What is your salary expectation.
- Q8. Are you willing to relocate?
- Q9. Are you ready to sign agreement if there is any?
- Q10. Tell me about your family background
- Q11. Is there any for future studies
Interview Preparation Tips
Do not read or practice before 10 mins of your interview.
Practice and research all the possible questions and scenarios before going to an interview
(1 Question)
- Q1. Questions about the tech skills you have
(1 Question)
- Q1. Salary discussion .
Interview Preparation Tips
Anblicks Interview FAQs
Tell us how to improve this page.
Anblicks Interviews By Designations
- Anblicks Data Engineer Interview Questions
- Anblicks Quality Analyst Interview Questions
- Anblicks Software Engineer Interview Questions
- Anblicks QA Lead Interview Questions
- Anblicks Data Analyst Interview Questions
- Anblicks Software Developer Interview Questions
- Anblicks Senior Data Engineer Interview Questions
- Anblicks Power BI Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Data Science Analyst Interview Questions
- Show more
Anblicks Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
|
Data Engineer
55
salaries
|  ₹4.5 L/yr - ₹14.1 L/yr |
|
Software Engineer
23
salaries
| ₹4.7 L/yr - ₹11.8 L/yr |
|
Senior Data Engineer
23
salaries
| ₹19 L/yr - ₹35 L/yr |
|
Junior Data Engineer
22
salaries
| ₹3.7 L/yr - ₹6 L/yr |
|
Senior Software Engineer
20
salaries
| ₹8 L/yr - ₹28 L/yr |
Saama Technologies
Jumio
DISYS
Data-Core Systems
- Home >
- Interviews >
- Anblicks Interview Questions >
- Anblicks Data Analyst Interview Questions
