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 applied via Recruitment Consultant and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. 1. Why do you want to change?
  • Q2. 2. What is your goal?
  • Q3. 3. Critical project you have handled?

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be yourself and provide short and to the point answer

I applied via Campus Placement and was interviewed before May 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Tell me about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - It was an good experience

I applied via Naukri.com and was interviewed before Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic questions only ... regarding job and experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident ... always say the truth ... never try to fake your details

I applied via Recruitment Consultant and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Take about a chalanging task you did and how you handled it

Interview Preparation Tips

Interview preparation tips for other job seekers - Softskills is very important for getting in to ITIS sector. you clear softskills round you are almost there.

I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Why Java is platform independent?
  • Ans. 

    Java is platform independent due to its bytecode and JVM.

    • Java code is compiled into bytecode which is platform-independent.

    • JVM (Java Virtual Machine) interprets the bytecode and executes it on any platform.

    • JVM acts as an abstraction layer between the Java code and the underlying hardware.

    • This allows Java programs to run on any platform that has a JVM installed.

    • For example, a Java program written on a Windows machine ca...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Java is platform-independent because it does not depend on any type of platform. Hence, Java is platform-independent language. In Java, programs are compiled into byte code and that byte code is platform-independent. ... Any machine to execute the byte code needs the Java Virtual Machine.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. 1)Tmaus? 2 ) why are you lefted previous job? 3) technical skills knowledge 4) work in under pressure? 5) hr round 6) manager round

Interview Questionnaire 

1 Question

  • Q1. Technical questions about Informatica

Interview Preparation Tips

Interview preparation tips for other job seekers - Below average interview questions. Got selected

I applied via Recruitment Consultant and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Communication and interpersonal and Team handle qualities

Interview Preparation Tips

Interview preparation tips for other job seekers - Be frank and say loudly what u r going to say be positive

Interview Questionnaire 

1 Question

  • Q1. Tell about urself

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
Technical Consultant
840 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Technical Consultant
432 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Technical Consultant
321 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Leader Consultant
206 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Softwaretest Engineer
185 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Perficient with

Cognizant

3.7
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

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