AmbitionBox
Search
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Alchemy Innovators Interview Questions and Answers
Updated
15 Sep 2024
Alchemy Innovators Interview Experiences
1 interview found
Interview experience
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected
I applied via Company Website and was interviewed before Sep 2023. There was 1 interview round.
Round 1 - Technical
(3 Questions)
- Q1. What are the learning your courses?
- Q2. How many types of sublanguages in SQL Server?
- Ans.
There are four types of sublanguages in SQL Server: Data Query Language (DQL), Data Definition Language (DDL), Data Control Language (DCL), and Transaction Control Language (TCL).
Data Query Language (DQL) is used to retrieve data from the database. Example: SELECT statement.
Data Definition Language (DDL) is used to define the structure of the database. Example: CREATE TABLE statement.
Data Control Language (DCL) is used...
- Q3. What are the commands in SQL Server?
- Ans.
SQL Server commands are used to interact with databases, perform operations like querying, updating, and managing data.
SELECT - retrieves data from a database
INSERT - adds new records to a table
UPDATE - modifies existing records in a table
DELETE - removes records from a table
CREATE DATABASE - creates a new database
CREATE TABLE - creates a new table in a database
ALTER TABLE - modifies an existing table structure
DROP DAT...
Add your answer
Answered by
AI
Add your answer
Answered by
AI
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Firstly i am very satisfied in fresher point of interview, after that different scenarios and queries, But totally it is good.
Skills evaluated in this interview
Software Engineer Interview Questions asked at other Companies
Q1. Bridge and torch problem : Four people come to a river in the night. There is a narrow bridge, but it can only hold two people at a time. They have one torch and, because it's night, the torch has to be used when crossing the bridge. Person...
read more
View answer
(180)
Top trending discussions
View All
Interview Tips & Stories
5d
zestyrose
·
works at
Infosys
Tips for getting interview call in naukri
I have 3 yoe in sap basis am currently preparing for interview. And also started to apply for jobs in naukri and indeed almost 30-45 application applied but not got even single interview call. Any tips pls😪. Lost hopes. Thanks in advance ❤
Got a question about Alchemy Innovators?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - Technical
(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?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. The role would have client round and the candidate will have to write code and solve issues immediately in client interview call, this is what interviewer said
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
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
Interview experience
Excellent
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Selected
I was interviewed in Jan 2025.
Round 1 - One-on-one
(2 Questions)
- Q1. Sale price on on day
- Q2. Start working
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Fofocus heavily on networking, tailoring your resume with relevant keywords, actively following up with potential employers, showcasing your sales skills in interviews through storytelling, and monitoring companies you're interested in to stay updated on opportunities.
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.
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.
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
I was interviewed in Jan 2025.
Round 1 - Technical
(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?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Jan 2025.
Round 1 - Coding Test
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.
Round 2 - Technical
(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
Add your answer
Answered by
AI
Add your answer
Add your answer
Answered by
AI
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I always suggest staying away from these companies commonly referred to as WITCH (Wipro, Infosys, TCS, Cognizant, HCL). You will rarely encounter good interviewers there unless there is an extreme necessity. Interview was judging me on the basis of syntex by seeing in his phone. How can everyone write each and everything on copy. For the low level design first time in my 6 years carrier someone asked to design without using kafka or any other library like spring boot to achieve that add in reminder list problem 😂. At first it was my bad after holding a offer of almost 27 lakh I somehow agreed for giving interview. Second thing I also know that after Even clearing they cannot afford 30LPA which I asked. I just went there because from last 6.5 year I have never attended any walking or face to face interview so was curious for it. Currently also working with somewhat premium product development company only. My experience was very bad. May be it can get vary person to person.
Interview experience
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR
(2 Questions)
- Q1. Can you introduce yourself?
- Q2. What is your current Cost to Company (CTC)?
Add your answer
Add your answer
Round 2 - Technical
(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?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I was interviewed in Jan 2025.
Round 1 - One-on-one
(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?
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
P2P Accounts Payable Executive Interview Questions & Answers
Accenture
Anonymous
posted on 6 Jan 2025
Interview experience
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
Round 1 - One-on-one
(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
View 1 more answer
View 2 more answers
View 2 more answers
View 1 more answer
View 1 more answer
Interview Preparation Tips
Topics to prepare for Accenture P2P Accounts Payable Executive interview:
* 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!
- 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!
Interview experience
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected
I was interviewed in Jan 2025.
Round 1 - One-on-one
(5 Questions)
- Q1. Introduce your self
- Q2. What are your hobbies
- Q3. Explain your family background
- Q4. Explain your education background
- Q5. Extreme your native place
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I am fresher l am no idea
Interview experience
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Aug 2024.
Round 1 - Technical
(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
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Add your answer
Alchemy Innovators Interview FAQs
How many rounds are there in Alchemy Innovators interview?
Alchemy Innovators interview process usually has 1 rounds. The most common rounds in the Alchemy Innovators interview process are Technical.
Tell us how to improve this page.
Interview Questions for Popular Designations
- Executive Interview Questions
- Software Developer Interview Questions
- Intern Interview Questions
- Business Analyst Interview Questions
- Sales Executive Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Associate Software Engineer Interview Questions
- System Engineer Interview Questions
- Show more
Alchemy Innovators Interview Process
based on 1 interview
Interview experience
View more
Interview Questions from Similar Companies
Alchemy Innovators Reviews and Ratings
based on 2 reviews
Rating in categories
|
Software Engineer
6
salaries
|  ₹5 L/yr - ₹12 L/yr |
|
Salesforce Developer
5
salaries
| ₹4 L/yr - ₹9.5 L/yr |
|
Devops Engineer
4
salaries
| ₹4.5 L/yr - ₹8 L/yr |
|
Software Developer
3
salaries
| ₹3 L/yr - ₹11 L/yr |
|
Associate Consultant
3
salaries
| ₹4.3 L/yr - ₹6 L/yr |
Explore more salaries
Compare Alchemy Innovators with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Popular Calculators
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Alchemy Innovators Interview Questions
Share an Interview