AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Perficient
Compare
Filter interviews by
Perficient ETL Tester Interview Questions and Answers
Perficient ETL Tester Interview Experiences
1 interview found
Anonymous
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:...
- 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.
- Q5. About project
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
(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
(2 Questions)
- Q1. What are your salary expectations
- Q2. Make sure you are not giving exact number unless its necessary and quote bit extra than what you expect because there will be always a negotiation
Interview Preparation Tips
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Star pattern program
- Q2. Number of vowels String program
- Ans.
Count the number of vowels in a given array of strings.
Iterate through each string in the array
For each string, iterate through each character and check if it is a vowel (a, e, i, o, u)
Increment a counter for each vowel found in the string
Interview Preparation Tips
- Xpaths
- WebDriver
Aptitude was 1st round, technical apti, then followed by tec nn iCal round
(2 Questions)
- Q1. Technical round was 2 nd, concepts related to testing Testing
- Q2. Tsting related questions were asked in interview
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Jan 2023. There was 1 interview round.
(1 Question)
- Q1. Manual testing, API , Real-time scenario
Interview Questionnaire
3 Questions
- Q1. Maximum time in interview they asked you about your previous project ?
- Q2. Explain your framework?
- Ans.
My framework is a hybrid framework that combines data-driven and keyword-driven approaches.
The framework uses Excel sheets to store test data and test cases.
It also uses keywords to perform actions and validations.
The framework is modular and can be easily extended.
It supports both manual and automated testing.
The framework provides detailed reports and logs for easy debugging.
- Q3. Explain Agile methodology.
- Ans.
Agile methodology is an iterative approach to software development that emphasizes flexibility and collaboration.
Agile values individuals and interactions over processes and tools
It emphasizes working software over comprehensive documentation
Agile teams work in short iterations called sprints
The team continuously delivers working software to the customer
Agile encourages frequent communication and collaboration between
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. About test case preparation
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. L1 was scheduled and asked abt ETL basics, some sql queries related to string manipulation
(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
(2 Questions)
- Q1. What are your salary expectations
- Q2. Make sure you are not giving exact number unless its necessary and quote bit extra than what you expect because there will be always a negotiation
Interview Preparation Tips
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
- Software Tester Interview Questions
- Manual Tester Interview Questions
- QA Tester Interview Questions
- Automation Tester Interview Questions
- ETL Test Engineer Interview Questions
- Senior Software Tester Interview Questions
- Selenium Automation Tester Interview Questions
- Game Tester Interview Questions
- Show more
Perficient ETL Tester Interview Process
based on 1 interview
Interview experience
ETL Tester Interview Questions from Similar Companies
Fast track your campus placements
|
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 ETL Tester Interview Questions
