AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Perficient
Compare
Filter interviews by
Perficient Data Engineer Interview Questions and Answers
Perficient Data Engineer Interview Experiences
3 interviews found
Komal Vanjari
(2 Questions)
- Q1. JOINS , Exception handling
- Q2. Triggers, Cursors , Constraints
Anonymous
(2 Questions)
- Q1. What are the tools I used for the data engineering ?
- Ans.
Tools used for data engineering include ETL tools, programming languages, databases, and cloud platforms.
ETL tools like Apache NiFi, Talend, and Informatica are used for data extraction, transformation, and loading.
Programming languages like Python, Java, and Scala are used for data processing and analysis.
Databases like MySQL, PostgreSQL, and MongoDB are used for storing and managing data.
Cloud platforms like AWS, Azu...
- Q2. Explain the blockers I got while working?
- Ans.
Blockers faced while working as a Data Engineer
Lack of proper documentation
Inadequate infrastructure
Data quality issues
Limited access to necessary data sources
Inefficient data processing pipelines
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. Given que on self join to find Hierarchy of employee
Interview Preparation Tips
- Sql, python, snowlake, adf
Interview questions from similar companies
Selected
I appeared for an interview in Aug 2024.
(2 Questions)
- Q1. How to drop duplicated rows from table
- Ans.
Use the DISTINCT keyword in a SELECT statement to remove duplicate rows from a table.
Use the DISTINCT keyword in a SELECT statement to retrieve unique rows
Use the GROUP BY clause with appropriate columns to remove duplicates
Use the ROW_NUMBER() function to assign a unique row number to each row and then filter out rows with row number greater than 1
- Q2. Big query questions
Skills evaluated in this interview
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
SQL and python questions are very easy.
Interview Preparation Tips
Selected
I appeared for an interview in Aug 2024.
(2 Questions)
- Q1. Big data technologies
- Q2. What is hadoop in big data
- Ans.
Hadoop is an open-source framework used for distributed storage and processing of large data sets across clusters of computers.
Hadoop consists of HDFS (Hadoop Distributed File System) for storage and MapReduce for processing.
It allows for parallel processing of large datasets across multiple nodes in a cluster.
Hadoop is scalable, fault-tolerant, and cost-effective for handling big data.
Popular tools like Apache Hive, A...
Interview Preparation Tips
Skills evaluated in this interview
Akash Gautam
Selected
I applied via Campus Placement and was interviewed before Sep 2023. There were 3 interview rounds.
It was an on campus recruitment drive with questions mostly on basic statistics and algebra.
In round 2 the interviewer asked to explain one of my project and then write code for longest common substring problem.
One Simple coding problem followed with couple of probability questions and explaining the Simple Linear model in detail.
Selected
I appeared for an interview before Dec 2023.
Aptitude test had questions like upstream, downstream, etc
SQL questions and 2 live python coding questions
Anish Bhowmick
It was good and comparatively moderate.
(1 Question)
- Q1. What is indexing in SQl
- Ans.
Indexing in SQL is a technique to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
Indexes are created on columns in a database table to speed up the retrieval of data.
They work similar to the index in a book, allowing the database to quickly find the rows that match a certain value.
Indexes can be created using single or multiple columns.
Examples: CREATE INDEX ind
I applied via Campus Placement and was interviewed in Dec 2024. There were 4 interview rounds.
Two coding questions related to matrices and heaps.
(1 Question)
- Q1. Python and SQL coding
(1 Question)
- Q1. Same questions like tech 1
(2 Questions)
- Q1. Self intro , why tiger
- Q2. Relocation
Interview Preparation Tips
- Python
- SQL
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 Software Engineer Interview Questions
- Perficient Software Developer Interview Questions
- Perficient Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
Perficient Data Engineer Interview Process
based on 2 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
Perficient Data Engineer Reviews and Ratings
based on 7 reviews
Rating in categories
|
Technical Consultant
860
salaries
|  ₹4.2 L/yr - ₹14.9 L/yr |
|
Senior Technical Consultant
440
salaries
| ₹7.1 L/yr - ₹22 L/yr |
|
Associate Technical Consultant
324
salaries
| ₹3.3 L/yr - ₹8.5 L/yr |
|
Technical Leader Consultant
222
salaries
| ₹11.2 L/yr - ₹29 L/yr |
|
Softwaretest Engineer
189
salaries
| ₹4.1 L/yr - ₹9 L/yr |
Xoriant
Photon Interactive
CitiusTech
Iris Software
- Home >
- Interviews >
- Perficient Interview Questions >
- Perficient Data Engineer Interview Questions
