Upload Button Icon Add office photos

Decimal Technologies

Compare button icon Compare button icon Compare

Filter interviews by

Decimal Technologies Data Analyst Interview Questions and Answers for Experienced

Updated 14 Jan 2023

Decimal Technologies Data Analyst Interview Experiences for Experienced

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 14 Jan 2023

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

I applied via Approached by Company and was interviewed before Jan 2022. There were 3 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 

(4 Questions)

  • Q1. Technical skills required. Some questions of programming languages are asked.
  • Q2. What are the SQL command groups?
  • Ans. 

    SQL command groups are DDL, DML, DCL, and TCL.

    • DDL (Data Definition Language) - used to define database schema and structure

    • DML (Data Manipulation Language) - used to manipulate data stored in the database

    • DCL (Data Control Language) - used to control access to data stored in the database

    • TCL (Transaction Control Language) - used to manage transactions in the database

    • Examples: CREATE, ALTER, DROP (DDL); SELECT, INSERT, UP...

  • Answered by AI
  • Q3. Explain Object Oriented Programming in Python?
  • Ans. 

    Object Oriented Programming is a programming paradigm that uses objects to represent real-world entities.

    • Python supports OOP concepts such as encapsulation, inheritance, and polymorphism.

    • Classes are used to create objects, which have attributes and methods.

    • Inheritance allows for the creation of subclasses that inherit properties and methods from a parent class.

    • Polymorphism allows for the use of a single method or funct...

  • Answered by AI
  • Q4. VLookup, Hlookup, Pivot Table in Excel
Round 3 - Coding Test 

You will be asked to share the screen and write the codes as asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn the programming language and practice them nicely..
Work environment is fantastic..

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Introduce Yourself
  • Ans. 

    I am a data analyst with a background in statistics and experience in analyzing large datasets to drive business decisions.

    • Graduated with a degree in Statistics

    • Proficient in data analysis tools such as Python, R, and SQL

    • Experience in creating visualizations to communicate insights

    • Strong problem-solving skills

  • Answered by AI
  • Q2. Skills you have

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 Questionnaire 

3 Questions

  • Q1. Proficiency with excel and excel macros ??
  • Ans. 

    Yes, I am proficient in Excel and Excel macros.

    • I have extensive experience in using Excel for data analysis and manipulation.

    • I am skilled in creating and modifying Excel macros to automate repetitive tasks.

    • I am familiar with advanced Excel functions such as VLOOKUP, PivotTables, and conditional formatting.

    • I have used Excel to create charts and graphs to visualize data.

    • I am comfortable working with large datasets in Exc...

  • Answered by AI
  • Q2. What projects had done ??
  • Q3. Previous work details

Skills evaluated in this interview

Interview Questionnaire 

2 Questions

  • Q1. Basic sql queries, like joins, where etc?
  • Q2. They might ask you technical questions related to basic sql

Interview Preparation Tips

Interview preparation tips for other job seekers - It will be a chill interview

I applied via Campus Placement and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Group Discussion 

Current affairs - relevant things going on in the world especially financial/Fintech domain

Round 2 - Technical 

(2 Questions)

  • Q1. Guesstimation questions- bursh up on them CV centric questions
  • Q2. Agile Data analysis Situation based

Interview Preparation Tips

Interview preparation tips for other job seekers - Ask clarity on job role- be sure it aligns to what you want

I applied via Approached by Company and was interviewed before Oct 2021. 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 - HR 

(2 Questions)

  • Q1. Screening of the resume
  • Q2. Regarding candidature
Round 3 - One-on-one 

(1 Question)

  • Q1. Related to job profile and technical requirements
Round 4 - HR 

(1 Question)

  • Q1. Salary structure and the part of joining date

Interview Preparation Tips

Interview preparation tips for other job seekers - Good organization to work with. Good work life balance

I applied via Campus Placement and was interviewed before May 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic SQL Queries, some very basic Java questions, the interviewer herself didn't know much about coding in general.

Interview Preparation Tips

Interview preparation tips for other job seekers - Yodlee is a big company will several departments, every department has its own requirements.

I was inducted into the IAE department as an ASE through pool-campus placement.

The issue at Yodlee is that it's IAE department that they actively hire for, is the worst department as far as technical growth and knowledge are concerned. There is no learning. Hence usually the interviewers (mostly the directors, managers, and leads in IAE) who have been in the organization for a very large part of their career, are also very weak as far as their technical skills are concerned. Their political and toxic managerial skills skyrocket though. They stay there for too long and become virtually outdated in terms of their technical skills.

Therefore you can rest be assured that the interview quality will be well below average as far as IAE is concerned. I am not sure about other departments, but I would not assume otherwise. I would suggest, if you have to absolutely join IAE in Yodlee, just an average preparation would be more than enough. If you have other opportunities, I would suggest prioritizing them over Yodlee.

