OSI Digital Appian Developer Interview Questions and Answers

2 leetcode medium level type problems were given. This was a cut-off test were majority will be cut-off.

Long coding round - Paired with another thoughtworker

Q1. Questions on project
Add your answer
Q2. Frameworks related
Add your answer

Q1. Had Technical Interview
Add your answer

Q1. Discussion with manager
Add your answer

Q1. Had HR discussion one to one
Add your answer

Q1. Select from employees tables all those who don't work in any department.
Add your answer
Q2. What is a cursor and write a query
Ans. 
A cursor is a database object used to retrieve data from a result set one row at a time.
• A cursor is used to iterate through a result set.

• It can be used to update or delete rows in a table.

• Example query: DECLARE cursor_name CURSOR FOR SELECT column1, column2 FROM table_name;

• Example usage: OPEN cursor_name; FETCH NEXT FROM cursor_name INTO @variable1, @variable2;

• Example usage: CLOSE cursor_name; DEALLOCATE cursor_name;
Answered by AI
Add your answer
Q3. How early you can join
Add your answer

Q1. Appian Design Guidance
Add your answer
Q2. Functions and scenarios
Add your answer

Q1. Manager rounds and Agile methodology
Add your answer

Coding test contains 4 coding question easy to medium, Topic Array, String but DSA questions are in image formate first you have to decode the image then code.

Q1. Some question from resume project.
Add your answer
Q2. How we can improve this project
Add your answer
Q3. Add 20% discount code, Implement cashback
Ans. 
To add a 20% discount code and implement cashback in an application.
• Create a discount code field in the application where users can enter the code to avail 20% off.

• Calculate the discounted price by applying the 20% discount on the original price.

• Implement a cashback feature where users receive a certain percentage of the purchase amount back as cashback.

• Ensure that the cashback amount is credited to the user's account
Answered by AI
Add your answer

Online hackerrank test

Q1. Code pairing round
Add your answer
Q2. Solving a problem and improving it
Add your answer

Q1. Question on previous experience
Add your answer

Q1. Basic HR questions
Add your answer

Domain modeling, oops, clean code

Q1. General technical dicussions in resume
Add your answer
Q2. About project we worked on?
Add your answer
Q3. LLD system design question
Add your answer

Q1. Basic dsa questions would be asked
Add your answer