Upload Button Icon Add office photos

Filter interviews by

Crif High Mark Credit Information Services Data Operations Analyst Interview Questions and Answers

Updated 27 Aug 2024

Crif High Mark Credit Information Services Data Operations Analyst Interview Experiences

1 interview found

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

I applied via Referral and was interviewed before Aug 2023. There were 3 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Years of experience
  • Ans. 

    I have 5 years of experience working in data operations.

    • 5 years of experience in data operations

    • Proficient in data analysis tools and techniques

    • Strong understanding of data management principles

    • Experience in data cleansing, transformation, and validation

    • Familiarity with database systems such as SQL

  • Answered by AI
  • Q2. Expected salary
  • Ans. 

    Negotiable based on market standards and job responsibilities

    • I am open to discussing salary based on the market standards for Data Operations Analyst roles

    • I would like to consider the job responsibilities and requirements before finalizing a salary

    • I am looking for a competitive salary package that aligns with my experience and skills

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Types of joins in SQL
  • Ans. 

    Types of joins in SQL include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a match in both tables.

    • Left join: Returns all rows from the left table and the matched rows from the right table.

    • Right join: Returns all rows from the right table and the matched rows from the left table.

    • Full outer join: Returns rows when there is a match in either table.

  • Answered by AI
  • Q2. Extract second highest salary
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to extract second highest salary

    • Use SQL query: SELECT DISTINCT Salary FROM Employees ORDER BY Salary DESC LIMIT 1, 1

    • Make sure to use DISTINCT to handle cases where multiple employees have the same salary

    • ORDER BY Salary DESC will sort the salaries in descending order

    • LIMIT 1, 1 will skip the first highest salary and return the second highest salary

  • Answered by AI
Round 3 - Behavioral 

(1 Question)

  • Q1. About my project

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about you
  • Q2. Basically every question asked is related to you given project
Round 2 - Case Study 

I waa given telecom market in indua

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
4-6 weeks
Result
Selected Selected

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

Round 1 - One-on-one 

(1 Question)

  • Q1. Tableau difference between blend &join
  • Ans. 

    Blend combines data from different data sources in a single view, while join combines data from the same data source.

    • Blend is used when data comes from different data sources, join is used when data comes from the same data source

    • Blend creates a relationship between data sources without actually merging the data, join merges the data based on a common field

    • Blend can be used to combine data from different databases like...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. SQL-related questions working of self join and what will be used in case of 2nd max

Interview Preparation Tips

Topics to prepare for ScatterPie Analytics Data Analyst interview:
  • SQL
  • Tableau
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Mar 2023. There were 4 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic details as to why looking for a change
Round 2 - Technical 

(1 Question)

  • Q1. Intermediate questions for tableau, SQL
Round 3 - Technical 

(1 Question)

  • Q1. Managerial interview
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Tell me about tableau architecture
  • Ans. 

    Tableau architecture is a visual analytics platform that helps users to understand data through interactive visualizations.

    • Tableau consists of three main components: Data Connection, Data Engine, and VizQL Server.

    • Data Connection allows users to connect to various data sources such as databases, spreadsheets, and cloud services.

    • Data Engine processes and optimizes data queries for faster performance.

    • VizQL Server translat...

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Regarding salary
Round 2 - One-on-one 

(3 Questions)

  • Q1. About tableau scenario
  • Q2. Top 10 emp and bottom 10as per rank
  • Ans. 

    The top 10 and bottom 10 employees based on their rank need to be identified.

    • Sort the employees based on their rank in ascending order.

    • Select the top 10 employees from the sorted list.

    • Select the bottom 10 employees from the sorted list.

  • Answered by AI
  • Q3. High light avg line

Interview Preparation Tips

Interview preparation tips for other job seekers - Job security is less it is one type of consultancy
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
Round 2 - Group Discussion 

Normal Group discussion

Round 3 - Technical 

(1 Question)

  • Q1. Cosing, project management etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't join this org
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - Coding Test 

Interviewer himself did not knew python or any other data analysis language

Round 2 - Assignment 

Excel, questions that were open ended

Round 3 - One-on-one 

(4 Questions)

  • Q1. How will you work under female manager
  • Ans. 

    I will work under a female manager just like I would under any other manager - with professionalism, respect, and open communication.

    • I will communicate openly and honestly with my female manager, just as I would with any other manager.

    • I will respect her authority and expertise, and follow her guidance and instructions.

    • I will collaborate effectively with my female manager and the rest of the team to achieve our goals.

    • I ...

  • Answered by AI
  • Q2. Are you willing to work for lower salary than previous
  • Ans. 

    I am open to discussing salary based on the overall compensation package and opportunities for growth.

    • I am open to discussing salary based on the overall compensation package and opportunities for growth.

    • I would like to understand the reasons for the lower salary offer and how it aligns with the company's budget and market standards.

    • I am willing to negotiate other benefits such as flexible work hours, additional vacati...

  • Answered by AI
  • Q3. Will your accomodation or salary structure needed to be validated in case you got married
  • Q4. Will you work till 1 am in the morning as bjp politicians client can ask anything anytime
