AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Aptino SQL and BI Developer Interview Questions, Process, and Tips for Experienced
Aptino SQL and BI Developer Interview Experiences for Experienced
1 interview found
Anonymous
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(5 Questions)
- Q1. Count Sum of sales by customer in MySQL.
- Ans.
Use GROUP BY clause to count sum of sales by customer in MySQL.
Use GROUP BY customer_id to group sales by customer
Use SUM(sales_amount) to calculate total sales for each customer
- Q2. Count Max sales by customer
- Ans.
Use SQL query to count the maximum sales by customer.
Use GROUP BY clause to group the sales by customer.
Use MAX() function to find the maximum sales for each customer.
Use COUNT() function to count the maximum sales for each customer.
- Q3. Introduced your self and share details about your roles and responsibilities.
- Q4. What is tableau blend and join
- Ans.
Tableau blend is combining data from different data sources, while join is combining data from the same data source.
Tableau blend is used to combine data from different data sources in a single view.
Join is used to combine data from the same data source based on a common key.
Blending is done at the visualization level, while joining is done at the data source level.
Blending allows for combining data that may not have a...
- Q5. Explain more about filter
- Ans.
Filters in SQL are used to restrict the result set based on specified criteria.
Filters are used in the WHERE clause of a SQL query to specify conditions that must be met for a row to be included in the result set.
Filters can be used to restrict the result set based on one or more columns, using comparison operators such as =, <>, >, <, >=, <=, etc.</p>
Filters can also be combined using logical oper...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Company Website and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is recursion ? what is inheritance? what is heap? write a code to find the largest element in an array?
- Ans.
Recursion is a process in which a function calls itself. Inheritance is a mechanism in OOP where a class inherits properties of another class. Heap is a region of memory used for dynamic memory allocation.
Recursion can be used to solve problems that can be broken down into smaller sub-problems.
Inheritance allows for code reuse and helps in creating a hierarchy of classes.
Heap is used for dynamic memory allocation in la...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Sep 2019. There were 4 interview rounds.
Interview Questionnaire
7 Questions
- Q1. I was asked to introduce about myself
- Q2. I was asked about my final year project work and all its pinpoint details
- Q3. I was asked about how the company would be benefitted from the project that I have done .
- Q4. Where do you see yourself after five years, working at this company
- Q5. What are Ur extra curricular activities
- Q6. Do you read books ,articles or watch documentaries
- Q7. Did you participate in any college events
Interview Preparation Tips
Interview will be very easy to attend
I applied via Company Website and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Self introduction
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Apr 2021. There were 2 interview rounds.
The test consist verbal, logical and quantitative sections and you need to score 50% more in all three.
(1 Question)
- Q1. They ask you everything written on your resume and some basics of DBMS, data structures
Interview Preparation Tips
I appeared for an interview before Dec 2020.
(1 Question)
Round duration - 45 minutes
Round difficulty - Hard
All mcqs should answer with in time limit should have a lot of practice to solve in exam
- Q1.
Water Jug Problem Statement
You have two water jugs with capacities
XandYliters respectively, both initially empty. You also have an infinite water supply. The goal is to determine if it is possible to... - Ans.
The Water Jug Problem involves determining if a specific amount of water can be measured using two jugs of different capacities.
Start by considering the constraints and limitations of the problem.
Think about how the operations allowed can be used to reach the target measurement.
Consider different scenarios and test cases to come up with a solution.
Implement a function that takes the capacities of the jugs and the targe...
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
Easy and just basic questions very easy round
- Q1.
Matrix Multiplication Task
Given two sparse matrices
MAT1andMAT2of integers with dimensions 'N' x 'M' and 'M' x 'P' respectively, the goal is to determine the resulting matrix produced by their multipl... - Ans.
Implement a function to multiply two sparse matrices and return the resulting matrix.
Create a function that takes two sparse matrices as input and returns the resulting matrix after multiplication.
Iterate through the non-zero elements of the matrices to perform the multiplication efficiently.
Ensure to handle the sparse nature of the matrices to optimize the multiplication process.
Consider the constraints provided to en...
Interview Preparation Tips
Tip 1 : preapre core subjects
Tip 2 : be confident and answer clearly
Tip 3 : be strong with projects
Tip 1 : good projects in ml and ai
Tip 2 : practical experience
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. What is flexbox
- Ans.
Flexbox is a CSS layout module that allows for flexible and responsive web design.
Flexbox allows for easy alignment and positioning of elements within a container.
It uses a set of properties to define the layout, such as display: flex and flex-direction.
Flexbox is particularly useful for creating responsive designs that adapt to different screen sizes.
It can also be used in combination with other CSS layout modules, su...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before May 2020. There was 1 interview round.
Interview Questionnaire
3 Questions
- Q1. It was for automotive domain. Mainly the questions were on automotive concept like CAN, UDS protocols, and tools of Vector company. Embedded c knowledge is must
- Q2. Embedded c knowledge is must
- Q3. Debugging skills are add on
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Aug 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. What is a bit
- Q2. What us the size of a bit
- Ans.
A bit is the smallest unit of digital information. It can have a value of either 0 or 1.
A bit is a binary digit, represented as either 0 or 1.
It is the basic unit of information used in computing and digital communications.
A group of 8 bits is called a byte.
The size of a bit is dependent on the architecture of the computer system.
- Q3. How many bits are there in C
- Ans.
C is a programming language and does not have a fixed number of bits.
C is a high-level programming language that can be compiled to run on different architectures with varying bit sizes.
The number of bits in C depends on the hardware architecture it is compiled for.
For example, C code compiled for a 32-bit architecture will have 32-bit integers, while code compiled for a 64-bit architecture will have 64-bit integers.
Interview Preparation Tips
Skills evaluated in this interview
Interview Questionnaire
1 Question
- Q1. About techical
Aptino Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- SQL Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- SQL and PL SQL Developer Interview Questions
- SQL Server Developer Interview Questions
- Power BI Developer Interview Questions
- Software Developer Interview Questions
- SQL Database Developer Interview Questions
- SQL Database Administrator Interview Questions
- Show more
Aptino SQL and BI Developer Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
|
Technical Recruiter
10
salaries
|  ₹2.4 L/yr - ₹5 L/yr |
|
US IT Recruiter
5
salaries
| ₹2.5 L/yr - ₹5.6 L/yr |
|
Real Time Analyst
5
salaries
| ₹5 L/yr - ₹5.7 L/yr |
|
Executive Accountant
4
salaries
| ₹3.7 L/yr - ₹5 L/yr |
|
Power BI Developer
4
salaries
| ₹10 L/yr - ₹24 L/yr |
TCS
Accenture
Wipro
Cognizant
- Home >
- Interviews >
- Aptino Interview Questions >
- Aptino SQL and BI Developer Interview Questions for Experienced
