AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Filter interviews by
Pitangent Analytics & Technology Solutions Interview Questions, Process, and Tips
Top Pitangent Analytics & Technology Solutions Interview Questions and Answers
- Q1. How can I fetch 1st, 2nd, 3rd rank from student mark table?asked in Software Engineer interview
- Q2. what is many to many relationships? give an example.asked in Software Engineer interview
- Q3. How can you connect database into a Laravel framework?asked in Software Engineer interview
Pitangent Analytics & Technology Solutions Interview Experiences
4 interviews found
Anonymous
Selected
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Educational Background
DOT NET Developer Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.
(4 Questions)
- Q1. What are your salary expectations?
- Q2. Share details of your previous job.
- Q3. Why are you looking for a change?
- Q4. Tell me about yourself.
(25 Questions)
- Q1. What is php stands for?
- Ans.
PHP stands for Hypertext Preprocessor.
PHP is a server-side scripting language used for web development.
It can be embedded into HTML code.
PHP code is executed on the server, generating HTML that is sent to the client's browser.
PHP can interact with databases, create dynamic content, and handle forms.
Popular websites like Facebook and Wikipedia use PHP.
- Q2. What is migration in Laravel?
- Ans.
Migration in Laravel is a way to manage database schema changes.
Migration allows developers to modify database schema using PHP code instead of SQL.
It helps in version control of database schema.
It provides a way to rollback changes made to the database schema.
Laravel provides a command-line interface to create and manage migrations.
Example: php artisan make:migration create_users_table --create=users
- Q3. What is seeder in Laravel?
- Ans.
Seeder is a database seeding tool in Laravel.
Seeder is used to populate the database with test data.
It is used to insert data into database tables.
Seeder classes are stored in the database/seeds directory.
Seeder can be run using the 'php artisan db:seed' command.
Seeder can also be used to generate fake data using Faker library.
- Q4. How can you connect database into a Laravel framework?
- Ans.
Database connection in Laravel framework
Configure database credentials in .env file
Update database configuration in config/database.php
Use Eloquent ORM to interact with database
Run migrations to create database tables
Use database queries to retrieve data
- Q5. What is artisan in Laravel?
- Ans.
Artisan is the command-line interface included with Laravel.
Artisan provides a set of helpful commands for developers.
It can be used to generate boilerplate code, run database migrations, and more.
Developers can also create their own custom Artisan commands.
Artisan commands can be run using the 'php artisan' command in the terminal.
- Q6. What is Inheritance in php?
- Ans.
Inheritance is a mechanism in PHP that allows a class to inherit properties and methods from another class.
A child class can inherit properties and methods from a parent class
The keyword 'extends' is used to inherit a class
Inherited methods and properties can be overridden in the child class
Inheritance promotes code reusability and saves time
Example: class ChildClass extends ParentClass {}
- Q7. What is access modifier?
- Ans.
Access modifier is a keyword that determines the visibility and accessibility of a class, method, or variable.
Access modifiers are public, private, protected, and default.
Public access modifier allows unrestricted access to the class, method, or variable.
Private access modifier restricts access to the class, method, or variable within the same class.
Protected access modifier allows access to the class, method, or varia...
- Q8. What is constructor in php?
- Ans.
Constructor is a special method in PHP classes that is automatically called when an object is created.
Constructors have the same name as the class
They can accept parameters
They are used to initialize object properties
If no constructor is defined, a default one is used
Constructors can be overloaded
- Q9. What is model in Laravel?
- Ans.
Model in Laravel is a PHP class that interacts with a database table.
Models are used to retrieve and store data in a database.
They represent a table in the database and define its structure.
Models can have relationships with other models.
They can also have methods for performing common database operations.
Laravel provides an ORM (Object-Relational Mapping) to work with models.
- Q10. What is MVC stands for?
- Ans.
MVC stands for Model-View-Controller, a software design pattern used for developing web applications.
MVC separates an application into three interconnected components: Model, View, and Controller.
Model represents the data and business logic of the application.
View is responsible for rendering the user interface.
Controller handles user input and updates the model and view accordingly.
MVC promotes separation of concerns ...
- Q11. How MVC works for an application?
- Ans.
MVC is a software design pattern that separates an application into three interconnected components: Model, View, and Controller.
Model represents the data and business logic of the application
View is responsible for displaying the data to the user
Controller handles user input and updates the model and view accordingly
MVC promotes separation of concerns and modularity
Examples of MVC frameworks include Ruby on Rails, ASP
- Q12. What is ORM in Laravel?
- Ans.
ORM stands for Object-Relational Mapping. It is a technique used to map database tables to classes in Laravel.
ORM simplifies database operations by allowing developers to interact with the database using object-oriented syntax.
Laravel's ORM is called Eloquent and it provides a simple and elegant syntax for working with databases.
Eloquent allows developers to define relationships between database tables using model clas...
- Q13. How many relationships in Laravel?
- Q14. What is many to many relationships? give an example.
- Ans.
Many to many relationships refer to a situation where multiple instances of one entity are related to multiple instances of another entity.
It involves three tables: two entities and a junction table
Example: A student can enroll in multiple courses and a course can have multiple students enrolled
The junction table will have foreign keys from both entities
- Q15. How can I fetch 1st, 2nd, 3rd rank from student mark table?
- Ans.
To fetch 1st, 2nd, 3rd rank from student mark table, we need to sort the table in descending order and select the top 3 rows.
Sort the student mark table in descending order based on the marks column.
Select the top 3 rows from the sorted table.
The first row will have the highest marks and hence the first rank, second row will have the second highest marks and hence the second rank, and so on.
- Q16. What is array and tell me the types with example?
- Ans.
An array is a collection of similar data types stored in contiguous memory locations.
Arrays can be of different types such as integer, float, character, etc.
For example, int arr[5] is an array of 5 integers.
Another example is char str[10] which is an array of 10 characters.
Arrays can also be multidimensional, such as int arr[3][4] which is a 3x4 matrix of integers.
- Q17. What is service container?
- Ans.
A service container is a tool that manages the creation and configuration of objects in a software application.
It is used to manage dependencies between objects.
It allows for easy swapping of implementations.
It can be used to configure and manage application settings.
Examples include Laravel's service container and Symfony's dependency injection container.
- Q18. What is service provider?
- Ans.
A service provider is a company or organization that provides a service to customers or clients.
Service providers offer a range of services, such as internet, phone, or cable TV.
They may also provide professional services, such as legal or accounting services.
Service providers may be private companies or government agencies.
Examples of service providers include Comcast, Verizon, and Deloitte.
Service providers are often...
- Q19. What is namespace in laravel?
- Ans.
Namespace is a way to organize code and avoid naming conflicts in Laravel.
Namespaces are defined using the namespace keyword followed by the namespace name.
In Laravel, namespaces are used to organize controllers, models, and other classes.
For example, the namespace for a controller named UserController would be App\Http\Controllers.
Namespaces can also be used to import classes from other namespaces using the use keywor
- Q20. What is default view engine in Laravel?
- Ans.
Blade is the default view engine in Laravel.
Blade is a templating engine that allows you to write clean and concise templates.
It provides features like template inheritance, sections, and layouts.
You can also use other view engines like Twig or Smarty in Laravel.
- Q21. What is api in Laravel?
- Ans.
API in Laravel is a set of routes and controllers that allow external applications to interact with the Laravel application.
API stands for Application Programming Interface
API in Laravel is used to expose certain functionalities of the application to external applications
API routes are defined in the 'routes/api.php' file
API controllers are stored in the 'app/Http/Controllers/Api' directory
API responses are usually in
- Q22. How can we use api in Laravel?
- Ans.
APIs can be used in Laravel by creating routes and controllers to handle requests and responses.
Create a route in the routes/api.php file
Define a controller method to handle the API request
Use the appropriate HTTP verb (GET, POST, PUT, DELETE) for the API endpoint
Return a JSON response from the controller method
Use Laravel's built-in API authentication middleware for secure APIs
- Q23. What is soft delete in database?
- Ans.
Soft delete is a technique to mark a record as deleted without actually deleting it from the database.
Soft delete is used to retain data for future reference or audit purposes.
It involves adding a column to the table to indicate the deleted status of a record.
The deleted records can be filtered out using a WHERE clause in SQL queries.
Soft delete can be undone by updating the deleted status of a record.
Examples of soft ...
- Q24. What is Faker, Factory in Laravel?
- Ans.
Faker is a PHP library used to generate fake data. Factory is a Laravel feature that uses Faker to generate model instances.
Faker is used to generate fake data for testing and seeding databases
Factory is a Laravel feature that uses Faker to generate model instances
Faker can generate various types of data such as names, addresses, phone numbers, and more
Factory can be used to create multiple instances of a model with di
- Q25. What is foreign key, unique key? difference between them.
- Ans.
Foreign key and unique key are both used to enforce data integrity in a database, but they serve different purposes.
A foreign key is a field in a table that refers to the primary key of another table, establishing a relationship between the two tables.
A unique key is a constraint that ensures that a column or set of columns in a table contains only unique values.
A foreign key is used to enforce referential integrity, w...
They give me a short project with 3 hours time to complete this.
Question -
Register, Login, go to dashboard, list of products (name, image), make 100 products using seeder, factory, faker, and also view products with comments and sub-comment functionality, use front-end validation.
(5 Questions)
- Q1. What are your salary expectations?
- Q2. Rules and regulations for their company!
- Q3. Notice period and Bond sign discussion
- Q4. Then, from which date I can join?
- Q5. And another documentation and onboarding related documents submission.
Interview Preparation Tips
Please be confident, if you don't know any answers please say sorry, I'm not aware of this question, pleas don't create any hesitation, or confusion in front of them.
And at last I want to say, don't give up, if you get rejection, do not sad or regret this. Please note down why this happen? Make sure be prepared this things before attempting next. If you re-create yourself, motivate yourself, prepare yourself self, no one can beat you.
All the best for your upcoming days. Go ahead.
And also thank you Naukri for such kind of opportunity to tell about my journey in front of them. Thank you so much.
Skills evaluated in this interview
Top Pitangent Analytics & Technology Solutions Software Engineer Interview Questions and Answers
Software Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Mar 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic php functions, array, MySQL related question ex- join
(1 Question)
- Q1. Generally regarding job role and salary structure.
Interview Preparation Tips
Top Pitangent Analytics & Technology Solutions Software Engineer Interview Questions and Answers
Software Engineer Interview Questions asked at other Companies
Selected
I applied via Indeed and was interviewed before May 2022. There were 3 interview rounds.
Create CRUD operation with your technology
(2 Questions)
- Q1. Salary expectation
- Q2. Work experience
Interview Preparation Tips
Be ready for CRUD operation in your technology in technical round
Mern Stack Developer Interview Questions asked at other Companies
Pitangent Analytics & Technology Solutions interview questions for popular designations
Top trending discussions
Interview questions from similar companies
I was interviewed in Jun 2017.
Interview Questionnaire
12 Questions
- Q1. Write the annotation for controller?
- Ans.
An annotation for controller in software engineering.
The annotation for controller is used to define the class as a controller in a software application.
It is typically used in frameworks like Spring MVC or ASP.NET MVC.
The annotation helps in mapping the incoming requests to the appropriate controller methods.
It can also be used to specify the URL path for the controller.
Example: @Controller in Spring MVC, [ApiControll
- Q2. Write the annotation for request mapping?
- Ans.
The annotation for request mapping is used to map HTTP requests to specific methods in a controller class.
The annotation is @RequestMapping
It can be used at the class level to specify a common base URL for all methods in the class
It can also be used at the method level to specify the URL path and HTTP method for a specific method
Additional attributes can be used to further customize the mapping, such as specifying requ...
- Q3. What is front controller from context in spring mvc?
- Ans.
Front controller is a design pattern used in Spring MVC to handle incoming requests and route them to appropriate handlers.
Front controller acts as a central point of control for handling requests in Spring MVC.
It receives all incoming requests and delegates them to appropriate handlers called controllers.
Front controller provides a consistent way to handle requests and perform common tasks like authentication, logging...
- Q4. Write the css box model?
- Ans.
The CSS box model describes the layout and sizing of elements on a web page.
The box model consists of content, padding, border, and margin.
Content refers to the actual content of the element, such as text or images.
Padding is the space between the content and the border.
Border is a line that surrounds the padding and content.
Margin is the space outside the border, separating the element from other elements.
The width an...
- Q5. Select all div using jquery
- Ans.
Select all div using jQuery
Use the jQuery selector $('div') to select all div elements
This will return a jQuery object containing all the selected div elements
You can then perform operations on the selected div elements using jQuery methods
- Q6. Change all ul element to blue background color using jquery
- Ans.
Use jQuery to change the background color of all ul elements to blue.
Use the jQuery selector to select all ul elements
Use the css() method to change the background color to blue
- Q7. Change first li element to yellow background color using jquery
- Ans.
Use jQuery to change the background color of the first li element to yellow.
Use the :first-child selector to select the first li element
Use the css() method to change the background color to yellow
- Q8. Output of this var arr=[1,2,3,4,5] arr.push(6) arr.unshift(1) arr.pop() arr.shift()
- Ans.
The output of the given code is [1, 2, 3, 4, 5, 6].
The 'push' method adds an element to the end of the array.
The 'unshift' method adds an element to the beginning of the array.
The 'pop' method removes the last element from the array.
The 'shift' method removes the first element from the array.
- Q9. What are the uses of final in java
- Ans.
The 'final' keyword in Java is used to declare constants, prevent method overriding, and ensure thread safety.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden by subclasses
Final classes cannot be extended by other classes
Final parameters ensure that they cannot be modified within a method
Final fields can be used to achieve thread safety
- Q10. Public static void getsum(int a,int b){System.out.println("a b method");}public static void getsum(int a,int b,int c){System.out.println("a b c method");}public static void getsum(int a,int ...b){System.o...
- Ans.
The question is about method overloading in Java.
Method overloading allows multiple methods with the same name but different parameters.
The method to be called is determined at compile-time based on the arguments passed.
In the given code, there are three overloaded methods with the same name 'getsum'.
The first method takes two integers as arguments.
The second method takes three integers as arguments.
The third method ta...
- Q11. Output of this program public static int floating(int x){ return x*floating(x-1); } public static void main(String[] args){ floating(10); }
- Ans.
The program will result in a StackOverflowError due to infinite recursion.
The 'floating' method is recursively calling itself without a base case to stop the recursion.
Each recursive call multiplies the input parameter by the result of the recursive call with a decremented parameter.
This will continue indefinitely until the stack overflows and an error is thrown.
- Q12. What is the output of this int i=0; int j=10;do{ if(i++ < --j){ } }while(i
- Ans.
The output of the code is 9.
The code initializes i as 0 and j as 10.
Inside the do-while loop, i is incremented by 1 and j is decremented by 1.
The loop continues until i becomes greater than or equal to j.
Since i is incremented before the comparison and j is decremented before the comparison, the loop runs 9 times.
Therefore, the output is 9.
Interview Preparation Tips
Skills evaluated in this interview
I was interviewed before Apr 2021.
(3 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions on CSS and Jquery mainly.
- Q1. What is the CSS box model?
- Ans.
The CSS box model is a design and layout concept that defines the structure and sizing of elements on a web page.
It consists of content, padding, border, and margin around an element.
Content area is where text and images are displayed.
Padding is the space between the content and the border.
Border is the line that goes around the padding and content.
Margin is the space outside the border.
Example: div { width: 200px; pad...
- Q2. How do you select all div elements using jQuery?
- Ans.
To select all div elements using jQuery, use the selector $('div').
Use the jQuery selector $('div') to select all div elements on the page.
You can also use the find() method to select div elements within a specific parent element.
To perform actions on the selected div elements, use jQuery methods like css(), text(), or addClass().
- Q3. How can you change the background color of all items in JavaScript?
- Ans.
You can change the background color of all items in JavaScript by selecting all elements and setting their background color property.
Select all elements using document.querySelectorAll()
Loop through the selected elements and set their style.backgroundColor property
Example: document.querySelectorAll('.item').forEach(item => item.style.backgroundColor = 'blue');
(4 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical Interview round with questions on Java mainly.
- Q1. What are the uses of the final keyword in Java?
- Ans.
The final keyword in Java is used to define constants, prevent method overriding, and make a class immutable.
Final variables cannot be reassigned once initialized
Final methods cannot be overridden in subclasses
Final classes cannot be extended
- Q2. What is the Front Controller in Spring MVC?
- Ans.
Front Controller in Spring MVC is a design pattern that handles all requests and acts as a central point of control.
Front Controller is a servlet in Spring MVC that receives all requests and then dispatches them to the appropriate handlers.
It helps in centralizing request handling logic, improving code organization and reducing duplication.
Front Controller can perform tasks like authentication, logging, exception handl...
- Q3. What is the annotation for request mapping in Java?
- Ans.
The annotation for request mapping in Java is @RequestMapping.
@RequestMapping annotation is used to map web requests to specific handler methods in Spring MVC.
It can be applied at class level or method level to specify the URL path that the controller will handle.
You can also specify HTTP request methods, headers, parameters, and more using @RequestMapping.
- Q4. What is the annotation used for a controller in Java?
- Ans.
The annotation used for a controller in Java is @RestController.
Used to define a class as a controller in Spring MVC
Automatically serializes return objects into JSON/XML responses
Equivalent to @Controller + @ResponseBody annotations
Round duration - 30 minutes
Round difficulty - Easy
This was a typical HR round.
Interview Preparation Tips
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.
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.
Skills evaluated in this interview
I applied via Job Portal and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic js concepts
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. About informatica and sql
I was interviewed before May 2021.
(2 Questions)
Round duration - 90 Minutes
Round difficulty - Medium
The round was scheduled in afternoon time.
HackerEarth test link was shared beforehand
All the instructions were provided in the welcome page of test link.
It was proctored test
- Q1.
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.
Validate if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.
Remove special characters and spaces from the input string
Convert the string to lowercase
Check if the modified string is equal to its reverse to determine if it's a palindrome
- Q2.
Find First Repeated Character in a String
Given a string 'STR' composed of lowercase English letters, identify the character that repeats first in terms of its initial occurrence.
Example:
Input:
STR =...
- Ans.
Find the first repeated character in a given string of lowercase English letters.
Iterate through the string and keep track of characters seen so far
Return the first character that repeats, if none, return '%'
Use a hash set or array to store characters seen
(1 Question)
Round duration - 35 minutes
Round difficulty - Medium
It was in afternoon 3pm.
Interview platform was Microsoft teams.
Interview link was shared a day before.
Interviewer was professional.
- Q1.
Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
... - Ans.
Given an array and a target sum, find pairs of elements that add up to the target sum.
Iterate through the array and for each element, check if the complement (target sum - current element) is present in a hash set.
If the complement is found, add the pair to the result list.
Sort the pairs based on the first element, and if the first elements are equal, sort based on the second element.
(2 Questions)
Round duration - 25 Minutes
Round difficulty - Medium
It was held around 4pm.
Scheduled on MS teams.
Interview link shared one day before.
The interviewer was pretty chill and made me comfortable.
- Q1. How would you handle a situation where a company approaches you during a pandemic and states that demand is high but supply is low?
- Q2. Why do you want to join this company?
Interview Preparation Tips
Tip 1 : Practice coding questions till you are able to tackle medium level questions easily
Tip 2 : Be proficient in the project which you have mentioned in your resume.
Tip 1 : Never Lie about technologies you know
Tip 2 : Project shouldn't be copied from online sources even if you take help then do some your own tweaks or add new features and you should know all workings of project
Skills evaluated in this interview
I was interviewed before May 2021.
(1 Question)
Round duration - 90 minutes
Round difficulty - Easy
- Q1.
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link... - Ans.
Reverse a singly linked list of integers and return the head of the reversed linked list.
Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.
Use three pointers to keep track of the current, previous, and next nodes while reversing the linked list.
Update the head of the reversed linked list as the last node encountered during the reversal process.
(1 Question)
Round duration - 60 minutes
Round difficulty - Easy
- Q1. You have a puzzle involving 4 liters of water. Can you describe the details of this puzzle?
(1 Question)
Round duration - 40 minutes
Round difficulty - Easy
- Q1. You were given CSS code and asked to debug it to make the functionality work. Can you describe the process you followed and the issues you encountered?
- Ans.
I followed a systematic process to debug CSS code and resolve functionality issues.
Reviewed the CSS code to identify any syntax errors or typos
Checked for any conflicting styles that may be overriding the desired functionality
Used browser developer tools to inspect elements and troubleshoot layout issues
Tested different scenarios to pinpoint the exact cause of the problem
Made necessary adjustments to the CSS code to fi
Interview Preparation Tips
Tip 1 : If you are looking for fullstack roles, prepare CSS well
Tip 2 : Prepare 2 pointer Array questions
Tip 1 : If you have any python or cloud related experience, do put it and make it stand out.
Tip 2 : They would lay more emphasis on the projects, sometimes even more than the interview itself.
Skills evaluated in this interview
Pitangent Analytics & Technology Solutions Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
Pitangent Analytics & Technology Solutions Interview Process
based on 3 interviews
Interview experience
Interview Questions from Similar Companies
Pitangent Analytics & Technology Solutions Reviews and Ratings
based on 51 reviews
Rating in categories
|
Software Engineer
14
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Jr. Data Scientist
11
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Web Developer
7
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Front end Developer
6
salaries
| ₹0 L/yr - ₹0 L/yr |
Fractal Analytics
Mu Sigma
Tiger Analytics
LatentView Analytics
- Home >
- Interviews >
- Pitangent Analytics & Technology Solutions Interview Questions
