I applied in-person. The process took 3 weeks. I interviewed at EPAM Systems (Pune) in Feb 2024
Interview
There are 4 Found Rounds Of Interview.
2 Tech, 1HR and 1 Client. and I had 1 Round as of now.
1st Techinal Would be the Simple for Basic understanding, would like to know the Knowledge about all technology which is Mention in JD and Your Resume.
Interview questions [1]
Question 1
1) Difference Between OLAP and OLTP, Normalization and DeNor, Union and UnionAll,
2) SCD Types
3) ETL PIP line; We will get the data from Source CSV as Table data But we Need a Destination in CSV, No data loading In SQL Server . which transformation do you use?
4) How Will You do Optimization in SQL Querry and StoreProcedure.
2 rounds of interviews: one tech and the other an HR discussion and then an offer discussion. The process was staright forward and did not involve any assessments apart from tech discussions.
Interview questions [1]
Question 1
The questions asked were mostly:
1. What is the difference between this and that : this was the only pattern of mostly questions.
2. Three coding questions were asked sql, python, pyspark
Coding live test by sharing screen in pyspark, python, sql. Total 3 questions from each , 1 pyspark, 1 python, 1 sql questions was asked. Over all it was medium level
Interview questions [1]
Question 1
Coding live test by sharing screen in pyspark, python, sql
3 rounds of interview, with HR, Tech Team and Manager. It was not that difficult. Interview question mainly round experience, tech, problem solving. There is few SQL programming test also
Interview questions [1]
Question 1
Question like how to improve query performance and remove duplicated data
Data Engineer applicants have rated the interview process at EPAM Systems with 3.3 out of 5 (where 5 is the highest level of difficulty) and assessed their interview experience as 60% positive. To compare, the company-average is 59.1% positive. This is according to Glassdoor user ratings.
Candidates applying for Data Engineer roles take an average of 22 days to get hired, when considering 20 user submitted interviews for this role. To compare, the hiring process at EPAM Systems overall takes an average of 23 days.
Common stages of the interview process at EPAM Systems as a Data Engineer according to 20 Glassdoor interviews include:
One on one interview: 23%
Skills test: 20%
Phone interview: 20%
Presentation: 10%
Background check: 10%
Personality test: 7%
Group panel interview: 7%
IQ intelligence test: 3%
Here are the most commonly searched roles for interview reports -