AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
Perficient
Work with us 
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
- Ans.
Identify and retrieve duplicate records in a SQL database using GROUP BY and HAVING clauses.
Use GROUP BY to group records by the columns that define duplicates.
Apply HAVING COUNT(*) > 1 to filter groups with more than one record.
Example: SELECT column1, COUNT(*) FROM table_name GROUP BY column1 HAVING COUNT(*) > 1;
To see all columns of duplicate records, use a JOIN with the subquery.
Example: SELECT * FROM table_n...
- 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 appeared for an interview before Oct 2021.
(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
(1 Question)
- Q1. Questions related: to your last project to OOPS with system design
Interview Preparation Tips
Prepare for some system design questions and DS Algo
Abhishek Pandey
I applied via Walk-in and was interviewed before Nov 2020. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. A few terms related to mutual fund industry were asked.
- Q2. What do you understand by market capitalisation?
- Ans. Total number of shares outstanding multiplied by the price of one share.
Interview Preparation Tips
I applied via Referral and was interviewed in Jul 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Why do you want to join Incedo, what is your plan in future, explain your past experience with an example
- Ans.
I am drawn to Incedo for its innovative approach and growth opportunities, aligning with my career aspirations in technology consulting.
Incedo's commitment to innovation resonates with my passion for technology and problem-solving.
I admire Incedo's collaborative culture, which I experienced in my previous role at XYZ Corp, where teamwork led to a successful project launch.
My future plan includes advancing my skills in ...
- Q2. Basic of capital market
- Q3. Market capitalisation, capital market, derivatives, accounting knowledge
Interview Preparation Tips
Associate Interview Questions & Answers
Torry Harris Integration Solutions
Sinchana Gowda P
posted on 30 Jan 2025
Aptitude test was conducted at first
(1 Question)
- Q1. One-on-one round in the interview process
(1 Question)
- Q1. HR round was interactive and friendly.
(1 Question)
- Q1. Few technical questions were asked in round 4
Selected
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
(1 Question)
- Q1. Technical terms from jd
(1 Question)
- Q1. Behaviour and previous company related questions
Selected
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
(1 Question)
- Q1. They focusing on communication and ask capital markets, derivatives related questions.
(1 Question)
- Q1. Mutual fund, hedge fund, private equity, etf, performance fee, management fee, NAV calculation.
(1 Question)
- Q1. Same as technical and ask some behavioural questions.
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. What is nav describe
- Ans.
NAV stands for Net Asset Value, which represents the per-share value of a mutual fund or exchange-traded fund (ETF).
NAV is calculated by subtracting a fund's liabilities from its assets and dividing by the number of shares outstanding.
It is used to determine the price at which investors can buy or sell shares of the fund.
NAV is typically calculated at the end of each trading day.
For example, if a mutual fund has assets...
- Q2. What is the function of custodian bank
- Ans.
Custodian banks are financial institutions responsible for safeguarding assets, such as securities and cash, on behalf of institutional clients.
Provide safekeeping of assets
Settle trades on behalf of clients
Collect income on assets
Process corporate actions
Provide reporting and other administrative services
Act as a liaison between the client and the investment manager
Interview Preparation Tips
Selected
I appeared for an interview in Jan 2025.
(2 Questions)
- Q1. Can you please introduce yourself?
- Ans.
I am a highly motivated and detail-oriented individual with a background in finance and a passion for problem-solving.
Background in finance
Highly motivated and detail-oriented
Passionate about problem-solving
- Q2. Why are you seeking a job change?
- Ans.
Seeking new challenges and opportunities for growth.
Looking for new challenges to expand my skills and knowledge
Seeking opportunities for career advancement
Interested in working in a different industry or with a different team
(2 Questions)
- Q1. Can you describe your past professional experience?
- Ans.
I have over 5 years of experience in marketing and sales roles, with a focus on digital marketing strategies.
Managed social media campaigns for a tech startup, increasing engagement by 30%
Developed email marketing campaigns for a retail company, resulting in a 20% increase in sales
Led a team of sales representatives to exceed quarterly targets by 15%
- Q2. What process did you follow while working on your last project?
- Ans.
I followed a structured process involving research, planning, execution, and evaluation.
Researched the topic thoroughly to gather relevant information
Created a detailed plan outlining tasks and timelines
Executed the project according to the plan, making adjustments as needed
Evaluated the outcomes to identify successes and areas for improvement
Selected
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
Create a business requirement document
(1 Question)
- Q1. What are the strengths and weakness
- Ans.
Strengths include strong analytical skills and attention to detail. Weaknesses may include difficulty with public speaking and time management.
Strengths: strong analytical skills
Strengths: attention to detail
Weaknesses: difficulty with public speaking
Weaknesses: time management
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 Software Engineer Interview Questions
- Perficient Software Developer Interview Questions
- Perficient Test Engineer Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
|
Technical Consultant
913
salaries
|  ₹7.5 L/yr - ₹14 L/yr |
|
Senior Technical Consultant
460
salaries
| ₹12 L/yr - ₹22 L/yr |
|
Associate Technical Consultant
346
salaries
| ₹3.9 L/yr - ₹8 L/yr |
|
Technical Leader Consultant
234
salaries
| ₹18.5 L/yr - ₹31 L/yr |
|
Softwaretest Engineer
206
salaries
| ₹4.1 L/yr - ₹8 L/yr |
Xoriant
Photon Interactive
CitiusTech
Iris Software
- Home >
- Interviews >
- Perficient Interview Questions
