Add office photos
i
Archetive Solutions
Compare
Filter interviews by
Archetive Solutions Analyst Interview Questions and Answers
Archetive Solutions Analyst Interview Experiences
2 interviews found
I applied via Campus Placement and was interviewed in Apr 2022. There were 2 interview rounds.
(1 Question)
- Q1. Weakness and strength Why you want to join Tell me about ur self
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. There a lot of Questions that are asked and the selection process is tough to say the least. Requires good amount of analytical Skills to crack the interview
- Q2. Apart from General HR Questions like What are the weaknesses and Strengths , Future plans are asked
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
1 Question
- Q1. There is a number lock on a bag. It has numbers from 1-8. The lock can open if any 2 of 3 numbers in the bag is correct. You have to open the bag in minimum number of steps
- Ans.
To open the number lock on the bag, you need to try combinations of three numbers, ensuring that at least two of them are correct.
Start by trying the combinations of the first two numbers with each of the remaining six numbers.
If none of these combinations work, move on to the next pair of numbers and repeat the process.
Continue this pattern until you find a combination that opens the lock.
Interview Preparation Tips
Experience: A puzzle was asked first.
I was then given a case study : You own a telecom company. You have various customers. They have joined you 3 years ago,6 months ago and some recently. How do you define who is a good customer?
Round: Other Interview
Experience: It was only for 15 minutes. I was asked a question related to boy girl paradox. Then the job was offered.
Tips: Be cool and try to be less nervous. Do not try to speak about the things that you have no idea about
General Tips: Go to the interview with a cool mind. Take a trusted person with you if you are shortlisted on day 1.
College Name: IIT KANPUR
I applied via Naukri.com and was interviewed in Jan 2024. There were 2 interview rounds.
(1 Question)
- Q1. Basic mathematics question, basic English and SQL questions
(5 Questions)
- Q1. Resume based questions
- Q2. Different types of commands
- Ans.
Different types of commands include data manipulation, data definition, data control, and transaction control commands.
Data manipulation commands: SELECT, INSERT, UPDATE, DELETE
Data definition commands: CREATE, ALTER, DROP
Data control commands: GRANT, REVOKE
Transaction control commands: COMMIT, ROLLBACK, SAVEPOINT
- Q3. Difference between inner join and outer join
- Ans.
Inner join returns only the matching rows between two tables, while outer join returns all rows from both tables.
Inner join only includes rows that have matching values in both tables
Outer join includes all rows from both tables, filling in missing values with NULL if there is no match
Examples: Inner join - SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id; Outer join - SELECT * FROM table1 LEFT OUTER JOI
- Q4. Write SQL query to get second highest salary
- Ans.
SQL query to retrieve the second highest salary from a table
Use the ORDER BY clause to sort salaries in descending order
Use the LIMIT clause to retrieve the second row
- Q5. What's the difference between numpy and pandas
- Ans.
Numpy is a library for numerical operations in Python, while Pandas is used for data manipulation and analysis.
Numpy is used for numerical operations like linear algebra, Fourier transform, etc.
Pandas is used for data manipulation tasks like data cleaning, merging, reshaping, etc.
Numpy works with arrays, while Pandas works with dataframes.
Numpy is more efficient for numerical computations, while Pandas is more user-fri...
Interview Preparation Tips
- SQL
- Python
Skills evaluated in this interview
Selected
I was interviewed in Apr 2023.
Project assigned for creating new website
(2 Questions)
- Q1. Interview with reporting managers virtually
- Q2. About the previous role
(1 Question)
- Q1. HR asked about the previous job and all
Interview Preparation Tips
Business Analyst Interview Questions & Answers
WebMobril Technologies
Anonymous
posted on 4 Sep 2022
I applied via Approached by Company and was interviewed in Mar 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Worst company, they forced employees to take late night calls at 12:00, 2:00,3:00 am after completing 9 office working hours and this is the family business where it has no rules and regulations, no workin...
- Q2. In interview process they did not tell about late night calls that employee has to take and after joining they forced you, even torture you they hold your salary worst company..
(1 Question)
- Q1. 1. Start introduce yourself. Why did you left your last organization
Interview Preparation Tips
Himanshu Sharma
Interview Preparation Tips
Tips: Resume building is the most important of all steps. Keep it concise and to the point.
Round: Test
Experience: Puzzles
Tips: Practice as many puzzles as possible
Round: Stress Interview
Tips: Keep your cool, divert interview towards your strong zones
Round: Technical Interview
Experience: Guesstimates (basic level) and puzzles. Also know your resume and courses well
General Tips: They want to check your thinking, try every problem given in interview. They would have simple solutions.
Skills: Critical Thinking
College Name: IIT DELHI
Motivation: Application of statistics
Interview Questionnaire
1 Question
- Q1. The questions where asked based on the business analyst task and responsibilities.
Interview Preparation Tips
1. Was basic HR round where the HR learned abotmut your working experience .
2. Assignment - basis your position they share you a assignment to understand your knowledge in the relevant area.
3. The round with senior person.
shubham gupta
Interview Questionnaire
7 Questions
- Q1. How to assigning the new task to employees based on their past performance
- Ans.
Assign tasks based on past performance by analyzing employee's strengths and weaknesses.
Analyze employee's past performance data
Identify their strengths and weaknesses
Assign tasks that align with their strengths
Provide training or support for areas of weakness
Regularly review and adjust task assignments based on performance
Consider employee preferences and career goals
- Q2. Some Probability problems
- Q3. Some basic HR questions
- Q4. Write a 10 digit largest number with some constraint (I didn’t remember the exact constraint but it’s a standard question)
- Q5. Guesstimate the number of viewers to a sports blog
- Ans.
Assuming the blog covers popular sports, the number of viewers can range from a few thousand to millions depending on the quality of content and marketing strategies.
Consider the popularity of the sports covered in the blog
Evaluate the quality of content and frequency of updates
Assess the marketing strategies used to promote the blog
Look at the engagement level of the blog's social media accounts
Take into account the c
- Q6. Guesstimate how much a thief, who operate on shopping can earn in a year
- Ans.
A thief operating in shopping can earn anywhere from a few thousand to millions of dollars per year depending on their tactics and location.
The thief's location and the type of stores they target will greatly impact their earnings
Factors such as the thief's level of experience, skill, and risk-taking behavior will also play a role in their earnings
Some thieves may work alone while others may operate in organized groups...
- Q7. The probability of a car passes the highway in a subset time if the probability of a car passing in one hour given
Interview Preparation Tips
Experience: There were 3 Job profiles open of opera solutions (Solution Analyst, Analytics Specialist, and Software Engineer). Students are asked to sign just for one profile. There was a test for analytics and software profile and direct interview for solution profile (Consultant profile).
Tips: Spend enough time before choosing the profiles. Spoke to senior who had a similar job and figure out your best suitable profile and prepare accordingly.
Round: Test
Experience: Opera solution conducts workshop for shortlisted candidates. In the workshop, they mostly tell about technical part behind big data management such as Mainframe and Hadoop. After the workshop, the test was conducted. The test had two sections, the first section contains objective questions around 20-25 (I did not remember the exact number). Objective questions were of aptitude type (moderate level of difficulty). The second section contains 5-6 subjective questions, mainly focus on probability again the moderate level of difficulty. 30 students were shortlisted for next round (interview round).
Tips: Start preparing as early you can. Practice problem daily does not wait for last few day. The main point of practice is to develop a habit of increasing accuracy and speed which is the crucial points of aptitude test.
For probability practice, there are online website and blogs you can take help from them. I have listed down some which are used. You should have some prior practice before setting for test otherwise, it would be difficult to do well in the test as some questions are tricky and difficult to solve in the first time.
For aptitude practice, you can refer TIME material, I think that is sufficient.
-----/
-----.shtml
-----
-----.html
Duration: 60 min minutes
Total Questions: 20+5
Round: Guesstimate Interview
Experience: The interviewer first goes through my resume and ask some basic question, not in depth. Then he asked me some puzzle (similar type of question asked in the subjective paper but with a high level of difficulty) and one guesstimate.
My interview last for 10-15 mins, the interviewer is very helpful and always try to calm and comfort me.
The interviewer gave me feedback and point out some area on which I can quickly look it for further interview.
Tips: I have assigned a buddy, IIT graduate having the same specialization. (Opera solutions follow buddy program similar of other consultant company). I personally found out buddy program very useful, you should contact your buddy or at least talk to him ones. The information you get from a buddy is very helpful of preparing for an interview. You get some aspect on which domain you need to work.
Round: Technical Interview
Experience: Next round was the telephonic interview with a senior analyst. The interviewer asked me some question from my resume especially on the technical project which involves some mathematics tool.
Then he asked some probability problems which are very tough.
Tips: The interviewer was interested in your approach only, how you’re tackling the problem. How much wide can you think? The interviewer is also ready to help you and try to figure out your strength. So be calm and speak with confidence.
Round: Stress Interview
Experience: The interviewer asked me some question from my resume in depth.
He asked one guesstimate and one probability question.
Round: Behavioural Interview
Experience: The interviewer started with questions like why this company, which other companies did I appeared for.
He asked me some quick calculation problems.
General Tips: Resume: Spend sufficient time on the resume as I was the initial step of shortlisting.
You be able to speak at any point in your resume in detail, hence you must be sure of what you are writing in it.
Puzzle: Practice Daily
Guesstimate: Practice with your sincere friends
Skills: Ability To Make Quick Calculations, Puzzle Solving Capability, Knowledge Of Your Resume Points, Guesstimation Cases, Probability And Statistics
College Name: IIT Bombay
Interview Questionnaire
1 Question
- Q1. There is a number lock on a bag. It has numbers from 1-8. The lock can open if any 2 of 3 numbers in the bag is correct. You have to open the bag in minimum number of steps
- Ans.
To open the number lock on the bag, you need to try combinations of three numbers, ensuring that at least two of them are correct.
Start by trying the combinations of the first two numbers with each of the remaining six numbers.
If none of these combinations work, move on to the next pair of numbers and repeat the process.
Continue this pattern until you find a combination that opens the lock.
Interview Preparation Tips
Experience: A puzzle was asked first.
I was then given a case study : You own a telecom company. You have various customers. They have joined you 3 years ago,6 months ago and some recently. How do you define who is a good customer?
Round: Other Interview
Experience: It was only for 15 minutes. I was asked a question related to boy girl paradox. Then the job was offered.
Tips: Be cool and try to be less nervous. Do not try to speak about the things that you have no idea about
General Tips: Go to the interview with a cool mind. Take a trusted person with you if you are shortlisted on day 1.
College Name: IIT KANPUR
Archetive Solutions Interview FAQs
Tell us how to improve this page.
Archetive Solutions Interviews By Designations
Interview Questions for Popular Designations
Analyst Interview Questions from Similar Companies
Archetive Solutions Analyst Reviews and Ratings
based on 22 reviews
Rating in categories
|
Analyst
40
salaries
|  ₹1.8 L/yr - ₹3.8 L/yr |
|
Client Relationship Manager
16
salaries
| ₹4 L/yr - ₹6 L/yr |
|
Client Support Manager
15
salaries
| ₹4.4 L/yr - ₹6 L/yr |
|
Client Relationship Officer
14
salaries
| ₹3 L/yr - ₹6.5 L/yr |
|
Senior Analyst
8
salaries
| ₹2.2 L/yr - ₹4.2 L/yr |
Infosys
TCS
Wipro
HCLTech
- Home >
- Interviews >
- Archetive Solutions Interview Questions >
- Archetive Solutions Analyst Interview Questions
