i
Excellis IT
Filter interviews by
Be the first one to contribute and help others!
posted on 17 Dec 2024
I applied via Instahyre and was interviewed in Nov 2024. There was 1 interview round.
Use SQL query to count number of reportees for each manager and filter out those with atleast 5 reportees.
Write a SQL query to count number of reportees for each manager using GROUP BY clause
Add HAVING clause to filter out managers with atleast 5 reportees
Example: SELECT managerId, COUNT(id) AS num_reportees FROM table_name GROUP BY managerId HAVING num_reportees >= 5
Use libraries like pandas and dask to efficiently manage large datasets in Python.
Use pandas library for data manipulation and analysis.
Use dask library for parallel computing and out-of-core processing.
Optimize memory usage by loading data in chunks or using data types efficiently.
Consider using cloud services like AWS S3 or Google BigQuery for storing and processing large datasets.
Some commonly used Python libraries for Data Analysts are Pandas, NumPy, Matplotlib, and Scikit-learn.
Pandas - used for data manipulation and analysis
NumPy - used for numerical computing and working with arrays
Matplotlib - used for data visualization
Scikit-learn - used for machine learning and data mining
I applied via Company Website and was interviewed in Dec 2024. There were 2 interview rounds.
A session in PHP is a way to store information (variables) to be used across multiple pages.
Sessions are used to store user data on the server for later use
Sessions are identified by a unique session ID, usually stored in a cookie
Session data is stored on the server side, making it more secure than using cookies alone
Variables can be changed during the execution of a script, while constants cannot be changed once they are defined.
Variables can be reassigned with new values, while constants cannot be changed once defined
Constants are defined using the define() function, while variables are assigned using the $ symbol
Constants are case-sensitive by default, while variables are case-insensitive
The code will output 'Hello World!' because the variable $x is set to true.
The code will check if $x is true, which it is, so it will output 'Hello World!'
The if statement will only execute if the condition is true, in this case $x is true.
What are the differences between echo and print in PHP?
posted on 23 Jan 2025
posted on 31 Aug 2024
I was interviewed in Aug 2024.
Developed web applications for data visualization and analysis
Created interactive dashboards using Plotly and Dash
Implemented data processing pipelines with Pandas and NumPy
Utilized Flask for backend development
Collaborated with data scientists to integrate machine learning models
It includes questions from aptitude as well as coding related questions, JAVA was the most common language in which majority of the coding questions were
posted on 6 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.
Easy you will have enough time to solve the questions
posted on 8 Jan 2025
I applied via Naukri.com and was interviewed in Dec 2024. There was 1 interview round.
Segregate odd and even numbers in an integer array without using another array
Iterate through the array and maintain two pointers, one for odd numbers and one for even numbers
Swap elements at the odd and even pointers until all odd numbers are on one side and even numbers on the other
Example: Input array [3, 6, 8, 5, 4], Output array [6, 8, 4, 5, 3]
posted on 7 Oct 2024
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
To reverse a string and find the occurrence of a character in Java.
Use StringBuilder to reverse the string.
Use a loop to iterate through the string and count the occurrences of the character.
Use the charAt() method to access individual characters in the string.
To take a screenshot in Selenium, use the getScreenshotAs method
Create a WebDriver instance
Use the getScreenshotAs method to capture the screenshot
Save the screenshot to a file using File class
Getter and setter methods are used to access and modify the values of private variables in a class.
Create a method with the prefix 'get' followed by the variable name to retrieve its value.
Create a method with the prefix 'set' followed by the variable name to set its value.
Ensure the getter method returns the value of the variable and the setter method updates the variable with the passed value.
Object-oriented programming paradigm and its four pillars: Inheritance, Encapsulation, Abstraction, Polymorphism
Inheritance: Allows a class to inherit properties and behavior from another class
Encapsulation: Bundling data and methods that operate on the data into a single unit
Abstraction: Hiding the complex implementation details and showing only the necessary features
Polymorphism: Ability to present the same interface
I applied via LinkedIn and was interviewed in Oct 2024. There were 3 interview rounds.
Duration was 1 hour. First asked verbal technical questions based on deep learning concepts, then asked me to code an easy leet code problem.
This round was with the hiring manager. It was mostly like a technical discussion, but he started by discussing the projects that I had worked on from my resume. Then it eventually turned into a system design type of a round.
Frontend code quality is crucial for performance, maintainability, and scalability of web applications.
Consistent coding style and conventions improve readability and maintainability.
Modular and reusable code components enhance scalability and reduce duplication.
Regular code reviews and testing ensure high quality and bug-free code.
Optimizing performance by minimizing file sizes, reducing HTTP requests, and using effic...
based on 24 reviews
Rating in categories
Web Consultant
7
salaries
| ₹1.4 L/yr - ₹2.5 L/yr |
Graphic Designer
5
salaries
| ₹1.9 L/yr - ₹5 L/yr |
SEO Executive
5
salaries
| ₹1.9 L/yr - ₹2.5 L/yr |
Software Developer
4
salaries
| ₹3 L/yr - ₹4.5 L/yr |
Data Scientist
4
salaries
| ₹3.8 L/yr - ₹6.5 L/yr |
TCS
Infosys
Wipro
HCLTech