AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Perficient
Work with us 
Compare
Filter interviews by
Perficient Interview Questions and Answers
23 Interview questions
CF (Content Fragment) and XF (Experience Fragment) are both AEM components for managing content but serve different purposes.
CF (Content Fragment) is used for managing structured content that can be reused across different pages.
XF (Experience Fragment) is designed for managing a combination of content and layout, allowing for reusable sections of a page.
Example of CF: A product description that can be used in mul...
Extend an AEM core component by adding fields while maintaining backward compatibility.
Identify the core component to extend, e.g., 'cq/components/content/image'.
Create a new component in your project, e.g., 'myproject/components/content/image'.
Use the Sling Resource Merger to inherit properties from the core component.
Add new fields in the dialog of your custom component using the same field types.
Ensure backward...
JCR stands for Java Content Repository, a hierarchical database used in Adobe Experience Manager (AEM) to store content.
JCR is used in AEM to store content in a hierarchical structure.
It allows for versioning, access control, and searching of content.
Nodes and properties are used to represent content in JCR.
Example: /content/mysite/homepage is a node in JCR representing the homepage of a website.
Promises are used in JavaScript to handle asynchronous operations and avoid callback hell.
Promises are used to handle asynchronous operations in a more readable and manageable way.
They help avoid callback hell by chaining multiple asynchronous operations together.
Promises can be in one of three states: pending, fulfilled, or rejected.
They allow for better error handling with the use of .catch() method.
Promises can...
Modules in AEM are reusable components that can be used to build web pages and applications.
Modules in AEM are reusable components that can be used to build web pages and applications.
They help in organizing and structuring content in AEM.
Modules can be created using Adobe Experience Manager's component framework.
Examples of modules in AEM include header, footer, carousel, and navigation components.
One challenging BiP query involved optimizing a complex join operation to improve performance.
Used subqueries to filter data before joining
Utilized indexing to speed up the join operation
Implemented query optimization techniques like query hints
Object-oriented programming paradigm that focuses on objects and classes
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
HTML and CSS are the building blocks of web development. HTML is used for structuring content, while CSS is used for styling and layout.
HTML stands for HyperText Markup Language and is used to create the structure of a webpage.
CSS stands for Cascading Style Sheets and is used to style the HTML elements on a webpage.
HTML uses tags to define different elements like headings, paragraphs, images, links, etc.
CSS allows...
Enum is a data type in programming that consists of a set of named constants.
Enums are used to define a set of named constants, making the code more readable and maintainable.
Enums can be used to represent a fixed number of possible values for a variable.
Enums can also be used to improve type safety by restricting the possible values that a variable can hold.
Example: enum Color { RED, GREEN, BLUE }
Rank assigns unique numbers to rows based on order of values, while dense rank assigns consecutive numbers without gaps.
Rank leaves gaps in ranking sequence if there are ties, while dense rank does not
Rank assigns the same rank to tied values, while dense rank assigns consecutive ranks
Example: Rank - 1, 2, 3, 4, 4, 6; Dense Rank - 1, 2, 3, 4, 4, 5
Perficient Interview Experiences
42 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. SQL query duplicate records
- Ans.
Identify and retrieve duplicate records in a SQL database using GROUP BY and HAVING clauses.
Use GROUP BY to group records by the columns that define duplicates.
Apply HAVING COUNT(*) > 1 to filter groups with more than one record.
Example: SELECT column1, COUNT(*) FROM table_name GROUP BY column1 HAVING COUNT(*) > 1;
To see all columns of duplicate records, use a JOIN with the subquery.
Example: SELECT * FROM table_n...
- Q2. Rank vs dense rank
- Ans.
Rank and dense rank are used to assign a rank to each row in a result set based on the values in a specific column.
Rank assigns unique ranks to each row, with gaps in the ranking sequence if there are ties.
Dense rank assigns unique ranks to each row, with no gaps in the ranking sequence if there are ties.
Rank and dense rank are commonly used in data analysis and reporting to identify top performers or outliers.
Example:...
- Q3. Query of set operator
- Q4. Types of Scd
- Ans.
SCD stands for Slowly Changing Dimensions. There are three types of SCD: Type 1, Type 2, and Type 3.
Type 1: Overwrite the old data with new data.
Type 2: Create a new record for the new data and keep the old record.
Type 3: Create a new column for the new data and keep the old column.
- Q5. About project
Interview Preparation Tips
Skills evaluated in this interview
Komal Vanjari
(2 Questions)
- Q1. JOINS , Exception handling
- Q2. Triggers, Cursors , Constraints
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about yourself
- Q2. Where u see yourself in next 5 years
(2 Questions)
- Q1. It was an assessment of 50 questions (MCQ)
- Q2. Topics - matlab, tensors
(2 Questions)
- Q1. What are promises used for
- Ans.
Promises are used in JavaScript to handle asynchronous operations and avoid callback hell.
Promises are used to handle asynchronous operations in a more readable and manageable way.
They help avoid callback hell by chaining multiple asynchronous operations together.
Promises can be in one of three states: pending, fulfilled, or rejected.
They allow for better error handling with the use of .catch() method.
Promises can be c...
- Q2. What are modules in AEM
- Ans.
Modules in AEM are reusable components that can be used to build web pages and applications.
Modules in AEM are reusable components that can be used to build web pages and applications.
They help in organizing and structuring content in AEM.
Modules can be created using Adobe Experience Manager's component framework.
Examples of modules in AEM include header, footer, carousel, and navigation components.
(2 Questions)
- Q1. A significant challenge
- Ans.
One significant challenge I faced was optimizing website performance for mobile devices.
Implemented lazy loading for images to improve loading times
Minified CSS and JavaScript files to reduce file sizes
Utilized media queries to ensure responsive design across different screen sizes
- Q2. What are jcr in AEM
- Ans.
JCR stands for Java Content Repository, a hierarchical database used in Adobe Experience Manager (AEM) to store content.
JCR is used in AEM to store content in a hierarchical structure.
It allows for versioning, access control, and searching of content.
Nodes and properties are used to represent content in JCR.
Example: /content/mysite/homepage is a node in JCR representing the homepage of a website.
Skills evaluated in this interview
Selected
(2 Questions)
- Q1. Challenging Bip queries you have written till now. Explain it
- Ans.
One challenging BiP query involved optimizing a complex join operation to improve performance.
Used subqueries to filter data before joining
Utilized indexing to speed up the join operation
Implemented query optimization techniques like query hints
- Q2. Data set links in data model
- Ans.
Data set links in data model refer to relationships between different data sets in a structured manner.
Data set links help establish connections between different data sets for efficient data retrieval and analysis.
Examples include foreign keys linking tables in a relational database, or relationships between entities in a data model.
Data set links ensure data integrity and consistency across the data model.
(1 Question)
- Q1. It was Good. Just normal
(1 Question)
- Q1. Normal human resource questions
Skills evaluated in this interview
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Ansible, terraform, docker, kubernetes.
- Q2. Scenario based questions
Interview Preparation Tips
30 aptitute question
(3 Questions)
- Q1. Concept of oops
- Ans.
Object-oriented programming paradigm that focuses on objects and classes
Encapsulation: bundling data and methods that operate on the data into a single unit
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
- Q2. Swaping of 2 numbers
- Ans.
Swapping of 2 numbers involves exchanging the values of two variables.
Create a temporary variable to store one of the numbers
Assign the value of the first number to the second number
Assign the value of the temporary variable to the first number
- Q3. What is html and css
- Ans.
HTML and CSS are the building blocks of web development. HTML is used for structuring content, while CSS is used for styling and layout.
HTML stands for HyperText Markup Language and is used to create the structure of a webpage.
CSS stands for Cascading Style Sheets and is used to style the HTML elements on a webpage.
HTML uses tags to define different elements like headings, paragraphs, images, links, etc.
CSS allows for ...
(1 Question)
- Q1. How soon you can join
- Ans.
I can join within 2 weeks of receiving an offer.
I have a 2-week notice period at my current job.
I am available to start immediately after that.
I can provide any necessary documentation quickly.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Apr 2024. There were 4 interview rounds.
(1 Question)
- Q1. Roles and responsibilities
(1 Question)
- Q1. About roles and responsibilities
(1 Question)
- Q1. Dive into technical
(1 Question)
- Q1. About company and package discussion
(2 Questions)
- Q1. Basics of all concepts in role
- Q2. Project details and your role
- Ans.
Led a team to develop a cloud-based inventory management system for a retail client, enhancing efficiency and reducing costs.
Conducted requirements gathering sessions with stakeholders to understand their needs.
Designed the system architecture using microservices to ensure scalability.
Implemented RESTful APIs for seamless integration with existing systems.
Collaborated with the QA team to establish testing protocols, en...
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed in Feb 2024. There were 3 interview rounds.
(1 Question)
- Q1. How to establish connection to DB through Spark? Read data from 2 tables, transform and write back to a table in DB Lot of sql stuffs
(1 Question)
- Q1. Spark Architecture Broadcast variable Rank, Dense rank and row number difference Scrum process
(1 Question)
- Q1. Evaluation on my leadership skills and personality Write and explain complete architecture in which I am currently working Team handling skills and professional challenges
Rohit Vr
(2 Questions)
- Q1. Resume discussion
- Q2. General questions about tableau and python
Top trending discussions
Perficient Interview FAQs
Some of the top questions asked at the Perficient interview -
The duration of Perficient interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Perficient Interviews By Designations
- Perficient Technical Consultant Interview Questions
- Perficient Senior Technical Consultant Interview Questions
- Perficient Associate Technical Consultant Interview Questions
- Perficient Data Engineer Interview Questions
- Perficient Data Analyst Interview Questions
- Perficient Software Engineer Interview Questions
- Perficient Software Developer Interview Questions
- Perficient Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Technical Consultant Interview Questions
- Senior Technical Consultant Interview Questions
- Analyst Interview Questions
- Intern Interview Questions
- Business Analyst Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Data Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 41 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Perficient Reviews and Ratings
based on 523 reviews
Rating in categories
|
Technical Consultant
913
salaries
|  ₹7.5 L/yr - ₹14 L/yr |
|
Senior Technical Consultant
460
salaries
| ₹12 L/yr - ₹22 L/yr |
|
Associate Technical Consultant
346
salaries
| ₹3.9 L/yr - ₹8 L/yr |
|
Technical Leader Consultant
234
salaries
| ₹18.5 L/yr - ₹31 L/yr |
|
Softwaretest Engineer
206
salaries
| ₹4.1 L/yr - ₹8 L/yr |
Xoriant
Photon Interactive
CitiusTech
Iris Software
- Home >
- Interviews >
- Perficient Interview Questions
