Upload Button Icon Add office photos

Filter interviews by

Karvy Insights Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Project Experience and end to end architecture
  • Ans. 

    I have experience working on projects with end-to-end architecture, including design, development, testing, and deployment.

    • Designed and implemented scalable AWS architectures using services like EC2, S3, Lambda, API Gateway, etc.

    • Developed applications using AWS SDKs and integrated with other AWS services.

    • Performed testing and debugging of applications on AWS infrastructure.

    • Deployed applications on AWS using CI/CD pipel...

  • Answered by AI
  • Q2. PySpark Coding question to Extract Transform & Load
  • Q3. Cost Optimization on Snowflake
  • Ans. 

    Cost optimization on Snowflake involves utilizing features like virtual warehouses, auto-suspend, and resource monitoring.

    • Utilize virtual warehouses efficiently based on workload requirements

    • Enable auto-suspend to automatically pause warehouses when not in use

    • Monitor resource usage and adjust configurations accordingly

  • Answered by AI
Round 2 - Technical 

(5 Questions)

  • Q1. Project end to end
  • Q2. How to connect to a share point database
  • Ans. 

    To connect to a SharePoint database, you can use SharePoint's REST API or Microsoft Graph API.

    • Use SharePoint's REST API to interact with SharePoint data through standard HTTP requests.

    • Authenticate using OAuth tokens to access SharePoint resources securely.

    • Utilize Microsoft Graph API for a unified endpoint to access data across Microsoft services.

    • Ensure proper permissions are set up for the application accessing the Sha

  • Answered by AI
  • Q3. Normalization & de normalization
  • Q4. Questions on SQL Joins
  • Q5. Question to find the 2nd highest salary using window function
  • Ans. 

    Use window function to find 2nd highest salary in SQL

    • Use the ROW_NUMBER() function to assign a unique row number to each row based on the salary in descending order

    • Filter the results where the row number is 2 to get the 2nd highest salary

  • Answered by AI
Round 3 - HR 

(3 Questions)

  • Q1. Why are you looking for a job change
  • Q2. How was the experience at previous company
  • Q3. Expected CTC at Scatterpie
  • Ans. 

    Expected CTC at Scatterpie

    • Research industry standards for AWS Developer roles at Scatterpie

    • Consider your experience, skills, and qualifications

    • Factor in location, company size, and benefits package

    • Negotiate based on market trends and personal value

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It had 2 technical rounds, 30 min each and 1 HR round. Given it is a startup they have budget constraints and do not communicate well.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Laboratory technician
  • Q2. Laboratory technician qualified
Round 2 - One-on-one 

(2 Questions)

  • Q1. Laboratory technician
  • Q2. Laboratory technician Qualify
Round 3 - Technical 

(2 Questions)

  • Q1. Quality control
  • Q2. Complete process

Interview Preparation Tips

Interview preparation tips for other job seekers - Laboratory technician working
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Nov 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL questions such as case statement, joins and advanced sql question.
  • Q2. PLSQL, tableau basic to advanced question
Round 2 - HR 

(2 Questions)

  • Q1. Bureau operations,credit data
  • Q2. Career goals and future plans
Round 3 - Na 

(2 Questions)

  • Q1. Only two rounds were there
  • Q2. Na rounds happened after two rounds

Interview Preparation Tips

Topics to prepare for Crif High Mark Credit Information Services Senior Data Analyst interview:
  • Udemy data analytics course
Interview preparation tips for other job seekers - Prepare for the worst case scenarios so that you will crack any type of interview
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Unica technical questions
  • Q2. What is flow chart
Round 2 - One-on-one 

