Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
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
3.6

based on 490 Reviews

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
    • Add your answer
  • 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
    Add your answer
  • Q3. Query of set operator
    • Add your answer
  • 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
    Add your answer
  • Q5. About project
    • Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Top trending discussions

View All
Salary Discussions, Hike & Promotions
2w
busybhindi
·
works at
Tietoevry
TCS or Capgemini
I have got an offer of 34 LPA from TCS and Capgemini . I have 11 years of experience , Azure Developer. Can you please guide / suggest which company should I join . I am confused since both are offering the same CTC . TIA
Got a question about Perficient?
Ask anonymously on communities.

Interview questions from similar companies

Associate Interview Questions & Answers

Cognizant user image Anonymous

posted on 2 Sep 2021

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?
    • Add your answer
  • Q2. 2. What is your goal?
    • Add your answer
  • Q3. 3. Critical project you have handled?
    • Add your answer

Interview Preparation Tips

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

Analyst Interview Questions & Answers

Cognizant user image Anonymous

posted on 2 May 2021

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
    • Add your answer

Interview Preparation Tips

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

Analyst Interview Questions & Answers

Wipro user image Anonymous

posted on 8 Apr 2021

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
    • Add your answer

Interview Preparation Tips

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

Associate Interview Questions & Answers

Infosys user image Anonymous

posted on 25 May 2021

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
    Add your answer

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

Associate Interview Questions & Answers

Wipro user image Anonymous

posted on 26 Sep 2020

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
    • Add your answer

Associate Interview Questions & Answers

Cognizant user image Anonymous

posted on 15 Nov 2020

Interview Questionnaire 

1 Question

  • Q1. Technical questions about Informatica
    • Add your answer

Interview Preparation Tips

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

Associate Interview Questions & Answers

Wipro user image Anonymous

posted on 22 Oct 2021

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
    • Add your answer

Interview Preparation Tips

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

Associate Interview Questions & Answers

Infosys user image Anonymous

posted on 8 Apr 2021

Interview Questionnaire 

1 Question

  • Q1. Tell about urself
    • Add your answer

Consultant Interview Questions & Answers

Infosys user image Anonymous

posted on 27 Dec 2019

I applied via Naukri.com and was interviewed in Jun 2019. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Configuration Management, data modelling, CI relationships, Problem management process flow, SIAM, integration, cmdb reports, KPIs.
    • Add your answer
  • Q2. General introduction, projects handled in the past,
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick to what u have worked on in your resume, ask about offered profile,
More about working at Perficient

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 Interviews By Designations

Interview Questions for Popular Designations

Perficient ETL Tester Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more
Join Perficient Leading global digital consultancy

ETL Tester Interview Questions from Similar Companies

Infosys ETL Tester Interview Questions
3.6
 • 12 Interviews
Cognizant ETL Tester Interview Questions
3.8
 • 8 Interviews
LTIMindtree ETL Tester Interview Questions
3.8
 • 7 Interviews
TCS ETL Tester Interview Questions
3.7
 • 5 Interviews
Hexaware Technologies ETL Tester Interview Questions
3.5
 • 5 Interviews
Wipro ETL Tester Interview Questions
3.7
 • 3 Interviews
HCLTech ETL Tester Interview Questions
3.5
 • 2 Interviews
Tech Mahindra ETL Tester Interview Questions
3.5
 • 1 Interview
Mphasis ETL Tester Interview Questions
3.4
 • 1 Interview
Altimetrik ETL Tester Interview Questions
3.8
 • 1 Interview
View all

Fast track your campus placements

Vellore Institute of Technology (VIT) Placement Questions
1 Interview
View all
Perficient Salaries in India
Technical Consultant
842 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
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview