Premium Employer

i

This company page is being actively managed by Perficient Team. If you also belong to the team, you can get access from here

Perficient Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Perficient ETL Tester Interview Questions and Answers

Updated 11 Oct 2021

Perficient ETL Tester Interview Experiences

1 interview found

ETL Tester Interview Questions & Answers

user image Anonymous

posted on 11 Oct 2021

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
  • 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:...

  • Answered by AI
  • 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.

  • Answered by AI
  • Q5. About project

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well SQL and etl concepts

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview before Oct 2021.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Pairing 

(1 Question)

  • Q1. Assignment is given before hand and after that you'll have to pair with TW developer. While pairing, code smells/improvements are discussed
Round 3 - Technical 

(1 Question)

  • Q1. Questions related: to your last project to OOPS with system design

Interview Preparation Tips

Interview preparation tips for other job seekers - Know your current project well and explain it in detailed manner.
Prepare for some system design questions and DS Algo

I applied via Campus Placement and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Python code to find the root of a number
  • Ans. 

    Python code to find the root of a number

    • Use the math module to access the sqrt() function

    • Use the ** operator to raise the number to the power of 1/n

    • Handle negative numbers by converting them to complex numbers

  • Answered by AI
  • Q2. Some standard puzzles

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up python and be thorough with puzzles

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
Round 3 - Technical 

(1 Question)

  • Q1. After 1st round I was asked to submit resume again and BGV details. Submitted them and Waiting for round 2

Interview Preparation Tips

Interview preparation tips for other job seekers - L1 was good waiting for the result and L2
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Job Fair and was interviewed in Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. What is Supervised machine learning? Which algorithm you think you can explain brilliantly? Why we use random forest then normal decision tree
  • Ans. 

    Supervised machine learning is a type of ML where the algorithm learns from labeled data. Random forest is used over normal decision tree for better accuracy and to avoid overfitting.

    • Supervised ML learns from labeled data to make predictions on new data

    • Random forest is an ensemble learning method that uses multiple decision trees to improve accuracy

    • Random forest is preferred over normal decision tree to avoid overfitti...

  • Answered by AI
  • Q2. Example of case study
  • Ans. 

    Case study on a successful marketing campaign for a new product launch

    • Identified target audience and their needs

    • Developed a unique selling proposition

    • Created a multi-channel marketing plan

    • Implemented the plan and tracked results

    • Adjusted strategy based on data analysis

    • Achieved high sales and positive customer feedback

  • Answered by AI
Round 3 - Case Study 

Retail case study , company trends salw.. Total sale. Profit charts and reports

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared, coding practice and case study is important.

Skills evaluated in this interview

Round 1 - Aptitude Test 

General Aptitude( Probability dominats) and objective coding

Round 2 - Coding Test 

Moderate levels coding questions Refer hacker rank

Round 3 - One-on-one 

(1 Question)

  • Q1. Coding, guesstimate, probability,
Round 4 - HR 

(1 Question)

  • Q1. Generation HR questions refer youtube

Interview Preparation Tips

Interview preparation tips for other job seekers - Good in coding, probability, guesstimate
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

We had questions on aptitude - like upstream, downstream problems, etc.

Round 2 - Technical 

(1 Question)

  • Q1. Live coding using Python/CPP
  • Ans. 

    Live coding using Python/CPP

    • Practice coding challenges on platforms like LeetCode or HackerRank to improve coding skills

    • Understand data structures and algorithms to solve coding problems efficiently

    • Use online IDEs like Repl.it or CodePen for live coding sessions

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Questions on SQL
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. 1st round- live python coding 2nd round- technical interview 3rd round - HR discussion
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Nov 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Probability, coding, coordinate geometry , debugging, predict the output

Round 3 - Coding Test 

1 hour test 3 questions , one was on numbers I don't remember much , random people get selected in 3rd round in campus placements

Round 4 - One-on-one 

(1 Question)

  • Q1. 1.) factorial code 2.) 2 probability questions 3.) prime factors 4.) any questions?
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

DSA Questions, iOS Technical Questions

Round 3 - Technical 

(1 Question)

  • Q1. Basic IOS Question
Round 4 - One-on-one 

(1 Question)

  • Q1. Leadership Round

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush-up basic of iOS Technical

Perficient Interview FAQs

How to prepare for Perficient ETL Tester interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Perficient. The most common topics and skills that interviewers at Perficient expect are ETL Testing, SQL, ETL, API and Data migration.
What are the top questions asked in Perficient ETL Tester interview?

Some of the top questions asked at the Perficient ETL Tester interview -

  1. Rank vs dense r...read more
  2. Types of ...read more
  3. SQL query duplicate reco...read more

Tell us how to improve this page.

Perficient ETL Tester Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Join Perficient Leading global digital consultancy

Interview Questions from Similar Companies

CitiusTech Interview Questions
3.4
 • 273 Interviews
Tiger Analytics Interview Questions
3.7
 • 226 Interviews
Altimetrik Interview Questions
3.8
 • 219 Interviews
Xoriant Interview Questions
4.1
 • 183 Interviews
Incedo Interview Questions
3.1
 • 182 Interviews
Globant Interview Questions
3.8
 • 175 Interviews
ThoughtWorks Interview Questions
3.9
 • 147 Interviews
Iris Software Interview Questions
4.0
 • 146 Interviews
Apexon Interview Questions
3.3
 • 141 Interviews
View all
Technical Consultant
861 salaries
unlock blur

₹4.2 L/yr - ₹14.9 L/yr

Senior Technical Consultant
437 salaries
unlock blur

₹7.2 L/yr - ₹21 L/yr

Associate Technical Consultant
321 salaries
unlock blur

₹2 L/yr - ₹8.5 L/yr

Technical Leader Consultant
223 salaries
unlock blur

₹10 L/yr - ₹29 L/yr

Softwaretest Engineer
189 salaries
unlock blur

₹4.1 L/yr - ₹9 L/yr

Explore more salaries
Compare Perficient with

Xoriant

4.1
Compare

Photon Interactive

4.0
Compare

CitiusTech

3.4
Compare

Iris Software

4.0
Compare
Did you find this page helpful?
Yes No
write
Share an Interview