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 Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
Agile values include individuals and interactions over processes and tools, while Scrum values include commitment, courage, focus, openness, and respect.
Agile values prioritize individuals and interactions over processes and tools
Scrum values include commitment, courage, focus, openness, and respect
Scrum ceremonies include Sprint Planning, Daily Standup, Sprint Review, and Sprint Retrospective
Story points are a unit of...
As a project manager, I prepare various documents such as project plans, schedules, budgets, risk assessments, and progress reports. I contribute by leading the team, managing resources, and ensuring project success.
Prepare project plans outlining scope, objectives, deliverables, and timelines
Create schedules to allocate tasks and track progress
Develop budgets to manage project costs effectively
Conduct risk assessments...
Provide clear expectations, offer support and training, provide feedback and recognition, set goals and milestones.
Clearly communicate expectations and goals to the resource.
Offer support and training to help the resource improve their skills and knowledge.
Provide regular feedback and recognition for progress made.
Set specific goals and milestones to track improvement.
Create a development plan with the resource to addr...
Scrum of Scrums is a scaled agile framework where multiple Scrum teams coordinate their work. PI planning is a key event in SAFe where teams plan their work for the upcoming Program Increment.
Scrum of Scrums involves representatives from each Scrum team meeting regularly to discuss dependencies and progress.
PI planning is a two-day event where teams align on their objectives, dependencies, and priorities for the upcomi...
I applied via Campus Placement and was interviewed in Sep 2024. There were 4 interview rounds.
Pretty standard GD on topics around working remotely and country's macroeconomic
Derivative and alternative investments involve complex financial instruments and strategies beyond traditional stocks and bonds.
Derivatives are financial contracts whose value is derived from an underlying asset, index, or rate. Examples include options, futures, and swaps.
Alternative investments are non-traditional assets such as private equity, hedge funds, real estate, and commodities.
Both derivative and alternative...
Code Snept question with 3-4 Reasoning question. Google form
Pen paper coding round. String , Array . Linkedlist , graph, questions
To find the nearest prime number, iterate from the given number in both directions until a prime number is found.
Start iterating from the given number in both directions to find the nearest prime number.
Check if a number is prime by dividing it by all numbers less than its square root.
Keep track of the closest prime number found during the iteration.
Find the second maximum number in an array of strings.
Convert the array of strings to an array of integers.
Sort the array in descending order.
Return the second element in the sorted array.
I applied via Approached by Company and was interviewed in Aug 2024. There were 3 interview rounds.
AB testing is a method used to compare two versions of a webpage or app to determine which one performs better.
AB testing involves creating two versions (A and B) of a webpage or app with one differing element
Users are randomly assigned to either version A or B to measure performance metrics
The version that performs better in terms of the desired outcome is selected for implementation
Example: Testing two different call...
It was a classification problem
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.
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
The company is a leading technology firm specializing in software development and IT solutions.
Founded in 2005
Headquartered in Silicon Valley
Offers a wide range of services including web development, mobile app development, and cloud computing
Clients include Fortune 500 companies and startups
Clients can be identified through various methods such as networking, referrals, market research, and online presence.
Networking events and conferences
Referrals from existing clients or business partners
Market research to identify potential clients in target industries
Online presence through social media, website, and online directories
I was interviewed in Nov 2024.
Questions related to rfp and procurement law
posted on 24 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
Performance optimization techniques for React JS frontend development
Use React.memo for optimizing functional components
Avoid unnecessary re-renders by using shouldComponentUpdate or PureComponent for class components
Implement code splitting to reduce initial load time
Use lazy loading for components that are not immediately needed
Optimize images and assets for faster loading times
Minimize the use of inline styles and u...
posted on 13 Dec 2024
Question directly come from the leetcode.
based on 9 reviews
Rating in categories
Software Developer
7
salaries
| ₹2.1 L/yr - ₹10 L/yr |
Technical Recruiter
5
salaries
| ₹4 L/yr - ₹6.9 L/yr |
Senior Technical Recruiter
5
salaries
| ₹6.1 L/yr - ₹9.2 L/yr |
System Administrator
4
salaries
| ₹4.2 L/yr - ₹6.1 L/yr |
QA Engineer
4
salaries
| ₹5.5 L/yr - ₹5.5 L/yr |
Infosys
TCS
Wipro
HCLTech