Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by ClearTrail Technologies Team. If you also belong to the team, you can get access from here

ClearTrail Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

ClearTrail Technologies Lead Interview Questions and Answers

Updated 1 Nov 2021

ClearTrail Technologies Lead Interview Experiences

1 interview found

Lead Interview Questions & Answers

user image Anonymous

posted on 1 Nov 2021

I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. C/C++ , Networking and project code level details

Interview Preparation Tips

Interview preparation tips for other job seekers - Be ready with whatever is mentioned in resume.

Interview questions from similar companies

I applied via LinkedIn and was interviewed in May 2021. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Power Bi questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Portrait your eagerness towards upskilling and learning new things

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Sql

Interview Preparation Tips

Interview preparation tips for other job seekers - Good
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 - Coding Test 

Do select test

Round 3 - Technical 

(1 Question)

  • Q1. Sum and sumx in power bi
  • Ans. 

    Sum and SumX are DAX functions used in Power BI to calculate the sum of values in a column or table.

    • Sum calculates the sum of values in a column or table.

    • SumX calculates the sum of an expression evaluated for each row in a table.

    • Both functions can be used in measures and calculated columns.

    • Example: Sum(Sales[Revenue]) calculates the total revenue for the Sales table.

    • Example: SumX(Orders, [Quantity]*[Price]) calculates ...

  • Answered by AI
Round 4 - HR 

(2 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for these topic to clear power bi , sql, python

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before Aug 2021. There were 4 interview rounds.

Round 1 - Assignment 

A technical test for whatever technical round you are applying for. Will be conceptual test rather than hard/coded test

Round 2 - Technical 

(2 Questions)

  • Q1. For almost 1.5 hrs where technical questions being asked. level is easy to medium but mainly they focus on how fast are you while you stuck in a problem and your concepts
  • Q2. How can you derive (%share) in power bi
  • Ans. 

    To derive % share in Power BI, use the 'Group By' function and create a measure using the 'Divide' function.

    • Use the 'Group By' function to group the data by the desired category

    • Create a measure using the 'Divide' function to calculate the percentage share

    • Add the measure to a visual to display the % share

    • Example: = DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales)))

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

(1 Question)

  • Q1. This was with the Project Manager to see how well you can provide solutions and interact with client.
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and all

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont brag if you dont know anything at all. Trust me , people at fractal dont expect you to know everything. They just want tour concepts to be crystal clear

Skills evaluated in this interview

Round 1 - Coding Test 

Test was very simple having 4 sql questions and 4 python questions. Total time given was 90 minutes.

Pyrhon questions was one liner code.
Sql questions was related to join, group by, where and order functions

Round 2 - Technical 

(1 Question)

  • Q1. This round lasted for 1 hour questions was related to work experience. Explain properly what all algorithms you have used and what all projects you have worked on. In last 10 minutes interviewers shown so...
Round 3 - Technical 

(1 Question)

  • Q1. This round was related to domain knowledge lasted for 15 minutes. Questions testing business sense.
Round 4 - HR 

(1 Question)

  • Q1. Basic hr questions like why analytics?, any mistake you have done in past?, Any achievement?, Why fractal?

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and be thorough with resume.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 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 - Technical 

(2 Questions)

  • Q1. I was provided with a Marketing Mix Model problem statement and I have to provide the complete solution in excel and powerpoint presentation. In first round, The Question were all around my previous projec...
  • Q2. What is adstock, decay, Due tos Contributions? How do you evaluate the model? What is seasonality and the formula for seasonality? Do seasonality have any contribution?
  • Ans. 

    Explanation of adstock, decay, Due tos Contributions, seasonality and its formula.

    • Adstock is the measure of the lasting impact of advertising on consumer behavior.

    • Decay refers to the reduction in the effectiveness of advertising over time.

    • Due tos Contributions is the attribution of sales to different marketing channels.

    • Seasonality is the pattern of sales or other metrics that repeat over a fixed period of time.

    • The form...

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Second round was improvement on the model provided by me as the solution for MMM question. Technical questions were more on reasoning for the variables selected and understanding of the concepts of MMM. L...
Round 4 - HR 

(1 Question)

  • Q1. Salary Discussion and stuff related to that

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand Basic Concepts of MMM thoroughly. Try to prepare end to end solution i.e. from data processing to recommendation to the client.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 - Technical 

(1 Question)

  • Q1. Python plus SQL , machine learning,mmm
Round 3 - Case Study 

Case study on different aspects of analytics

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

I applied via Naukri.com and was interviewed before Sep 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Medium to difficult level

Round 2 - Technical 

(2 Questions)

  • Q1. -----------SQL BASED
  • Q2. ------EXPERIENCE BASED
Round 3 - HR 

(2 Questions)

  • Q1. Culture fit check
  • Q2. Behavioral questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well. Get strong on technical - SQL
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

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

Round 1 - Aptitude Test 

Aptitude test are basically asked from reasonable and patterns type questions.

Round 2 - Group Discussion 

Tooics are given from businesses and case study

ClearTrail Technologies Interview FAQs

How to prepare for ClearTrail Technologies Lead 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 ClearTrail Technologies. The most common topics and skills that interviewers at ClearTrail Technologies expect are Analytics, CRM, Customer Service, Law Enforcement and SEO.

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
Cyient Interview Questions
3.7
 • 288 Interviews
Fractal Analytics Interview Questions
4.0
 • 205 Interviews
View all
Software Engineer
72 salaries
unlock blur

₹5.5 L/yr - ₹23 L/yr

Senior Software Engineer
50 salaries
unlock blur

₹9 L/yr - ₹30 L/yr

Associate Software Engineer
31 salaries
unlock blur

₹3.8 L/yr - ₹8 L/yr

Module Lead
15 salaries
unlock blur

₹15.7 L/yr - ₹36 L/yr

Technical Support Engineer
13 salaries
unlock blur

₹5.3 L/yr - ₹11 L/yr

Explore more salaries
Compare ClearTrail Technologies with

Fractal Analytics

4.0
Compare

Subex

3.5
Compare

Innovatiview India Ltd

3.9
Compare

Watchyourhealth.com

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