Prepare for and practice interview questions from Appian Corporation.

Appian Corporation Interview Questions

Appian Corporation Interview Guides

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Appian Corporation Salaries by Position

Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we strive for excellence with intensity, and we embrace candid communication. These values guide our actions and shape our culture every day. When you join Appian, you'll be part of a passionate team that's dedicated to accomplishing hard things. Here at Appian, we're passionate about technology. We love making it, and we love using it. Joining Appian will provide you with the opportunity to learn in an environment that values cross-functional collaboration and is committed to personal and professional growth. We want to revolutionize the way people work, and in doing so, we develop the Appian platform to be simple so our customers can thrive. As an experienced software engineer in our Network Security Engineering team, you will design, build, and maintain cloud native network security visibility and governance capabilities that power the prevention, monitoring and response missions. You'll integrate with tooling and automation enabling builders to build better faster and our Security Operations team to conduct increasingly automated security detection and response activities. About the job: <ul><li>Leverage and contribute to a cloud native platform building and maintaining rugged systems governing data flows and investigative use cases.</li><li>Partner with security operations analysts, compliance analysts, and builders at the company to create empathic paved path solutions.</li><li>Tune data processing pipeline performance to be dependable and performant and cost efficient.</li></ul> About you: <ul><li>5+ years of experience as a software engineer working on security minded projects in cloud environments.</li><li>3+ years experience in cloud infrastructure development environments using tools like Terraform or Cloud Formation is a plus</li><li>A tenacious drive to deliver security outcomes</li><li>Experience with AWS Transit Gateway, and Direct Connect</li><li>Knowledgeable in Kubernetes networking technologies such as Cilium or Istio</li><li>Proficiency in Terraform and Golang, Python or Java</li><li>Value data driven decision making</li><li>Strong organizational skills to balance multiple concurrent projects</li><li>Strong written and verbal communication skills that prioritize clarity and empathy for the user.</li><li>Bachelor of Science in Computer science or equivalent experience</li></ul> Tools and Resources <ul><li>Training and Development: During onboarding, we focus on equipping new hires with the skills and knowledge for success through department-specific training. Continuous learning is a central focus at Appian, with dedicated mentorship and the First-Friend program being widely utilized resources for new hires. </li><li>Growth Opportunities: Appian provides a diverse array of growth and development opportunities, including our leadership program tailored for new and aspiring managers, a comprehensive library of specialized department training through Appian University, skills based training, and tuition reimbursement for those aiming to advance their education. This commitment ensures that employees have access to a holistic range of development opportunities.</li><li>Community: We'll immerse you into our community rooted in respect starting on day one. Appian fosters inclusivity through our 8 employee-led affinity groups. These groups help employees build stronger internal and external networks by planning social, educational, and outreach activities to connect with Appianites and larger initiatives throughout the company.</li></ul> About Appian Appian is a software company that automates business processes. The Appian AI-Powered Process Platform includes everything you need to design, automate, and optimize even the most complex processes, from start to finish. The world's most innovative organizations trust Appian to improve their workflows, unify data, and optimize operations-resulting in better growth and superior customer experiences. For more information, visit appian.com. [Nasdaq: APPN] Follow Appian:Twitter, LinkedIn. Appian Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, genetic information, or any other characteristic protected by law. Further, Appian will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co-worker, Pay Transparency Nondiscrimination. Appian provides reasonable accommodations to applicants and employees in accordance with all applicable laws. If you need a reasonable accommodation for any part of the employment process, please contact us by email at ReasonableAccommodations@appian.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address. Appian's Applicant & Candidate Privacy Notice

