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
Top trending discussions
Interview questions from similar companies
Bhupendra Sonwane
Selected
I was interviewed in Oct 2024.
(2 Questions)
- Q1. SQL problem window function
- Q2. SQL code like join and scenerio
(2 Questions)
- Q1. Design round for adf pipeline
- Ans.
Designing an ADF pipeline for data processing
Identify data sources and destinations
Define data transformations and processing steps
Consider scheduling and monitoring requirements
Utilize ADF activities like Copy Data, Data Flow, and Databricks
Implement error handling and logging mechanisms
- Q2. Azure synapses and adf adb
(2 Questions)
- Q1. Expected ctc and current ctc negotiations
- Ans.
Discussing expected and current salary for negotiation purposes.
Be honest about your current salary and provide a realistic expectation for your desired salary.
Highlight your skills and experience that justify your desired salary.
Be open to negotiation and willing to discuss other benefits besides salary.
Research industry standards and salary ranges for similar positions to support your negotiation.
Focus on the value y...
- Q2. Relocation and remote work until ofc open for Pune location
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Azure Scenario based questions
- Q2. Pyspark Coding based questions
(2 Questions)
- Q1. ADF, Databricks related question
- Q2. Spark Performance problem and scenarios
- Ans.
Spark performance problems can arise due to inefficient code, data skew, resource constraints, and improper configuration.
Inefficient code can lead to slow performance, such as using collect() on large datasets.
Data skew can cause uneven distribution of data across partitions, impacting processing time.
Resource constraints like insufficient memory or CPU can result in slow Spark jobs.
Improper configuration settings, su...
Skills evaluated in this interview
I applied via Campus Placement
Based on SQL , statistics , python , cognitive
(2 Questions)
- Q1. Based on AI/Ml and based on cv
- Q2. Based on projects
(2 Questions)
- Q1. How to handle toxic work culture?
- Ans.
Address toxic work culture by open communication, setting boundaries, seeking support, and considering leaving if necessary.
Open communication with colleagues and management about issues
Set boundaries to protect your mental and emotional well-being
Seek support from HR, a mentor, or a therapist if needed
Consider leaving the toxic work environment if the situation does not improve
- Q2. 5 strength and weakness
Interview Preparation Tips
(2 Questions)
- Q1. SCD questions. Iceberg questions
- Q2. Basic python programing, pyspark architechture.
(1 Question)
- Q1. Spark basic question , hive related questions.
Interview Preparation Tips
I was interviewed in Aug 2024.
(5 Questions)
- Q1. Questions on Pyspark
- Q2. Questions on SQL
- Q3. Transformations
- Q4. Questions on Sql optimizations
- Q5. Questions About my current Project
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. Incremental load in pyspark
- Ans.
Incremental load in pyspark refers to loading only new or updated data into a dataset without reloading the entire dataset.
Use the 'delta' function in pyspark to perform incremental loads by specifying the 'mergeSchema' option.
Utilize the 'partitionBy' function to optimize incremental loads by partitioning the data based on specific columns.
Implement a logic to identify new or updated records based on timestamps or uni...
- Q2. Drop duplicates
Skills evaluated in this interview
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 AEM Developer Interview Questions
- Perficient Associate Software Engineer Interview Questions
- Perficient AWS Devops 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
840
salaries
|  ₹4.8 L/yr - ₹14.9 L/yr |
|
Senior Technical Consultant
430
salaries
| ₹7.1 L/yr - ₹21 L/yr |
|
Associate Technical Consultant
320
salaries
| ₹3.3 L/yr - ₹8 L/yr |
|
Technical Leader Consultant
207
salaries
| ₹11 L/yr - ₹29 L/yr |
|
Softwaretest Engineer
187
salaries
| ₹3.2 L/yr - ₹8.1 L/yr |
Cognizant
TCS
Infosys
Wipro
- Home >
- Interviews >
- Perficient Interview Questions >
- Perficient Data Engineer Interview Questions
