AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Arcesium Data Analyst Interview Questions and Answers
Arcesium Data Analyst Interview Experiences
5 interviews found
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.
(2 Questions)
- Q1. Python code was asked for checking the anagrams
- Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
(2 Questions)
- Q1. Python code was asked for swaping any number but without using python libraries
- Q2. Sql code was asked using concepts of rank dense,rank, partition by
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic to Intermediate SQL Based questions
- Q2. Basic to Intermediate Python Based questions
Selected
I applied via Indeed and was interviewed in Sep 2024. There were 4 interview rounds.
Hackerra test with sql ,python coding and theory
Sql advanced coding round
Python basic coding test
(1 Question)
- Q1. General discussion
Hard 2 questions in 45 mins
Arcesium interview questions for designations
(1 Question)
- Q1. Wildcard in excel
- Ans.
Wildcard in Excel is a symbol used to represent one or more characters in a search string.
Wildcards include * (asterisk) for multiple characters and ? (question mark) for a single character.
Example: 'te*t' can match 'test' or 'text'.
Wildcards are commonly used in functions like VLOOKUP and SUMIF.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Data Analyst Interview Questions & Answers
Quantiphi Analytics Solutions Private Limited
Anonymous
posted on 19 Nov 2024
I applied via campus placement at Indian Institute of Information Technology, Design and Manufacturing (IIITDM), Jabalpur and was interviewed in May 2024. There were 2 interview rounds.
DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION
(2 Questions)
- Q1. SQL QUESTION FIND N TH HIGHEST SALARY
- Ans.
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
Use ORDER BY clause to sort salaries in descending order
Use LIMIT to specify the Nth highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
- Q2. SQL QUESTION PIVOT TABLE QUESTION
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
SQL and python questions are very easy.
Interview Preparation Tips
(1 Question)
- Q1. Introduce yourself
I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.
Hacker Rank test Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName
(1 Question)
- Q1. SQL or Structured Query Language is a standard language for dealing with relational databases. With the humongous amount of data present, it is very important for us to understand how to use queries to ret...
vikram beerdalai
I applied via Walk-in and was interviewed in Aug 2023. There were 3 interview rounds.
They have asked for HackerRank test which has mix of aptitude and reasoning. And second part has SQL coding comprises of 2 moderate question and 1 has moderate difficult one. I have successfully submitted 2 questions and faced test case failed for the difficult one.
(1 Question)
- Q1. Questions - 1. Order of execution of query. 2. Join and types of join. 3. Group by query. 4. Having vs where. 5. Left join tricky question 6. Self join tricky question. 7. Window function and comparison to...
Interview Preparation Tips
Arcesium Interview FAQs
Tell us how to improve this page.
Arcesium Interviews By Designations
- Arcesium Analyst Interview Questions
- Arcesium Senior Software Engineer Interview Questions
- Arcesium Software Engineer Interview Questions
- Arcesium Data Analyst Interview Questions
- Arcesium Software Developer Intern Interview Questions
- Arcesium Financial Analyst Interview Questions
- Arcesium Junior Analyst Interview Questions
- Arcesium Product Manager 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
- Associate Data Analyst Interview Questions
- Show more
Arcesium Data Analyst Interview Process
based on 5 interviews
1 Interview rounds
- Coding Test Round
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Arcesium Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Analyst
310
salaries
|  ₹7.6 L/yr - ₹20 L/yr |
|
Senior Analyst
310
salaries
| ₹9.5 L/yr - ₹27 L/yr |
|
Senior Software Engineer
226
salaries
| ₹15 L/yr - ₹42 L/yr |
|
Software Engineer
185
salaries
| ₹12 L/yr - ₹33 L/yr |
|
Financial Analyst
150
salaries
| ₹8.5 L/yr - ₹19 L/yr |
Edelweiss
JPMorgan Chase & Co.
Goldman Sachs
Morgan Stanley
- Home >
- Interviews >
- Arcesium Interview Questions >
- Arcesium Data Analyst Interview Questions
