Acquia Senior Software Engineer Interview Questions and Answers

Q1. Form based JS questions. String questions in javascript
Add your answer
Q2. React interview questions with some state management follow up questions.
Add your answer

Q1. Sql question, joins , store procedure
Add your answer
Q2. Mvc question, mvc frame work
Add your answer

Q1. SQL query to join 3 tables
Ans. 
Use SQL JOIN to combine data from 3 tables based on a common key.
• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition
Answered by AI
Add your answer
Q2. Spring boot annotations
Add your answer
Q3. Hibernate annotations
Add your answer
Q4. Java 8 Streams + Lambda
Add your answer

Q1. Working style: Independent contributor or Team
Add your answer
Q2. Are green-field projects alright?
Ans. 
Green-field projects are great opportunities to start fresh and implement new technologies.
• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch
Answered by AI
Add your answer
Q3. Are you ok with learning new tech stacks?
Add your answer

Q1. About the project. and asked what i did in project. how to create schema in pyspark. what is ADE. what are the difficulties i faced in project. what is spark submit command how we write sparksubmit command...read more
Add your answer
Q2. No of occurrences of letter in a string.
Ans. 
Count occurrences of a letter in a string.
• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.
Answered by AI
Add your answer

Covered OOP fundamentals and Java

Q1. Tell me about yourself.
Add your answer