(2 Questions)

  • Q1. Technical ask about macro and treatment code
  • Q2. Campaign attributes
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Psi mins full form
  • Ans. 

    PSI stands for Pounds per Square Inch, a unit of pressure measurement commonly used in engineering and physics.

    • PSI is used to measure pressure in various systems, such as in pneumatic tools, hydraulic systems, and air compressors.

    • 1 PSI is equal to 0.068046 atmospheres or 6,894.76 Pascals.

    • For example, a car tire may require inflation to 32 PSI for optimal performance.

  • Answered by AI
  • Q2. Firing strocks position
  • Ans. 

    Firing strokes position refers to the position of the firing strokes in an engine.

    • Firing strokes position is crucial for the proper functioning of the engine.

    • The firing order of the engine determines the position of the firing strokes.

    • Incorrect firing strokes position can lead to engine misfires or damage.

    • Common firing orders include 1-3-4-2 for a 4-cylinder engine and 1-8-4-3-6-5-7-2 for a V8 engine.

  • Answered by AI
  • Q3. How to work hyd.pump
  • Ans. 

    To work a hydraulic pump, you need to understand its components and operation.

    • Understand the basic components of a hydraulic pump such as the inlet, outlet, and pistons.

    • Ensure the pump is properly connected to a power source and the hydraulic system.

    • Monitor the pump's pressure and flow rate to ensure optimal performance.

    • Regularly check and maintain the pump to prevent any malfunctions or breakdowns.

    • Examples: Gear pump,

  • Answered by AI
  • Q4. Injectors leack off test
  • Q5. How to use torque gun
  • Ans. 

    A torque gun is a tool used to apply torque to fasteners such as nuts and bolts.

    • Ensure the torque gun is set to the correct torque value for the fastener being tightened.

    • Hold the torque gun perpendicular to the fastener and apply pressure while pulling the trigger.

    • Listen for the click or beep indicating the desired torque has been reached.

    • Do not over-tighten the fastener as it can cause damage.

    • Regularly calibrate and m

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Referral and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What is coalesce
  • Ans. 

    Coalesce is a function used to return the first non-null value in a list of expressions.

    • Coalesce function is commonly used in SQL to handle null values.

    • It takes multiple arguments and returns the first non-null value.

    • Example: COALESCE(column1, column2, 'default') will return the value of column1 if not null, else column2, and if both are null, it will return 'default'.

  • Answered by AI
  • Q2. What is repartition
  • Ans. 

    Repartition is the process of redistributing data across partitions in a distributed system.

    • Repartitioning helps in balancing the workload and improving performance in distributed computing environments.

    • It involves moving data between partitions based on certain criteria such as key values or hash functions.

    • Repartitioning can be done in Spark using operations like repartition() or coalesce().

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Non repeatable character
  • Ans. 

    A non repeatable character is a character that appears only once in a given string.

    • Iterate through the string and count the frequency of each character

    • Identify the characters that have a frequency of 1

    • Return the first non repeatable character found

  • Answered by AI
  • Q2. Sort list without sort method
  • Ans. 

    Sort list without using sort method

    • Create a custom sorting function using loops

    • Compare each element with every other element to determine the correct order

    • Swap elements based on the comparison results

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Past Experience and Work profile
  • Q2. Future plan and work strategy in Axis My India.
  • Ans. 

    My future plan in Axis My India is to implement data-driven strategies for accurate predictions and expand our reach in untapped regions.

    • Implement data-driven strategies to improve accuracy of predictions

    • Expand reach in untapped regions through targeted marketing campaigns

    • Enhance customer engagement through personalized communication

    • Invest in research and development for innovative solutions

    • Collaborate with local partn

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Past Experience And Work profile in previous organization
  • Q2. Basic question from your work experience
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Assignment 

Market size and value of India diagnostics market

Round 2 - One-on-one 

(3 Questions)

  • Q1. Talk about your previous experience and gave your presentation of the assignment
  • Q2. Talk about yourself
  • Ans. 

    I am a detail-oriented and analytical individual with a strong background in data analysis and problem-solving.

    • Graduated with a degree in Statistics

    • Proficient in statistical software such as R and Python

    • Experience in analyzing large datasets to derive insights

    • Strong communication skills for presenting findings to stakeholders

  • Answered by AI
  • Q3. What were your previous projects related custom and syndicate
  • Ans. 

    I have worked on various custom and syndicate projects in my previous roles.

    • Led a team in developing a custom market research report for a pharmaceutical company

    • Contributed to syndicate reports on consumer behavior trends in the tech industry

    • Collaborated with clients to tailor research findings to their specific needs

  • Answered by AI
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Are you willing to work ?
  • Q2. Are sure you want to join this company

Interview Preparation Tips

Interview preparation tips for other job seekers - Well officially the working hours is 6pm to 3am but they won't leave you on 3am they put you to work till 6am in the morning and only then they will leave you.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Assignment 

Report writing- you have to present a market research overview on any of industry you can visit on their website for same

Round 2 - HR 

(2 Questions)

  • Q1. Analyse market trends
  • Ans. 

    Market trends can be analyzed by examining consumer behavior, industry reports, and economic indicators.

    • Examine consumer behavior through surveys and focus groups

    • Review industry reports and forecasts for insights

    • Monitor economic indicators such as GDP growth and inflation rates

    • Look for emerging technologies or innovations that could impact the market

    • Consider geopolitical events or regulatory changes that may influence

  • Answered by AI
  • Q2. Guest estimate for any industry
  • Ans. 

    Guest estimate for any industry refers to the practice of predicting the number of guests or customers a business may expect to receive within a certain period of time.

    • Consider historical data and trends to make an educated guess

    • Take into account external factors such as seasonality, holidays, and economic conditions

    • Utilize forecasting models or software to help with the estimation process

  • Answered by AI

Karvy Insights Interview FAQs

How to prepare for Karvy Insights 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 Karvy Insights. The most common topics and skills that interviewers at Karvy Insights expect are Research, Project Management, Primary Research, Data Analysis and Quantitative Research.

Tell us how to improve this page.

Karvy Insights Reviews and Ratings

based on 17 reviews

3.2/5

Rating in categories

3.2

Skill development

2.8

Work-Life balance

2.9

Salary & Benefits

2.2

Job Security

3.2

Company culture

2.7

Promotions/Appraisal

3.0

Work Satisfaction

Explore 17 Reviews and Ratings
Assistant Manager
14 salaries
unlock blur

₹9.5 L/yr - ₹11 L/yr

Research Executive
8 salaries
unlock blur

₹5.9 L/yr - ₹7.2 L/yr

Senior Manager
6 salaries
unlock blur

₹13.8 L/yr - ₹16.5 L/yr

Associate Vice President
6 salaries
unlock blur

₹19 L/yr - ₹26 L/yr

Manager
5 salaries
unlock blur

₹10 L/yr - ₹13.8 L/yr

Explore more salaries
Compare Karvy Insights with

Adsum Advisory Services

4.5
Compare

Azista Industries

3.6
Compare

E Merge Tech Global Services

3.2
Compare

Manikaran Analytics

2.6
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview