i
JanBask
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 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 Company Website and was interviewed in Sep 2024. There was 1 interview round.
The questions are quite simple.
Two SQL and two Python HackerRank questions.
Questions were asked about the projects listed on my resume, focusing on the technologies used, challenges faced, and results achieved.
Technologies used in the project
Challenges faced during the project
Results achieved from the project
posted on 19 Jul 2024
I applied via Naukri.com and was interviewed in Jun 2024. There were 4 interview rounds.
Databinding in Android allows for easier connection between UI components and data sources.
Databinding eliminates the need for findViewById() calls in your code.
It allows for easier access to data in your layouts using data binding expressions.
Databinding can improve code readability and reduce boilerplate code.
Example:
Packaging process in Android involves compiling the code, resources, and assets into an APK file for distribution.
Compile the Java code into .class files
Compile the resources (XML files, images, etc.) into a binary format
Package all the compiled files into an APK file using the Android Asset Packaging Tool (AAPT)
Sign the APK file with a private key for security
Align the APK file for optimization
MVVM is a design pattern that separates the user interface from the business logic and data model.
MVVM stands for Model-View-ViewModel
Model represents the data and business logic
View represents the user interface
ViewModel acts as an intermediary between the Model and View
MVVM helps in achieving separation of concerns and easier unit testing
I applied via Walk-in and was interviewed in Jul 2024. There were 5 interview rounds.
In Aptitude test contains topics like time, percentages,data interpretation etc.
In this round It is 30 mins we have 25 MCQ questions to attempt it is in Java/Python based questions.
I am a recent graduate with a degree in engineering, passionate about problem-solving and eager to learn and grow in a professional setting.
Recent graduate with a degree in engineering
Passionate about problem-solving
Eager to learn and grow in a professional setting
I have worked on various projects including designing a solar-powered irrigation system and developing a mobile app for waste management.
Designed a solar-powered irrigation system to help farmers in remote areas access water for their crops
Developed a mobile app for waste management to help users locate nearby recycling centers and schedule pickups
Implemented IoT sensors in the irrigation system to monitor soil moistur
Researched online, read about company culture, products, and recent news.
Researched online to learn about company history and values
Read about the products and services offered by the company
Kept up to date with recent news and developments within the company
Checked out employee reviews on platforms like Glassdoor
I am a recent graduate with a degree in engineering, eager to learn and grow in a professional setting.
Recent graduate with a degree in engineering
Eager to learn and grow in a professional setting
Strong problem-solving skills
Experience with technical projects during studies
Content Writer
5
salaries
| ₹2.2 L/yr - ₹4.5 L/yr |
SEO Executive
5
salaries
| ₹2.4 L/yr - ₹2.5 L/yr |
Software Engineer
4
salaries
| ₹1.8 L/yr - ₹6 L/yr |
Software Developer
4
salaries
| ₹0.6 L/yr - ₹8 L/yr |
Senior UI Developer
4
salaries
| ₹6 L/yr - ₹17 L/yr |
TCS
Infosys
Wipro
HCLTech