<h3>Job Description</h3><div>Job Description<div><div>Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we strive for excellence with intensity, and we embrace candid communication. These values guide our actions and shape our culture every day. When you join Appian, you'll be part of a passionate team that's dedicated to accomplishing hard things.</div>Here at Appian, we're passionate about technology. We love making it, and we love using it. Joining Appian will provide you with the opportunity to learn in an environment that values cross-functional collaboration and is committed to personal and professional growth. We want to revolutionize the way people work, and in doing so, we develop the Appian platform to be simple so our customers can thrive. As an experienced software engineer in our Network Security Engineering team, you will design, build, and maintain cloud native network security visibility and governance capabilities that power the prevention, monitoring and response missions. You'll integrate with tooling and automation enabling builders to build better faster and our Security Operations team to conduct increasingly automated security detection and response activities.About the job:<ul><li>Leverage and contribute to a cloud native platform building and maintaining rugged systems governing data flows and investigative use cases. </li><li>Partner with security operations analysts, compliance analysts, and builders at the company to create empathic paved path solutions.</li><li>Tune data processing pipeline performance to be dependable and performant and cost efficient.</li></ul>About you:<ul><li>3+ years of experience as a software engineer working on security minded projects in cloud environments.</li><li>3+ years experience in cloud infrastructure development environments using tools like Terraform or Cloud Formation is a plus</li><li>A tenacious drive to deliver security outcomes</li><li>Experience with AWS Transit Gateway, and Direct Connect</li><li>Knowledgeable in Kubernetes networking technologies such as Cilium or Istio</li><li>Proficiency in Terraform and Golang, Python or Java</li><li>Value data driven decision making</li><li>Strong organizational skills to balance multiple concurrent projects</li><li>Strong written and verbal communication skills that prioritize clarity and empathy for the user.</li><li>Bachelor of Science in Computer science or equivalent experience</li></ul><div>Tools and Resources <ul><li>Training and Development: During onboarding, we focus on equipping new hires with the skills and knowledge for success through department-specific training. Continuous learning is a central focus at Appian, with dedicated mentorship and the First-Friend program being widely utilized resources for new hires. </li><li>Growth Opportunities: Appian provides a diverse array of growth and development opportunities, including our leadership program tailored for new and aspiring managers, a comprehensive library of specialized department training through Appian University, skills based training, and tuition reimbursement for those aiming to advance their education. This commitment ensures that employees have access to a holistic range of development opportunities.</li><li>Community: We'll immerse you into our community rooted in respect starting on day one. Appian fosters inclusivity through our 8 employee-led affinity groups. These groups help employees build stronger internal and external networks by planning social, educational, and outreach activities to connect with Appianites and larger initiatives throughout the company.</li></ul>About AppianAppian is a software company that automates business processes. The Appian AI-Powered Process Platform includes everything you need to design, automate, and optimize even the most complex processes, from start to finish. The world's most innovative organizations trust Appian to improve their workflows, unify data, and optimize operations—resulting in better growth and superior customer experiences. For more information, visit appian.com. [Nasdaq: APPN]Follow Appian: Twitter, LinkedIn.Appian Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, genetic information, or any other characteristic protected by law. Further, Appian will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co‐worker, Pay Transparency Nondiscrimination. Appian provides reasonable accommodations to applicants and employees in accordance with all applicable laws.If you need a reasonable accommodation for any part of the employment process, please contact us by email at ReasonableAccommodations@appian.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.Appian's Applicant & Candidate Privacy Notice </div></div></div>

Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we strive for excellence with intensity, and we embrace candid communication. These values guide our actions and shape our culture every day. When you join Appian, you'll be part of a passionate team that's dedicated to accomplishing hard things. Here at Appian, we're passionate about technology. We love making it, and we love using it. Joining Appian Engineering will provide you with the opportunity to learn in an environment that values cross-functional collaboration and is committed to personal and professional growth. We want to revolutionize the way people work, and in doing so, we develop the Appian platform to be simple so our customers can thrive. As a Product Manager Intern, you'll be embedded as a product owner on a small team of engineers, interacting with key stakeholders, and owning the prioritized product development backlog to ensure your team delivers high-quality software with each and every iteration. Day to day you'll share ideas and receive feedback on features through design sessions, mockups, UX reviews, and usability testing to ensure user success before a new release. Applicants considered for Summer 2025 To be successful in this role, you need: <ul><li>Skillful prioritization to determine what we should build by collaborating with stakeholders on product vision and strategy</li><li>Effective listening and understanding of customer requirements to create stellar experiences that meet what customers want</li><li>Strong communication, negotiation, and collaboration skills; ability to draw clarity out of complex and ever-changing environments</li><li>Strategic thinking and problem solving with a proven ability to prioritize, negotiate, and execute in order to accomplish amazing things</li><li>Imagination, genuine curiosity for candid feedback, and enthusiastic collaboration for building great product features and experiences</li></ul> Some of the tools and resources we will equip you with include: <ul><li>We value innovation and investment in our people by providing opportunities for growth and leadership. Whether it's through Engineering IndieTime (dedicated time to build whatever you want with whomever you want), or annual hackathons, we value activities that inspire others and get creative juices flowing</li><li>Appian has a large engineering team where you are made to feel autonomous by our engineering business group model. Working within an agile team allows our engineers and leaders to have a sense of community and accomplishment</li><li>During your first few weeks of joining Appian, you will not only kick-off your experience with our Intern Orientation Program, but you will also dive into Engineering bootcamp packed with cutting-edge tools and technologies you'll leverage every day.</li></ul> Basic qualifications: <ul><li>A current undergraduate student pursuing a STEM major (Computer Science, Human Computer Interaction, etc)</li></ul> Tools and Resources <ul><li>Training and Development: During onboarding, we focus on equipping new hires with the skills and knowledge for success through department-specific training. Continuous learning is a central focus at Appian, with dedicated mentorship and the First-Friend program being widely utilized resources for new hires. </li><li>Growth Opportunities: Appian provides a diverse array of growth and development opportunities, including our leadership program tailored for new and aspiring managers, a comprehensive library of specialized department training through Appian University, skills based training, and tuition reimbursement for those aiming to advance their education. This commitment ensures that employees have access to a holistic range of development opportunities.</li><li>Community: We'll immerse you into our community rooted in respect starting on day one. Appian fosters inclusivity through our 8 employee-led affinity groups. These groups help employees build stronger internal and external networks by planning social, educational, and outreach activities to connect with Appianites and larger initiatives throughout the company.</li></ul> About Appian Appian is a software company that automates business processes. The Appian AI-Powered Process Platform includes everything you need to design, automate, and optimize even the most complex processes, from start to finish. The world's most innovative organizations trust Appian to improve their workflows, unify data, and optimize operations-resulting in better growth and superior customer experiences. For more information, visit appian.com. [Nasdaq: APPN] Follow Appian:Twitter, LinkedIn. Appian Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, genetic information, or any other characteristic protected by law. Further, Appian will not discriminate against applicants for inquiring about, discussing or disclosing their pay or, in certain circumstances, the pay of their co-worker, Pay Transparency Nondiscrimination. Appian provides reasonable accommodations to applicants and employees in accordance with all applicable laws. If you need a reasonable accommodation for any part of the employment process, please contact us by email at ReasonableAccommodations@appian.com and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address. Appian's Applicant & Candidate Privacy Notice

Here at Appian, our core values of Respect, Work to Impact, Ambition, and Constructive Dissent & Resolution define who we are. In short, this means we constantly seek to understand the best for our customers, we go beyond completion in our work, we s Product Manager, Manager, Intern, Product Development, Engineer, Product Owner, Technology, Business Services

Appian Corporation Interview Questions

Appian Corporation Interview Guides

Appian Corporation Interview Questions

Appian Corporation Salaries by Position

Appian Corporation Opening Jobs