I appeared for an interview before Apr 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 60 minutes
Round difficulty - Easy

The second round is also written but you need to write programming based on their concept.

  • Q1. 

    Prime Numbers Identification

    Given a positive integer N, your task is to identify all prime numbers less than or equal to N.

    Explanation:

    A prime number is a natural number greater than 1 that has no po...

  • Ans. 

    Identify all prime numbers less than or equal to a given positive integer N.

    • Iterate from 2 to N and check if each number is prime

    • Use the Sieve of Eratosthenes algorithm for better efficiency

    • Optimize by only checking up to the square root of N for divisors

  • Answered by AI
  • Q2. 

    Palindrome String Validation

    Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.

    Note:
    The string 'S' should be evaluated in a case...
  • Ans. 

    Check if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.

    • Remove special characters and spaces from the string

    • Convert the string to lowercase

    • Check if the modified string is a palindrome by comparing characters from start and end

  • Answered by AI
Round 2 - Face to Face 

(6 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions mainly on Java and OOPS concepts.

  • Q1. What is the difference between static methods and instance methods in Java?
  • Ans. 

    Static methods belong to the class itself, while instance methods belong to individual objects of the class.

    • Static methods are called using the class name, while instance methods are called using object references.

    • Static methods cannot access instance variables directly, while instance methods can access both static and instance variables.

    • Static methods are shared among all instances of the class, while instance method...

  • Answered by AI
  • Q2. What is the difference between an abstract class and an interface in Java?
  • Ans. 

    Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.

    • Abstract class can have constructors, member variables, and methods with implementation.

    • Interface can only have abstract methods and constants.

    • A class can implement multiple interfaces but can only extend one abstract class.

    • Example: Abstract class - Animal with abstract method 'eat', Interface - Flyable with m

  • Answered by AI
  • Q3. What is the difference between ClassNotFoundException and NoClassDefFoundError in Java?
  • Ans. 

    ClassNotFoundException occurs when a class is not found during runtime, while NoClassDefFoundError occurs when a class was found during compilation but not during runtime.

    • ClassNotFoundException is a checked exception, while NoClassDefFoundError is an Error.

    • ClassNotFoundException occurs when a class is not found at runtime, usually due to a missing classpath or incorrect class name.

    • NoClassDefFoundError occurs when a cla...

  • Answered by AI
  • Q4. What is the difference between an Error and an Exception in Java?
  • Ans. 

    Error is a serious issue that cannot be handled at runtime, while Exception is a recoverable issue that can be caught and handled.

    • Error is a subclass of Throwable and is usually caused by the environment or system, such as running out of memory or stack overflow.

    • Exception is also a subclass of Throwable but is caused by the application code, such as invalid input or file not found.

    • Errors are unchecked and are not meant...

  • Answered by AI
  • Q5. What is SerialVersionUID in Java?
  • Ans. 

    SerialVersionUID is a unique identifier used by Java to ensure the compatibility of serialized objects.

    • SerialVersionUID is a static final long variable in a class that implements Serializable interface.

    • It is used to ensure that the serialized object can be deserialized correctly even if the class definition has changed.

    • If the SerialVersionUID of the serialized object does not match the one in the class, an InvalidClass...

  • Answered by AI
  • Q6. What are the requirements for creating an immutable class in Java?
  • Ans. 

    Requirements for creating an immutable class in Java

    • Make the class final so it cannot be extended

    • Make all fields private and final

    • Do not provide setter methods, only getter methods

    • Ensure that mutable objects are not returned in getter methods

    • Override equals() and hashCode() methods for proper comparison

    • Consider making defensive copies of mutable fields in constructor or getter methods

  • Answered by AI

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAYodlee interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. Based on API coding Round
  • Q2. Designing + project
  • Q3. HR

Interview Preparation Tips

Round: Test
Experience: 30 MCQ questions testing basic logical reasoning, quantitative aptitude, analytical skills.
2 coding questions --I skipped 1st that was a mistake as it was the easiest. Basic array adhoc question.
2nd-greedy algorithm based find number of platforms for a train schedule.
1 API coding on trie data structure. Functions were all there. Problem--Given a word with a letter missing...find and print possible words from the dictionary. for example--
Input- dristisofts 5
Output- drishtisofts
drisetisofts
1 debugging question-toughest of them all for me...2d-matrix find the rectangle with largest sum.
Tips: Basic Level of Questions for me. I never explicitly prepared for those. Doable.
Try both 1st and 2nd...they will be easy...C and java are only possible languages given so can't use stl.
API will be easy only lengthy...don't panic...
If you have time, you will try 4th.

Duration: 180 minutes
Total Questions: 34

Round: Test
Experience: Completely networking based problem. based on TCP protocol. packets are being dropped and changed find a way to stop it. I was able to pass all test cases. (they were having some internal problems with there test cases).
Tips: Exciting round. Use re-transmission and sequence id and hash coding. Focus on everything. Interviews will be based on these.
Duration: 60 minutes
Total Questions: 1

Round: Test
Experience: N=4. find errors and generalise for N.
Tips: Easy-peasy.
Duration: 60 minutes
Total Questions: 1

Round: Technical Interview
Experience: Lovely experience. Duration -2hours. Interviewer was a chill guy. Interview started with some light moments and we discussed about my experience with the company I did my internship with. Then there was questioning about what I did in my API coding round. I was asked to explain point by point about how I understood the problem and how I solved it. Then he started grilling me on questions based on it. One by one questions were put in some way that I had to revisit everything what I learnt in my 2nd year about transmission protocol. Everything, starting with what was the hash code used to how the window size is decided and how to reduce traffic by sending cumulative ack.
Tips: Better prepare networking before coming. Everything, every exception.

Round: Technical Interview
Experience: I was asked to tell any two of my projects. And this is where I think I got an edge over others. My resume was filled with many projects and we discussed two of my most recent projects. I had learnt about Oauth protocol and RESTful APIs so we discussed about it. Then there was this problem about a company visiting for campus recruiting wanting to conduct a test on Hackerearth + what if lights went off and students want to continue where they had left --the problem was to design a databse based on these conditions and then some questions were asked on the database I had made. Finally there was an interview scheduling problem.50 students. 3 rounds(1->P1,P2 2->P2,P3 3->P4). design an algorithm to conduct the interviews taking minimum time to process all 50 students.
Tips: Prepare your projects and DBMS as well. Be confident, build approaches to tackle problems and try finding loopholes in it and then work on those. They will be focussing more on how you will tackle a general problem and not the solution.

Round: HR Interview
Experience: Introductions with family background. Psychometric test. and then I was told to ask about the company. Interviewer was very cool.
Tips: Easy - peasy.

General Tips: Do away with any nervousness. The interviewers will be extremely friendly. Just do your best. If you know it, it isn't that hard. Hints would be given. They just test your approach and knowledge of the subject.
Skill Tips: TCP concepts and socket programming. Projects on that would be lovely.
Skills: Networking, DBMS
College Name: NIT Jalandhar
Funny Moments: The interview was held in guest rooms lying down on bed. I was even asked to take rest and sleep for an hour before interviews alongside their bed.

Decimal Technologies Interview FAQs

How many rounds are there in Decimal Technologies Data Analyst interview for experienced candidates?
Decimal Technologies interview process for experienced candidates usually has 3 rounds. The most common rounds in the Decimal Technologies interview process for experienced candidates are Resume Shortlist, Technical and Coding Test.
How to prepare for Decimal Technologies Data Analyst interview for experienced candidates?
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 Decimal Technologies. The most common topics and skills that interviewers at Decimal Technologies expect are Computer science, Data Analysis, Product Management, SQL and Advanced Excel.
What are the top questions asked in Decimal Technologies Data Analyst interview for experienced candidates?

Some of the top questions asked at the Decimal Technologies Data Analyst interview for experienced candidates -

  1. What are the SQL command grou...read more
  2. Explain Object Oriented Programming in Pyth...read more
  3. Technical skills required. Some questions of programming languages are ask...read more

Tell us how to improve this page.

Decimal Technologies Data Analyst Interview Process for Experienced

based on 1 interview

Interview experience

5
  
Excellent
View more

Data Analyst Interview Questions from Similar Companies

View all
Decimal Technologies Data Analyst Salary
based on 29 salaries
₹4 L/yr - ₹9 L/yr
At par with the average Data Analyst Salary in India
View more details

Decimal Technologies Data Analyst Reviews and Ratings

based on 4 reviews

4.0/5

Rating in categories

3.8

Skill development

4.0

Work-life balance

3.6

Salary

4.0

Job security

4.2

Company culture

3.4

Promotions

3.6

Work satisfaction

Explore 4 Reviews and Ratings
Associate Software Engineer
97 salaries
unlock blur

₹3 L/yr - ₹8 L/yr

Software Engineer
78 salaries
unlock blur

₹4 L/yr - ₹10.5 L/yr

Software Developer
64 salaries
unlock blur

₹3 L/yr - ₹10 L/yr

Database Developer
32 salaries
unlock blur

₹3 L/yr - ₹9 L/yr

Data Analyst
29 salaries
unlock blur

₹4 L/yr - ₹9 L/yr

Explore more salaries
Compare Decimal Technologies with

Aurigo

4.7
Compare

Prime Focus Technologies

3.3
Compare

Peel-works

3.7
Compare

Yodlee

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