AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Modak Analytics Interview Questions and Answers
14 Interview questions
Retrieve student names with grades between 8 and 9 from a dataset, filtering based on specified criteria.
Data Source: Ensure you have access to a dataset containing student names and their corresponding grades.
Filtering Logic: Use a filtering mechanism (like a loop or a query) to select students whose grades are between 8 and 9.
Example: If using JavaScript, you might use the filter method: students.filter(student ...
This SQL query retrieves student names with a CGPA between 8 and 9 from the student database.
SQL Query Structure: The query uses the SELECT statement to specify the column (stdname) to retrieve from the student table.
BETWEEN Operator: The BETWEEN operator is used to filter records where the CGPA falls within the specified range (8 to 9).
Data Retrieval: This query will return all student names whose CGPA is greater...
To find the top two maximum salaries from the emp table, we can use SQL queries with ORDER BY and LIMIT clauses.
Use SQL query: SELECT DISTINCT salary FROM emp ORDER BY salary DESC LIMIT 2;
DISTINCT ensures unique salary values are considered.
ORDER BY salary DESC sorts the salaries in descending order.
LIMIT 2 restricts the output to the top two salaries.
The program checks if a given sentence is a palindrome or not.
Prompt the user to input a sentence
Remove all spaces and punctuation from the sentence
Reverse the sentence and compare it with the original sentence to check for palindrome
count(*) counts all rows in a table, while count(column_name) counts non-null values in a specific column.
count(*) counts all rows in a table
count(column_name) counts non-null values in a specific column
count(*) is generally used to get the total number of rows in a table
count(column_name) is used to count non-null values in a specific column
Languages based in SQL include T-SQL, PL/SQL, and SQL/PSM.
T-SQL (Transact-SQL) is Microsoft's proprietary extension to SQL used in SQL Server.
PL/SQL (Procedural Language/SQL) is Oracle's procedural language extension to SQL.
SQL/PSM (SQL/Persistent Stored Modules) is a standard for defining stored procedures and functions in SQL.
Object-oriented programming concepts that focus on classes and objects
Encapsulation: bundling data and methods that operate on the data within a single unit
Inheritance: ability of a class to inherit properties and behavior from another class
Polymorphism: ability to present the same interface for different data types
Abstraction: hiding the complex implementation details and showing only the necessary features
To find the second highest salary, we can use SQL queries with various methods like subqueries or the DISTINCT clause.
Use a subquery: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Use DISTINCT: SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
Use ROW_NUMBER(): SELECT salary FROM (SELECT salary, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rank FRO...
The three biggest learnings as a Project Manager
Importance of effective communication
Adaptability and flexibility in managing changes
The significance of risk management
Program to get minimum number of coins.
Create an array of coin denominations
Sort the array in descending order
Loop through the array and subtract the highest denomination possible
Repeat until the remaining amount is 0
Modak Analytics Interview Experiences
23 interviews found
Anonymous
Selected
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It is a test of total 150+ questions in which we have some java pseudocodes ,python ,aptitude reasoning questions as well and english questions.
(3 Questions)
- Q1. Short inteoduction and project discussion.
- Q2. Check the given sentence is palindrome or not by taking input by user.
- Ans.
The program checks if a given sentence is a palindrome or not.
Prompt the user to input a sentence
Remove all spaces and punctuation from the sentence
Reverse the sentence and compare it with the original sentence to check for palindrome
- Q3. Final,Finally,finalize keywords
(2 Questions)
- Q1. Introduce your self
- Q2. Soft skills and other basic questions
Interview Preparation Tips
- Java core
- MySQL
- Project
Skills evaluated in this interview
Comprehensive questions covered wide range of topics
Coding was typically
(1 Question)
- Q1. What programming language were used to develop the test.
- Ans.
The test was developed using a combination of programming languages tailored for specific functionalities.
JavaScript was used for front-end development to create interactive user interfaces.
Python was utilized for back-end services due to its simplicity and extensive libraries.
SQL was employed for database management to handle data storage and retrieval efficiently.
Java could have been used for building robust server-s...
(1 Question)
- Q1. About work life balance
I appeared for an interview in Sep 2024.
In that apptitude, reasoning,verbal,SQL queries
(3 Questions)
- Q1. In that based on resume questions asked like skills Java so preferred language asked basic coding problems and SQL queries
- Q2. Display the student name with grade from 8 to 9
- Ans.
Retrieve student names with grades between 8 and 9 from a dataset, filtering based on specified criteria.
Data Source: Ensure you have access to a dataset containing student names and their corresponding grades.
Filtering Logic: Use a filtering mechanism (like a loop or a query) to select students whose grades are between 8 and 9.
Example: If using JavaScript, you might use the filter method: students.filter(student =>...
- Q3. Select stdname from student where cgpa between 8 and 9
- Ans.
This SQL query retrieves student names with a CGPA between 8 and 9 from the student database.
SQL Query Structure: The query uses the SELECT statement to specify the column (stdname) to retrieve from the student table.
BETWEEN Operator: The BETWEEN operator is used to filter records where the CGPA falls within the specified range (8 to 9).
Data Retrieval: This query will return all student names whose CGPA is greater than...
(2 Questions)
- Q1. In that it's like all about communication
- Q2. What are your hobbies? What do you get by that
- Ans.
I enjoy reading, hiking, and coding personal projects, which enhance my creativity, problem-solving skills, and overall well-being.
Reading: Expands my knowledge and improves my analytical skills. For example, I recently read a book on software architecture.
Hiking: Helps me stay physically active and clear my mind, allowing for better focus when I return to work.
Coding personal projects: Keeps my programming skills shar...
Interview Preparation Tips
I applied via Walk-in and was interviewed in Aug 2024. There was 1 interview round.
(2 Questions)
- Q1. All BA technical questions
- Q2. All reports and calculations or formula asked.
Interview Preparation Tips
- Business Analysis
So rude people including HR's.
They simple send emails and invite for walking just to collect Resumes and never get back.
Far location with limited public transport and parking.
No proper interviewers to take interview, as it's small company of Analytics with limited resources so clear cut company politics was visible on faces.
Don't be surprised if you are being interviewed for Java role by a Fullstack interviewer OR PM role being interviewed by BA.
Just ont waste your time and go to companies where first round if virtual.
Selected
I appeared for an interview in Aug 2024.
(1 Question)
- Q1. Basic Java, Python, SQL Technical Questions.
(2 Questions)
- Q1. Questions from SQL, Python, Java.
- Q2. Asked to print 2 max salary in emp table.
- Ans.
To find the top two maximum salaries from the emp table, we can use SQL queries with ORDER BY and LIMIT clauses.
Use SQL query: SELECT DISTINCT salary FROM emp ORDER BY salary DESC LIMIT 2;
DISTINCT ensures unique salary values are considered.
ORDER BY salary DESC sorts the salaries in descending order.
LIMIT 2 restricts the output to the top two salaries.
(1 Question)
- Q1. Basic Personal questions.
Total 10ques, 3 from python and java, 4 from SQL.
I applied via Campus Placement and was interviewed in Jul 2024. There were 4 interview rounds.
There were 90 questions that need to solved in 60 min. Only eligible to next round if qualified in this round
(2 Questions)
- Q1. Overriding in java
- Ans.
Overriding in Java allows a subclass to provide a specific implementation of a method that is already provided by its superclass.
Inheritance is a key concept in overriding, where a subclass inherits methods from its superclass.
To override a method, the method in the subclass must have the same name, return type, and parameters as the method in the superclass.
The @Override annotation can be used to ensure that a method ...
- Q2. Inheritance in java
- Ans.
Inheritance in Java allows a class to inherit properties and behaviors from another class.
Allows for code reusability and promotes the concept of 'is-a' relationship
Subclass inherits fields and methods from superclass
Can override methods in subclass to provide specific implementation
Super keyword is used to access superclass methods and fields
Example: class Dog extends Animal {}
(2 Questions)
- Q1. Introduction of yourself
- Ans.
I am a software developer with 5 years of experience in Java, Python, and SQL.
Experienced in Java, Python, and SQL programming languages
Worked on developing web applications using frameworks like Spring and Django
Familiar with database management systems like MySQL and PostgreSQL
- Q2. SQL based questions
(2 Questions)
- Q1. Suggests few places in Hyderabad
- Ans.
Hyderabad is a vibrant city with a mix of historical landmarks, modern attractions, and delicious food options.
Charminar - iconic monument in the heart of the city
Golconda Fort - historic fort with stunning architecture
Hussain Sagar Lake - picturesque lake with a giant Buddha statue
Ramoji Film City - world's largest film studio complex
Birla Mandir - beautiful temple dedicated to Lord Venkateswara
- Q2. Favourite tv show
- Ans.
My favourite TV show is Game of Thrones.
Epic fantasy series with complex characters and storylines
Based on the book series 'A Song of Ice and Fire' by George R.R. Martin
Known for its shocking plot twists and intense battles
Interview Preparation Tips
Skills evaluated in this interview
Apptitude test is so easy it consists of English, technical mcqs
(2 Questions)
- Q1. SQL rank function
- Q2. Difference between count, count(*)
Skills evaluated in this interview
Most of the questions from the quant ,they covered mostly train problems , work and time ,pipes,simple interest,profit and loss
Selected
I applied via Campus Placement and was interviewed in Aug 2024. There was 1 interview round.
Aptitude test based on quantitative,logical,dsa,java,python mcqs
Sairam
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
There will be two sessions in first round , first there will be 60+ of aptitude and second session will be of reasoning which consists of 15 questions ,but overall they will give you 90 mins of time to complete all the questions and result will be displayed immediately whether you qualified for next round or not
There will be coding round after qualifying the first round and these will be hard , many of students will disqualify in this round
Interview Preparation Tips
Top trending discussions
Modak Analytics Interview FAQs
The duration of Modak Analytics interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Modak Analytics Interviews By Designations
- Modak Analytics Software Developer Interview Questions
- Modak Analytics Software Engineer Interview Questions
- Modak Analytics Software Development Engineer Interview Questions
- Modak Analytics Project Manager Interview Questions
- Modak Analytics Application Developer Interview Questions
- Modak Analytics Scrum Master Interview Questions
- Modak Analytics Business Analyst Interview Questions
- Modak Analytics Intern Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 20 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Modak Analytics Reviews and Ratings
based on 47 reviews
Rating in categories
3-8 Yrs
Not Disclosed
|
Software Development Engineer
57
salaries
|  ₹4 L/yr - ₹9 L/yr |
|
Data Engineer
50
salaries
| ₹5 L/yr - ₹13 L/yr |
|
Software Developer
36
salaries
| ₹4.8 L/yr - ₹12 L/yr |
|
Software Engineer
30
salaries
| ₹3.5 L/yr - ₹10.5 L/yr |
|
Hadoop Administrator
19
salaries
| ₹5.6 L/yr - ₹16 L/yr |
Markelytics Solutions
Jasper Colin
GfK MODE
Dunnhumby
- Home >
- Interviews >
- Modak Analytics Interview Questions
