i
Perficient
Filter interviews by
I applied via Naukri.com and was interviewed in Sep 2021. There was 1 interview round.
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:...
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.
Top trending discussions
I appeared for an interview before Oct 2021.
I applied via Campus Placement and was interviewed before Sep 2020. There were 3 interview rounds.
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
I applied via Naukri.com and was interviewed in Apr 2023. There were 3 interview rounds.
I applied via Job Fair and was interviewed in Sep 2022. There were 3 interview rounds.
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...
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
Retail case study , company trends salw.. Total sale. Profit charts and reports
General Aptitude( Probability dominats) and objective coding
Moderate levels coding questions Refer hacker rank
I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.
We had questions on aptitude - like upstream, downstream problems, etc.
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
I applied via Campus Placement and was interviewed before Nov 2022. There were 4 interview rounds.
Probability, coding, coordinate geometry , debugging, predict the output
1 hour test 3 questions , one was on numbers I don't remember much , random people get selected in 3rd round in campus placements
I applied via Company Website and was interviewed in Mar 2023. There were 4 interview rounds.
DSA Questions, iOS Technical Questions
based on 1 interview
Interview experience
Technical Consultant
861
salaries
| ₹4.2 L/yr - ₹14.9 L/yr |
Senior Technical Consultant
437
salaries
| ₹7.2 L/yr - ₹21 L/yr |
Associate Technical Consultant
321
salaries
| ₹2 L/yr - ₹8.5 L/yr |
Technical Leader Consultant
223
salaries
| ₹10 L/yr - ₹29 L/yr |
Softwaretest Engineer
189
salaries
| ₹4.1 L/yr - ₹9 L/yr |
Xoriant
Photon Interactive
CitiusTech
Iris Software