AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Decimal Point
Analytics
Compare
Filter interviews by
Decimal Point Analytics ETL Developer Interview Questions and Answers
Decimal Point Analytics ETL Developer Interview Experiences
1 interview found
Anonymous
I applied via Monster and was interviewed before May 2019. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Genral MySQL , database management system queries and about trigger and question on logical reasoning .
- Q2. What is trigger . Do Implementation of types of trigger?
- Ans.
A trigger is a special type of stored procedure that automatically executes in response to certain events.
Triggers are used to enforce business rules or to perform complex calculations.
There are two types of triggers: DML triggers and DDL triggers.
DML triggers fire in response to DML events (INSERT, UPDATE, DELETE).
DDL triggers fire in response to DDL events (CREATE, ALTER, DROP).
Triggers can be used to audit changes t...
- Q3. How many join operation are there?
- Q4. 5 permission in Linux?
- Ans.
Linux permissions include read, write, execute, setuid, and setgid.
Read permission allows a user to view the contents of a file or directory.
Write permission allows a user to modify the contents of a file or directory.
Execute permission allows a user to run a file or access the contents of a directory.
Setuid permission allows a user to execute a file with the permissions of the file's owner.
Setgid permission allows a u...
Interview Preparation Tips
Be confident while you answering them .
Keep your good knowledge in core Java language.
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Interview Questionnaire
5 Questions
- Q1. A Big Bazaar store had low profits for the last two months. Whats going on?
- Ans.
Low profits in Big Bazaar store for last two months.
Check if there is a decrease in footfall or sales.
Analyze the competition in the area.
Check if there are any supply chain issues.
Evaluate the marketing strategies and promotions.
Assess the economic conditions of the area.
Consider the impact of COVID-19 on consumer behavior.
Review the store's inventory management and pricing strategies.
- Q2. Heres some data about the quantity of a particular item sold in a store for the last few weeks. Any thoughts?
- Ans.
Analyzing sales data can reveal trends, seasonality, and inventory needs for better decision-making.
Identify trends: Look for patterns in sales over the weeks, such as increasing or decreasing sales.
Seasonality: Determine if sales fluctuate based on time of year, holidays, or events.
Inventory management: Use sales data to optimize stock levels and avoid overstock or stockouts.
Customer preferences: Analyze which items a...
- Q3. You have two brands of milk that you can sell in your store,. Which one would you pick?
- Ans.
I would pick the brand that has a higher quality and better taste.
Check the quality and taste of both brands
Consider the price of each brand
Look at the expiration date of both brands
Consider the popularity of each brand among customers
- Q4. Why do you want to work at Dunnhumby?
- Ans.
I am passionate about data-driven insights and Dunnhumby's reputation as a leader in customer data science.
I am impressed by Dunnhumby's innovative approach to customer data science
I am excited about the opportunity to work with a talented team of data analysts
I am drawn to Dunnhumby's reputation for delivering actionable insights to clients
I believe that Dunnhumby's focus on customer-centricity aligns with my own valu...
- Q5. Tell me about this particular internship that you did
- Ans.
I interned at a marketing firm where I worked on social media campaigns and market research.
Assisted in creating social media content for clients
Conducted market research on target demographics
Analyzed data to improve campaign performance
Attended client meetings and presented findings
Learned about marketing strategies and industry trends
Interview Preparation Tips
Experience: 70 people shortlisted probably by cv and pre-assessment test results.
Round: Group Discussion
Experience: 70 shortlisted candidates were divided into 10 groups of 10. GD started, we sat in a circle around a table. All of us were handed a booklet and rough sheets. The interviewers told us that the booklet had three sections. Each section contained some data about a company followed by a question. We, as a group had to answer the three questions within one hour. He, himself suggested that we take twenty minutes per section - 5 mins to go through the data, fifteen to discuss and come to a conclusion. The first section gave us an idea about the company and asked some general questions about decreasing costs. Generic case study stuff. The next two sections were quant heavy. Required us to do a lot of calculations albeit simple. We divided the task among the group members. Ran out of time before solving the third question. Interviewer stepped in and helped us reach a conclusion. We were asked to leave the rough sheet behind. One of the longest and most civil Gds that I have attended. A wonderful experience.
Tips: Try to help move the discussion forward. Draw out your calculations and tables in the rough sheet. Let others speak, one hour is enough time for everyone to shine :).
Round: Case Study Interview
Experience: One interviewer. Small talks about the GD. A moderately long case followed by two short cases. The cases involved some quants. Nothing fancy. I did not follow any framework but he did not seem to mind. He helped me out any place that i got stuck. Asked me about why Dunnhumby. Nailed this answer. Did not ask a lot a questions from my cv, just about an internship i had done at a startup. Asked me whether i was comfortable with coding, told him i had not coded since my first year at college. That was it. Shaked hands and asked me to wait outside. HR came and told me i got the job.
Tips: Think out loud. Whatever you are thinking when looking at the tables or numbers, just speak them out loud for the interviewer so that he knows your thought process. Learn about the company a little bit before showing up for the interview. I was asked only cases, I heard others were asked guesstimates as well.
General Tips: Case in Point is more than enough as far as preparation is concerned. A good CV and CGPA helps. Don't worry, I myself lacked both :P
Skills: Ability To Work In A Team, Case Solving Ability, Quant+Math
College Name: IIT Kharagpur
Motivation: Wanted a job as an analyst with a good work-life balance and a moderately good pay.
Interview Preparation Tips
Experience: Pre-Assesment Test conducted in my college.
Consists of Quant, Verbal and logical reasoning.
Students who scored good in this test and had CG above 7 are shortlisted
Tips: Cat preparation would help
Practice aptitude for two months prior to placement season
Round: Group Discussion
Experience: A case was given and should be solved by the group of 8 people in an hour.
They will closely monitor the group and select the students who provide right insights, direct the group in right direction.
Tips: Avoid talking just for sake of talking.
Understand the case and then summarize what you understood.
Speak you idea and also discuss other ideas.
Make sure that the invigilator understands that you are good with cases.
Read Case in point or other case books to get in touch with different cases.
Duration: 60 minutes
Round: Case Study Interview
Experience: Asked few questions like Why Dunnhumy? Type of profiles you applied for? Tell me about your childhood? and few basic HR questions.
Asked a profitability case problem.Even though I did not solve the entire problem, my approach was right.
Gave some data and asked my inference.
Asked to calculate a problem without using pen and paper.
Tips: You need to be good with numbers.
You need to show them that you have the enthusiasm to learn things.
Skill Tips: Go through any good case book.
Show them you enjoy numbers.
Show them you like this work.
Skills: Case Solving Ability, Number Crunching, Ability To Make Quick Calculations
College Name: IIT Kharagpur
An case study is provided
An detailed representation of the scenarios given needs to be assessed
(1 Question)
- Q1. What is your understanding of market research
- Ans.
Market research involves gathering and analyzing information about target markets or customers to make informed business decisions.
Market research helps businesses understand their target audience and their preferences.
It involves collecting data on market trends, competitors, and customer behavior.
The information gathered through market research is used to make strategic decisions such as product development, pricing,...
(2 Questions)
- Q1. Valid parentheses
- Q2. Currying with arrow function
- Ans.
Currying is a technique in functional programming where a function with multiple arguments is transformed into a sequence of nested functions, each taking a single argument.
Currying can be achieved using arrow functions in JavaScript.
Arrow functions automatically bind 'this' and do not have their own 'this' value.
Example: const add = a => b => a + b;
Example: const addFive = add(5); const result = addFive(3); // result ...
(2 Questions)
- Q1. DFS related problem
- Q2. Machine coding round
Interview Preparation Tips
Skills evaluated in this interview
3 questions 3 sum linked list missing sum
(2 Questions)
- Q1. System Design and hr principles
- Ans.
System design involves creating a high-level architecture of a software system, while HR principles focus on managing people effectively.
System design involves identifying components, defining their interactions, and ensuring scalability and reliability.
HR principles include hiring the right talent, providing training and development opportunities, and fostering a positive work culture.
Both system design and HR princip...
- Q2. Projects discussion
- Ans.
Discussing my software development projects, highlighting key technologies and outcomes.
Developed a web application using React and Node.js for a local business, improving their online sales by 30%.
Contributed to an open-source project on GitHub, enhancing the user interface and fixing bugs, which increased user engagement.
Led a team project to create a mobile app for tracking fitness goals, utilizing Flutter, resultin...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. DSA Next Greater element 2 Cycle in Linked List and if cycle remove it Best time to buy and sell stocks Coin Change
- Ans.
Key DSA problems: Next Greater Element, Cycle in Linked List, Stock Trading, and Coin Change.
Next Greater Element: Find the next greater number for each element in an array. Example: For [4, 5, 2, 10], result is [5, 10, 10, -1].
Cycle in Linked List: Detect and remove a cycle using Floyd's Tortoise and Hare algorithm. If a cycle exists, find the start and remove it.
Best Time to Buy and Sell Stocks: Maximize profit by fi...
- Q2. Pyspark Optimisation techniques Wide and Narrow Transportmations Application Master
- Q3. SQL Top 3 salaries per department Total working hours for an employee
- Ans.
Retrieve the top 3 salaries from each department and calculate total working hours for each employee using SQL queries.
Use the ROW_NUMBER() function to rank salaries within each department: SELECT *, ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees.
Filter the results to get only the top 3 salaries: WHERE rank <= 3.
To calculate total working hours, use SUM() function: SELECT ...
I applied via LinkedIn and was interviewed in Sep 2022. There were 3 interview rounds.
Logical and data interpretation
Basic understanding of business
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
20 MINUTES 15 QUESTIONS OF DATA INTERPETRATION
(3 Questions)
- Q1. INTRODUCE YOURSELF
- Q2. WHY THIS ROLE ?
- Q3. SIMPLE CASE STUDY
(2 Questions)
- Q1. CASE STUDY HARD ONE
- Q2. DIFFERENT SITUATIONS IN THE SAME PROLEM
- Ans.
Analyzing different situations within the same problem allows for a comprehensive understanding and effective solutions.
Identify the various factors contributing to the problem
Consider how each factor interacts with the others
Evaluate potential solutions based on the different scenarios
Adjust strategies as needed based on the changing circumstances
Selected
I applied via Referral and was interviewed in Jul 2024. There were 4 interview rounds.
Aptitude test conducted with normal logical reasoning, verbal ability and quantitative type aptitude problems were asked.
Case study round scheduled with Practice Director:
Started with normal greetings and basic introduction followed by deep dive into the resume and some questions based on what was in my resume. Then started with the case study.
Case : Your client is a totally offline bank ( think of SBI) and wants to undergo a digital transformation (somewhat like HDFC wherein all services are online as well) . How would you create a framework to do so ?
(2 Questions)
- Q1. Estimate the number of viewers who watched 2024 T20 World Cup.
- Ans.
Estimating the number of viewers for the 2024 T20 World Cup.
Consider past viewership trends for T20 World Cup events.
Analyze the popularity of cricket in the host country and globally.
Take into account the impact of digital streaming platforms on viewership.
Factor in potential growth in viewership due to increased interest in T20 cricket.
Consult experts in sports broadcasting and market research for insights.
- Q2. Estimate the number of Gyms in Delhi
- Ans.
Estimating the number of Gyms in Delhi based on population density, urbanization, and market demand.
Consider the population density of Delhi
Analyze the urbanization level in different areas of Delhi
Research on the market demand for fitness centers in Delhi
Consult with local authorities or fitness industry experts for insights
Use data from online directories or platforms listing Gyms in Delhi
(1 Question)
- Q1. It was a cultural fit/HR round taken by the Partner/Managing Partner in the firm. Questions around personality likes/dislikes future goals, MBA aspirations etc were asked
Interview Preparation Tips
Decimal Point Analytics Interview FAQs
Tell us how to improve this page.
Decimal Point Analytics Interviews By Designations
- Decimal Point Analytics Research Analyst Interview Questions
- Decimal Point Analytics Senior Research Analyst Interview Questions
- Decimal Point Analytics Data Scientist Interview Questions
- Decimal Point Analytics Software Development Engineer Interview Questions
- Decimal Point Analytics Intern Interview Questions
- Decimal Point Analytics Software Developer Intern Interview Questions
- Decimal Point Analytics IT Infrastructure Executive Interview Questions
- Decimal Point Analytics Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Interview Questions from Similar Companies
Decimal Point Analytics ETL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Research Analyst
391
salaries
|  ₹2 L/yr - ₹6 L/yr |
|
Senior Research Analyst
197
salaries
| ₹3.2 L/yr - ₹7.5 L/yr |
|
Software Development Engineer
75
salaries
| ₹4.6 L/yr - ₹11 L/yr |
|
Business Analyst
70
salaries
| ₹4.5 L/yr - ₹10.1 L/yr |
|
Data Scientist
59
salaries
| ₹11.2 L/yr - ₹18.3 L/yr |
Markets and Markets
Ascent Business Solutions
LogixHealth
Coronis Health
- Home >
- Interviews >
- Decimal Point Analytics Interview Questions
