Upload Button Icon Add office photos

Filter interviews by

Crayon Data Data Engineer Intern Interview Questions and Answers

Updated 17 Oct 2024

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: The questions were of medium to high difficulty. What set this test apart was the fact that each question had different weightage ranging from 0.5 to 3 marks per question. Time was a major factor. So my strategy was to attempt all the 1 and 1.5 marks questions which constitute the major chunk of the paper in around 40 minutes and spend the remaining 20 minutes for the 2 and 3 mark questions. I did not even bother reading the 0.5 mark questions. The 2 and 3 mark questions were difficult and those will differentiate you from others. 1600 students wrote the test and only 86 got shortlisted for the next round.
Duration: 60 minutes
Total Questions: 40

Round: Technical Interview
Experience: I was asked to write a C program to print the Fibonacci sequence and a basic SQL query. Apart from this I was asked a puzzle and other questions related to my resume. Out of the 86, only 26 students were called for the next round which again was a technical interview.

Round: Technical Interview
Experience: This was similar to the first technical interview. I had to write a C program to print the prime numbers between 1 and 100 and a puzzle was asked again. Apart from this a guesstimate to find the number of cars between 2 places was asked and a scenario based question too was asked. These were followed by resume related questions.

Round: HR Interview
Experience: All the 26 students who attended the second technical round were allowed to attend HR round as well. This was just for 4 - 5 minutes. I was asked about my family background and why I should be hired. My fondest memories from school days were asked too. Finally offer letter was given to 10 students out of the 1600 who wrote the test :P

General Tips: Just keep a calm head and attempt the questions. Ask for time to think if you are not able to answer the questions immediately. Be bold and confident. That is sufficient :)
Skills: Puzzle Solving Capability, Ability To Think, SQL, C Programming
College Name: VIT Vellore

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Views on their recruiting process
  • Ans. 

    I believe the recruiting process is thorough and well-organized.

    • The company uses a combination of resume screening, interviews, and assessments to evaluate candidates.

    • They have a clear timeline for the hiring process and keep candidates informed of their progress.

    • Feedback is provided to candidates after interviews to help them improve for future opportunities.

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience:

I applied via Naukri.com

Interview Questionnaire 

1 Question

  • Q1.  What are Option Strict and Option Explicit? What are all the differences between Dispose and Finalize()? What is the difference between System.String and System.StringBuilder classes? What is Delegate? ...
  • Ans. 

    Answers to common interview questions for Software Engineer position

    • Option Strict and Option Explicit are compiler directives in VB.NET

    • Dispose() is used to release unmanaged resources while Finalize() is used for garbage collection

    • System.String is immutable while System.StringBuilder is mutable

    • Delegate is a type that represents a reference to a method

    • Value types store data directly while reference types store a referen...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - selection process-
1st round-online test(prpare all kind of logical, verbal, and .net related questions)
2nd round- technical round(prepare all .net interview questions,sql server questions, winforms, web api)
3rd round- hr discussion

I applied via Job Portal and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Basic js concepts

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Naukri.com and was interviewed in Sep 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 - Coding Test 

SQL test has been conducted nearer to 12-15 questions.

Round 3 - HR 

(2 Questions)

  • Q1. Normal discussion, about salary negotiation
  • Q2. Asked about my past company experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Best of luck.
They have lots of opportunities.....................
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Nov 2023. There were 2 interview rounds.

Round 1 - Coding Test 

It was a 3 hour test with 144 questions

Round 2 - HR 

(1 Question)

  • Q1. Why did you select this company?
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Jul 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Aptitude Test 

Multiple sections on cognitive ability, quant and logical reasoning.
1 coding question

Round 3 - Group Discussion 

Easy
50% went to next round

Round 4 - One-on-one 

(3 Questions)

  • Q1. Technical: SQL, DBMS, Basic programming questions- palindrome, fibonacci, discussion on projects and internships
  • Q2. Difference between UNION and UNION ALL
  • Ans. 

    UNION combines and removes duplicates, UNION ALL combines without removing duplicates.

    • UNION merges the results of two or more SELECT statements and removes duplicates.

    • UNION ALL merges the results of two or more SELECT statements without removing duplicates.

    • UNION is slower as it has to remove duplicates, while UNION ALL is faster.

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column...

  • Answered by AI
  • Q3. Types of SQL commands
  • Ans. 

    SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.

    • SELECT: retrieves data from a database

    • INSERT: adds new records to a table

    • UPDATE: modifies existing records in a table

    • DELETE: removes records from a table

    • CREATE: creates a new table, view, or index

    • DROP: deletes a table or index

  • Answered by AI
Round 5 - HR 

(1 Question)

  • Q1. Common HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on basics

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Online platform,
SQL coding

Round 2 - Technical 

(1 Question)

  • Q1. In a one-on-one technical round, all they will ask around your resume
Round 3 - HR 

(1 Question)

  • Q1. Basic HR question on salary and personal backgroung

I applied via Referral and was interviewed in Aug 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Most questions were based on profit/loss and coding Questions are simple

Round 3 - Group Discussion 

Gave us topic on how education is important in our life

Round 4 - Technical 

(2 Questions)

  • Q1. Most Questions are on sql and machine learning as per my resume
  • Q2. Find the top two logged in people of each state in facebook

Interview Preparation Tips

Topics to prepare for LatentView Analytics Data Analyst interview:
  • SQL
Interview preparation tips for other job seekers - This one is a great opportunity to start your career as data analyst be sure with sql if you mentioned it.

Crayon Data Interview FAQs

How many rounds are there in Crayon Data Data Engineer Intern interview?
Crayon Data interview process usually has 1 rounds. The most common rounds in the Crayon Data interview process are Technical.

Tell us how to improve this page.

Crayon Data Data Engineer Intern Interview Process

based on 1 interview

Interview experience

2
  
Poor
View more
Data Engineer
26 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Tableau Developer
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Test Engineer
11 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Product Test Engineer
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Crayon Data with

Mu Sigma

2.6
Compare

Fractal Analytics

4.0
Compare

Algonomy

4.0
Compare

AbsolutData

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