Note: This interview was collected from an online source.

IQVIA

IQVIA

Senior Appian Developer
SeniorTechnical
Difficulty Level
Medium
Job Type
Remote
A
Anonymous
29 viewsPosted Nov 13, 2025

Questions Asked

  1. What is a View and what is a Materialized View?
  2. What are the key differences between a View and a Materialized View?
  3. Which one is better and in what scenarios would you use each?
  4. What steps would you take to optimize a database view?
  5. Why can indexing sometimes degrade performance instead of improving it?
  6. How can you achieve more than 1000 MNI instances in Appian?
  7. What are the top 3 must-follow process model best practices you strongly believe in?
  8. What is the difference between a Standard End Node and a Terminate Node?
  9. Why does Appian recommend having at least one Terminate Node in every process model?
  10. If you need to implement field-level auditing, how would you design it?
  11. What is a synced record and how is it different from a regular record?
  12. If a query is slow or lagging, how would you approach optimizing it?
  13. How frequently do you run Appian health checks?
  14. If a node is flagged in the health report, what steps would you take to address it?
  15. Explain the locking and unlocking mechanism in Appian.
  16. Which Appian version did you work on most recently?
  17. What are the top 5 Appian features you like the most?
  18. What are inbound and outbound calls in Appian?
  19. What is the difference between PUT, POST, and PATCH?
  20. What were the major challenges you faced in your project and how did you overcome them?
  21. If an Integration node times out, does the node fail or complete with an error message?
  22. What are the best practices for designing performant Appian UIs?
  23. You mentioned local variables should not refresh unnecessarily — how many ways can you control or trigger a local variable refresh in Appian?