i
Perficient
Compare
Filter interviews by
Perficient Technical Consultant Interview Questions and Answers
Perficient Technical Consultant Interview Experiences
11 interviews found
Anonymous
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
Selected
I applied via Campus Placement and was interviewed before Jan 2024. There were 4 interview rounds.
The assessment involved multiple sections, including aptitude, reasoning, English, and programming questions.
(1 Question)
- Q1. The first round questions involved these topics Java basics, oops concepts, syntax, code for polymorphism etc
(1 Question)
- Q1. What advanced Java topics, such as collections, multi-threading, and garbage collection, were discussed during your interview, and what specific logic and syntax questions were asked
(1 Question)
- Q1. Basic questions were asked during the interview, such as your self-introduction etc
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed in Mar 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Questions about spark Questions about python
- Q2. Questions about sql
Selected
I applied via Campus Placement and was interviewed before Jun 2023. There were 2 interview rounds.
General questions were asked
(2 Questions)
- Q1. Python related coding questions
- Q2. SQL queries were asked
Interview Preparation Tips
Perficient interview questions for designations
I applied via Naukri.com and was interviewed in Jun 2022. There were 4 interview rounds.
(1 Question)
- Q1. Technical round related to the profile which you are hiring for ..I was interviewed for Aws engineer and it went for 45min and i cleared
(1 Question)
- Q1. After cleared the technical round i had a discussion with company's director
(1 Question)
- Q1. Again i was interviewed with one of the company's director and got information regarding project details and my responsibilities
(1 Question)
- Q1. Normal discussion with HR round regarding compensation
Interview Preparation Tips
I applied via Referral and was interviewed in Feb 2022. There was 1 interview round.
(2 Questions)
- Q1. Puerly technical questions
- Q2. Go through top 100 questions from website
Interview Preparation Tips
- Magento
Selected
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
Got tested on the basics concepts and few programming we asked to do.
I applied via Naukri.com and was interviewed in Aug 2021. There were 4 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Database DML Operations and asked to write down some queries
- Q2. 4-5 ques from python, spark, pandas dataframes.
- Q3. Hive data ingestion, meta stores, linux basics ,hdfs
- Q4. Previous project experience and data flow architecture
Interview Preparation Tips
panel and myself were in good sync and questions were also asked
I applied via Naukri.com and was interviewed in Mar 2021. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. I was interviewed for Angular UI developer. Technical and Managerial round was easy.
- Q2. What is Rxjs, Subscriber, Observable, folkJoins?
- Ans.
Rxjs is a library for reactive programming using Observables and Subscribers. forkJoins is a method for combining Observables.
Rxjs is a library for reactive programming that allows you to work with asynchronous data streams.
Observables are the source of data streams that can emit values over time.
Subscribers are the consumers of these data streams that can subscribe to Observables and receive emitted values.
forkJoins i...
- Q3. Basics on Array Manipulation, HTML5, CSS3?
Interview Preparation Tips
Skills evaluated in this interview
I applied via Job Portal and was interviewed before Jan 2021. There were 3 interview rounds.
(1 Question)
- Q1. All basics about resume mentioned skilss and practical implementation and experience about latest technologies
(1 Question)
- Q1. Project knowledge and practical architecturally level questions
(4 Questions)
- Q1. Share details of your previous job.
- Q2. What are your salary expectations?
- Q3. What is your family background?
- Q4. All about previous org. and reason for leaving
Interview Preparation Tips
If you good at technically, interview will be easy to crack
What people are saying about Perficient
Perficient Interview FAQs
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 Associate Software Engineer Interview Questions
- Perficient AWS Devops Engineer Interview Questions
- Perficient Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Technical Lead Interview Questions
- Technical Specialist Interview Questions
- Member Technical Staff Interview Questions
- Technical Analyst Interview Questions
- Technical Architect Interview Questions
- Senior Technical Lead Interview Questions
- Associate Technical Consultant Interview Questions
- Technical Project Manager Interview Questions
- Show more
Perficient Technical Consultant Interview Process
based on 8 interviews
2 Interview rounds
- Technical Round - 1
- Technical Round - 2
Technical Consultant Interview Questions from Similar Companies
Fast track your campus placements
Perficient Technical Consultant Reviews and Ratings
based on 92 reviews
Rating in categories
|
Technical Consultant
818
salaries
|  ₹4.3 L/yr - ₹14.9 L/yr |
|
Senior Technical Consultant
425
salaries
| ₹7.1 L/yr - ₹21 L/yr |
|
Associate Technical Consultant
334
salaries
| ₹3.3 L/yr - ₹8.1 L/yr |
|
Technical Leader Consultant
213
salaries
| ₹11.2 L/yr - ₹30 L/yr |
|
Softwaretest Engineer
183
salaries
| ₹4.1 L/yr - ₹9 L/yr |
Cognizant
TCS
Infosys
Wipro
- Home >
- Interviews >
- Perficient Interview Questions >
- Perficient Technical Consultant Interview Questions