Round 4 - Technical 

(2 Questions)

  • Q1. Why ai and machine learning is only marketing term and not a real technology
  • Ans. 

    AI and machine learning are real technologies with practical applications in various industries.

    • AI and machine learning have been successfully used in various industries such as healthcare, finance, and transportation to improve efficiency and accuracy.

    • Companies like Google, Amazon, and Facebook heavily rely on AI and machine learning algorithms to enhance their products and services.

    • AI and machine learning technologie...

  • Answered by AI
  • Q2. Why python is an awful language and would you be willing to work as a back end developer using spring or Node
  • Ans. 

    Python is not an awful language, but I am open to working with other technologies like Spring or Node.

    • Python is a versatile and widely-used language in data analysis and machine learning.

    • It has a large community and extensive libraries like Pandas and NumPy.

    • Spring and Node are also popular choices for backend development, offering different strengths and capabilities.

    • I am open to learning and working with new technolog

  • Answered by AI
Round 5 - HR 

(2 Questions)

  • Q1. Will you work under bond of 2 yrs ?
  • Ans. 

    I am open to discussing the terms of the bond and considering the overall opportunity.

    • I am willing to consider a bond if the terms are reasonable and the opportunity aligns with my career goals.

    • I would like to discuss the details of the bond such as its purpose, consequences of breaking it, and any potential benefits for me.

    • I may negotiate the duration of the bond or explore alternative options to ensure a mutually ben...

  • Answered by AI
  • Q2. We will give 30% of your salary as Variable pay after completion of 1 yr but we will decide when to give it to you. Would you still be willing to work for us as working for our company is a prestigious opp...
  • Ans. 

    I would consider the offer based on the overall compensation package and career growth opportunities.

    • I would need more information on the overall compensation package to make a decision.

    • I would also consider the potential career growth opportunities and learning experiences at the company.

    • It would be important to understand the criteria and timing for receiving the variable pay.

    • I would evaluate the offer based on my lo...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't apply, don't join, fight for no bond
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

There are simple technical test before manger round and it was very easy to crack

Round 3 - One-on-one 

(4 Questions)

  • Q1. Why you interested in this job
  • Q2. Are you comfortable in rational shift
  • Q3. Tell me something about your study
  • Q4. Do you read all the policy about companies
  • Ans. 

    Yes, I make sure to thoroughly read and understand all company policies.

    • I believe it is important to read and understand company policies to ensure compliance and avoid any misunderstandings.

    • Reading company policies helps me stay informed about the rules and regulations within the organization.

    • I make it a priority to review and familiarize myself with all policies to ensure I am following the correct procedures.

    • For exa...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident, it was very easy although all the interviewer is also nice

Analyst Interview Questions & Answers

GfK MODE user image Rohit Gupta

posted on 28 Mar 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Why this job you want to do
  • Q2. Why this job in gfk

Crif High Mark Credit Information Services Interview FAQs

How many rounds are there in Crif High Mark Credit Information Services Data Operations Analyst interview?
Crif High Mark Credit Information Services interview process usually has 3 rounds. The most common rounds in the Crif High Mark Credit Information Services interview process are HR, Technical and Behavioral.
What are the top questions asked in Crif High Mark Credit Information Services Data Operations Analyst interview?

Some of the top questions asked at the Crif High Mark Credit Information Services Data Operations Analyst interview -

  1. Extract second highest sal...read more
  2. Types of joins in ...read more

Tell us how to improve this page.

Crif High Mark Credit Information Services Data Operations Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
At par with the average Data Operations Analyst Salary in India
View more details

Crif High Mark Credit Information Services Data Operations Analyst Reviews and Ratings

based on 2 reviews

1.9/5

Rating in categories

1.0

Skill development

1.9

Work-life balance

3.0

Salary

3.0

Job security

1.0

Company culture

2.5

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
Softwaretest Engineer
158 salaries
unlock blur

₹3 L/yr - ₹5.5 L/yr

QA Engineer
53 salaries
unlock blur

₹3.6 L/yr - ₹5.5 L/yr

Data Analyst
46 salaries
unlock blur

₹2.5 L/yr - ₹8.1 L/yr

Business Analyst
35 salaries
unlock blur

₹3.5 L/yr - ₹15 L/yr

Senior Manager
26 salaries
unlock blur

₹14.9 L/yr - ₹26 L/yr

Explore more salaries
Compare Crif High Mark Credit Information Services with

Quantzig

4.8
Compare

AXIS MY INDIA

3.3
Compare

GfK MODE

3.3
Compare

Edward Food Research and Analysis Centre

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview