Coforge

1. Project

1. Can you introduce yourself and explain your day-to-day responsibilities in your current project?
2. What are the Agile ceremonies, and how do they work in your project?

2. Production Support & Ticketing

1. Your resume mentions ticketing. Did you work on production support, or was it a different type of system?
2. Can you explain the ticketing application you worked on in detail?
3. You mentioned it replicated JIRA functionalities — how did you design it, and which JIRA features did you implement?

3. Expression Rule – Hands-On Questions

a) Given 4 dictionaries containing student data (id, name, city), remove students belonging to the city "Pune".

b) Update dictionary data by changing City A to City B.

c) Sort a series of numbers in descending order using the simplest approach.

4. Appian Core Concepts

1. What is the execution difference between Index and Property?
2. Which Appian objects do NOT support security?
3. What are the different types of Groups in Appian?
4. In CDT XSD files, what are the annotations for Primary Key and Auto-Increment?
5. Which objects are NOT deployed to higher environments?

5. Constants & Deployment Scenarios

1. If a constant is manually created in both Dev and Staging, and then deployed, what will happen?
2. How do you check for duplicate objects before deployment?

6. System Design Question

1. If you have an organization of 20 employees and you need to:
2. Send a survey to all employees
3. Track who submitted the survey and their responses
4. How would you design this system in Appian?

7. Process Model Concepts

1. What is MNI and its limitation
2. What is the difference between Spawn New Process and Spawn All Processes?

8. Query & Sync Limits

1. What is the query limit for related records?
2. What is the new Sync limit in Appian?

9. Experience & Platform

1. From which Appian version did you start working?
2. What are the latest features in the current Appian version?

10. Databases & Integrations

1. Which databases are used by default in Appian?
2. Why should we not prefer cloud databases directly in Appian?
3. Which database did you use in your project, why, and how did you connect it?

11. Web APIs & Integrations

1. If an Appian Web API uses a!startProcess, which API methods (GET, POST, etc.) can be used?
2. If a third-party API requires a POST request, which integration method should be used in Appian?

12. Database

1. What is a Database Index, and how does it work?
2. What is a View and a Materialized View?
3. What is the difference between View and Materialized View?
4. Why should we create a Materialized View, and in what cases should we avoid it?

13. Infrastructure

1. Was your project On-Premise or Cloud-based?

14. Experience & Role

1. What is your total experience?
2. What is your exact role and responsibility in your current project?