AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Archetype Interview Questions and Answers
Archetype Interview Experiences
2 interviews found
Selected
I applied via Campus Placement and was interviewed in Mar 2024. There were 3 interview rounds.
(4 Questions)
- Q1. Work experience history
- Q2. Tell us about your hobbies
- Ans.
I enjoy playing the guitar, hiking, and trying new recipes in the kitchen.
Playing the guitar: I have been playing for 5 years and enjoy learning new songs.
Hiking: I love exploring nature trails and challenging myself with different terrains.
Trying new recipes: I like experimenting with different cuisines and creating delicious meals.
- Q3. Tell us something about yourself
- Ans.
I am a dedicated and hardworking individual with a passion for problem-solving and helping others.
I have a background in consulting and have worked on various projects in different industries.
I am skilled in data analysis, project management, and client communication.
I am a team player and enjoy collaborating with others to achieve common goals.
- Q4. What did you do at your previous stints?
- Ans.
I worked on various consulting projects, conducting research, analyzing data, and presenting findings to clients.
Conducted market research to identify growth opportunities
Analyzed financial data to make strategic recommendations
Presented findings and recommendations to clients in meetings
(5 Questions)
- Q1. What did your previous work profiles look like?
- Ans.
I have worked in various roles in marketing, sales, and customer service.
Experience in marketing strategies and campaigns
Sales experience in meeting targets and building client relationships
Customer service experience in resolving issues and ensuring customer satisfaction
- Q2. What exactly did you do on each social media platforms?
- Ans.
I managed content creation, engagement, and analytics on various social media platforms.
Created and scheduled posts to maintain a consistent online presence
Engaged with followers by responding to comments and messages
Monitored analytics to track performance and adjust strategies accordingly
- Q3. What was a memorable campaign you worked on?
- Ans.
I worked on a memorable campaign promoting sustainable fashion brands.
Collaborated with eco-friendly fashion brands to create engaging content
Utilized social media platforms to raise awareness about sustainable fashion
Organized a virtual fashion show featuring sustainable clothing lines
- Q4. What was a mistake you remember making?
- Ans.
I once made a mistake in a project by not double-checking the data before presenting it to the client.
I failed to verify the accuracy of the data before sharing it with the client
This led to misinformation being presented and caused confusion
I learned the importance of thorough data validation and double-checking before finalizing deliverables
- Q5. Did you do any reporting?
- Ans.
Yes, I have experience in creating and analyzing reports using various tools and software.
Created weekly sales reports using Excel
Analyzed customer feedback data to identify trends and make recommendations
Used Tableau to visualize data and create interactive dashboards
Make a social media plan for given client.
Interview Preparation Tips
Associate Consultant Interview Questions asked at other Companies
Selected
I applied via Referral and was interviewed before Sep 2022. There were 3 interview rounds.
Plan, a press release, and an article
(2 Questions)
- Q1. What ticks you off?
- Q2. What is your experience?
Consultant Interview Questions asked at other Companies
Top trending discussions
Interview questions from similar companies
I was interviewed in Jan 2025.
(14 Questions)
- Q1. What is the code to read a CSV file into a DataFrame using PySpark?
- Q2. What is your approach to refactoring code?
- Q3. How do you optimize pyspark code, how is peer review done,
- Q4. What is the SQL query to join employee departments along with the count of employees in each department?
- Q5. What is lazy evaluation in PySpark, and can you provide examples to illustrate this concept?
- Q6. How do you write SQL queries using PySpark code?
- Q7. What are the methods used to load data into a database?
- Q8. What is the redshift spectrum?
- Q9. What are the different types of indexing used in databases?
- Q10. Could you describe your experience with sharing your screen to write PySpark code during scenarios in a Teams call, especially when you were using a mobile device?
- Q11. What types of documentation are typically created during a project, and how is this documentation prepared?
- Q12. How do you ensure that your code is written optimally, and how do you evaluate, debug, and test it for various scenarios?
- Q13. What kind of documentation is written for pyspark code
- Q14. What are the best practices that you follow?
Interview Preparation Tips
2. As a data platform architect, the role requires extreme level understanding of pyspark and sql not just overview as in other data architect role.
3. Docu
Selected
I was interviewed in Jan 2025.
(2 Questions)
- Q1. Sale price on on day
- Q2. Start working
Interview Preparation Tips
Key points to remember:
Prioritize networking:
Utilize your network to connect with people in the industry, attend industry events, and leverage platforms like LinkedIn to build relationships with potential hiring managers.
Tailor your resume:
Include relevant sales keywords throughout your resume to catch the attention of recruiters and ensure your experience aligns with the job description.
Practice your sales pitch:
Prepare compelling stories from your past experiences to demonstrate your ability to close deals, overcome objections, and build rapport during interviews.
Follow up consistently:
After submitting applications, send personalized follow-up emails to maintain engagement with potential employers.
Research companies:
Actively monitor companies you're interested in by following their social media and news to stay informed about potential openings.
Highlight transferable skills:
Even if you lack direct sales experience, emphasize skills like communication, persuasion, relationship building, and problem-solving that translate well to a sales role.
Ask insightful questions:
During interviews, demonstrate your knowledge of the company and role by asking thoughtful questions that show your genuine interest.
Be enthusiastic and confident:
Convey a positive attitude and express your passion for sales to make a strong impression on potential employers.
I was interviewed in Jan 2025.
(8 Questions)
- Q1. Self intro and project architecture
- Q2. What are the data sources used?
- Q3. Bigquery architecture
- Q4. Partition vs clustering
- Q5. Bq commands on create table and load csv file
- Q6. Bq commands on show the schema of the table
- Q7. Explain about leaf nodes and columnar storage.
- Q8. How many slots are there in bigquery?
I was interviewed in Jan 2025.
A sequence was provided: 4181, 2684, 1597, 987, 610.
first 2 are given and write code for other value calculation using java 8
The second question required writing a reverse of a palindrome using both Java 8 streams. I was able to successfully write both and clear the first round.
(6 Questions)
- Q1. Interviewer was himself not knowing anything as it was walkin drive he was sitting infront of me and checking questions on phone Introduction that he inturrepted in between when I was introducing myself
- Q2. What are the features of Java 17, specifically related to sealed classes, including their syntax and necessity, along with the potential errors encountered when invoking a sealed class?
- Ans.
Java 17 introduces sealed classes to restrict inheritance and improve code maintainability.
Sealed classes are declared using the 'sealed' keyword followed by the permitted subclasses.
Subclasses of a sealed class must be either final or sealed themselves.
Errors may occur when trying to extend a sealed class with a non-permitted subclass.
- Q3. Java 8 feathers stream api, functional interface, Intermittent operator ,Ternary operator, Prediction,Bi predicate. Answered all successfully
- Q4. Draw low level design of implementation of notify me if item is back in stock in a ecommerce application
- Ans.
Implementation of 'notify me if item is back in stock' feature in an ecommerce application
Create a database table to store user notifications for out-of-stock items
Implement a service to check item availability and send notifications to subscribed users
Provide a user interface for users to subscribe to notifications for specific items
- Q5. All design patterns which I know. Asked me to implement adapter pattern on paper
- Q6. Then given a problem that concurrent way perform operation on excell to decrease the response time
Interview Preparation Tips
(2 Questions)
- Q1. Can you introduce yourself?
- Q2. What is your current Cost to Company (CTC)?
(7 Questions)
- Q1. Tell me about yourself.
- Q2. What is accuracy, and how does it differ from precision?
- Q3. What are the key rules regarding gold investments?
- Q4. What are the different types of accounting statements?
- Q5. What is the concept of depreciation?
- Q6. What is the process of reconciliation?
- Q7. What types of accruals will you post?
Selected
I was interviewed in Jan 2025.
(5 Questions)
- Q1. As per hr question
- Q2. What is your strength
- Q3. Why are you choose this company?
- Q4. After 5 years where you see which position?
- Q5. Why should we hire you?
P2P Accounts Payable Executive Interview Questions & Answers
Accenture
Anonymous
posted on 6 Jan 2025
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
(5 Questions)
- Q1. How many variance in sap?
- Q2. We cac explain the all accounts receivable and accounts payable
- Q3. What is the cost element and cost center?
- Q4. How many we have currencies in sap?
- Q5. How many types of projects
Interview Preparation Tips
- mba fresher
* Identify Your Strengths & Weaknesses:
* Strengths: What are you good at? What do you enjoy doing? What are your unique skills and talents?
* Weaknesses: What areas do you need to improve? What are your biggest challenges?
* Define Your Career Goals:
* Short-term: What kind of job are you looking for? What industry are you interested in? What salary range are you targeting?
* Long-term: What is your ideal career path? What are your long-term professional aspirations?
2. Enhance Your Job Search Strategy
* Build a Strong Online Presence:
* LinkedIn: Create a professional and engaging LinkedIn profile.
* Portfolio/Website: If applicable, showcase your work through a portfolio or personal website.
* Network, Network, Network:
* Attend industry events: Conferences, meetups, and workshops.
* Informational interviews: Connect with people working in your field of interest.
* Leverage your existing network: Let your friends, family, and former colleagues know you're job searching.
* Tailor Your Resume & Cover Letter:
* Customize: Tailor your resume and cover letter to each specific job application.
* Keywords: Use keywords from the job description to increase your chances of getting noticed by Applicant Tracking Systems (ATS).
* Quantify your achievements: Use numbers and data to demonstrate your accomplishments.
* Master the Job Interview:
* Practice: Prepare for common interview questions (behavioral, technical, etc.).
* Research: Learn about the company and the role you're interviewing for.
* Ask insightful questions: Demonstrate your interest and engagement.
3. Continuous Improvement
* Skill Development:
* Online courses: Platforms like Coursera, Udemy, and edX offer a wide range of courses.
* Certifications: Obtain relevant industry certifications to enhance your credentials.
* Volunteer work: Gain valuable experience and build your network.
* Stay Updated:
* Industry news: Keep up-to-date with the latest trends and developments in your field.
* Job market trends: Monitor job boards and industry publications to understand the current job market.
Key Advice:
* Be patient and persistent: The job search process can be challenging, but don't give up.
* Stay positive and maintain a growth mindset: Focus on your strengths and opportunities for improvement.
* Take care of yourself: Prioritize your physical and mental well-being during your job search.
Remember: The job market is constantly evolving. Be adaptable, proactive, and resourceful in your job search efforts. Good luck!
I was interviewed in Aug 2024.
(7 Questions)
- Q1. What is Slowly Changing Dimension (SCD) in Tableau?
- Q2. Difference between historic and current data
- Q3. LODS and types with example
- Q4. Extract and Live Connection
- Q5. What is an empty extract, and what is the process for creating one?
- Q6. Window Functions
- Q7. Context Filter
Archetype Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Analyst Interview Questions
- Software Engineer Interview Questions
- Intern Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Java Developer Interview Questions
- Test Engineer Interview Questions
- Data Analyst Interview Questions
- Senior Software Engineer Interview Questions
- Show more
Archetype Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Archetype Reviews and Ratings
based on 18 reviews
Rating in categories
|
Consultant
21
salaries
|  ₹5 L/yr - ₹13 L/yr |
|
Senior Consultant
13
salaries
| ₹10.1 L/yr - ₹19.3 L/yr |
|
Associate Consultant
11
salaries
| ₹3 L/yr - ₹5.8 L/yr |
|
Senior Accounts Executive
9
salaries
| ₹4.9 L/yr - ₹8.8 L/yr |
|
Senior Executive
9
salaries
| ₹5 L/yr - ₹10 L/yr |
McKinsey & Company
BCG
Bain & Company
Deloitte
- Home >
- Interviews >
- Archetype Interview Questions
