Filter interviews by
I appeared for an interview before Mar 2024.
Constructing a client's data model into LLD involves defining data structures and their relationships for implementation.
Identify key entities: Determine the main objects in the client's domain, e.g., 'Patient', 'Appointment'.
Define attributes: Specify the properties of each entity, e.g., 'Patient' may have 'Name', 'DOB', 'MedicalHistory'.
Establish relationships: Determine how entities interact, e.g., 'Patient' has man...
Optimizing DB performance with complex SQL involves efficient query design, indexing, and leveraging database features.
Use indexing to speed up data retrieval. For example, create an index on columns frequently used in WHERE clauses.
Optimize JOIN operations by ensuring that the joined columns are indexed. For instance, use INNER JOIN instead of OUTER JOIN when possible.
Utilize subqueries and Common Table Expressions (C...
The appraisal process involves setting goals, continuous feedback, and formal evaluations to enhance team performance.
Set clear performance goals collaboratively with each team member, e.g., achieving specific project milestones.
Conduct regular one-on-one meetings to provide ongoing feedback and address any concerns, e.g., weekly check-ins.
Implement a mid-year review to assess progress and adjust goals as necessary, e....
I am flexible with my start date and can accommodate the team's needs while ensuring a smooth transition.
I can start immediately if needed, as I am currently not bound by any commitments.
If a later start date is preferred, I can use that time to prepare and familiarize myself with the team and projects.
I understand the importance of onboarding, so I am open to a staggered start if that helps the team.
For example, if th...
I applied via Campus Placement and was interviewed in Oct 2022. There were 4 interview rounds.
Mostly aptitude and logical reasoning question were asked they were easy if you have little bit knowledge in these subjects.
It was also easy they give a random topic and we just have to speak even though you are nowhere right they just see how confident you are in front of other people what various points you can make.
My final year project was on logistic regression.
Logistic regression is a statistical model used to predict binary outcomes.
It is a type of regression analysis where the dependent variable is categorical.
The model estimates the probability of the outcome based on the input variables.
It uses a logistic function to map the predicted values to probabilities.
The model is commonly used in various fields like finance, market...
Hypothesis testing is a statistical method to test a hypothesis about a population parameter. P-value is the probability of observing a test statistic as extreme as the one computed from the sample data, assuming the null hypothesis is true.
Hypothesis testing involves formulating a null hypothesis and an alternative hypothesis
A test statistic is computed from the sample data and compared with a critical value or p-valu...
Bias is the difference between predicted values and actual values, while variance is the variability of model predictions.
Bias is the error caused by oversimplification of the model, while variance is the error caused by overcomplication of the model.
High bias leads to underfitting, while high variance leads to overfitting.
Bias and variance are inversely proportional, meaning reducing one increases the other.
An example...
Machine learning is a subset of AI that involves training machines to learn from data. Deep learning is a subset of machine learning that uses neural networks to learn from large amounts of data.
Machine learning involves training machines to learn from data and make predictions or decisions based on that data.
Deep learning is a subset of machine learning that uses neural networks to learn from large amounts of data.
Dee...
We use sample over population to save time, money and resources.
Sampling is less time-consuming and cost-effective than studying the entire population.
Sampling helps to reduce errors and biases that may occur in studying the entire population.
Sampling is useful when the population is too large to study in its entirety.
Sampling can provide accurate results if the sample is representative of the population.
I applied via Walk-in and was interviewed in Oct 2022. There were 2 interview rounds.
Data is shared between components through props and state in React.
In React, data is passed down from parent components to child components through props.
Components can also have their own state which can be updated and passed down to child components.
Redux can also be used for managing global state and sharing data between components.
In Angular, data can be shared between components through services or by using @Input...
Storages are devices used to store data and information.
Storages can be internal or external to a device
Examples of internal storages are hard disk drives and solid-state drives
Examples of external storages are USB flash drives and external hard drives
Cloud storage is a type of external storage that allows data to be stored remotely
Storages can have different capacities and speeds
I applied via Naukri.com and was interviewed before May 2023. There were 3 interview rounds.
Oops concepts are fundamental principles of object-oriented programming. getWindowHandle() returns the handle of the current window, while getWindowHandles() returns the handles of all open windows.
Oops concepts include inheritance, polymorphism, encapsulation, and abstraction.
Inheritance: Reusing code from a parent class in a child class.
Polymorphism: Objects of different classes can be treated as objects of a common ...
Cambridge Technology Enterprises interview questions for popular designations
Top trending discussions
I am a detail-oriented business analyst with experience in data analysis and process improvement.
I have a Bachelor's degree in Business Administration
I have worked with various stakeholders to identify business needs and requirements
I am proficient in SQL and Excel for data analysis
I have experience in process improvement and project management
I am a strong communicator and collaborator
I have completed a business analyst certification course and have interned at a software development company.
Completed a business analyst certification course from XYZ Institute
Interned at ABC Software Development Company for 6 months
Worked on requirement gathering, documentation and analysis for a project
Assisted senior business analysts in creating project plans and reports
The Instrumentation Department is responsible for designing, installing, and maintaining control systems and instruments used in industrial processes.
Designing and implementing control systems for industrial processes
Installing and maintaining instruments used in industrial processes
Ensuring accuracy and reliability of instruments and control systems
Collaborating with other departments to optimize processes and improve...
I am excited to join Affine Analytics because of their reputation for delivering innovative solutions and their focus on employee growth.
Affine Analytics has a strong track record of delivering cutting-edge solutions to clients across industries.
I am impressed by the company's commitment to employee growth and development, as evidenced by their training and mentorship programs.
I am excited about the opportunity to work...
Data analytics allows me to use my technical skills to solve business problems and make data-driven decisions.
Data analytics helps me to identify patterns and trends in data that can be used to improve business processes.
It allows me to work with large datasets and use statistical methods to extract insights.
I can use my technical skills to develop and implement data models and algorithms.
Data analytics is a growing fi...
No, two diodes in series cannot work as a transistor.
Transistors have three terminals while diodes have two.
Transistors can amplify signals while diodes cannot.
Transistors can be used as switches while diodes cannot.
Diodes in series will only increase the voltage drop.
Transistors have different modes of operation such as common emitter, common base, and common collector.
I developed a drone that can detect and monitor forest fires.
Designed and built a drone with thermal imaging camera
Integrated machine learning algorithm to detect fire
Tested and validated the drone in a controlled forest environment
Presented the project at a national engineering conference
I play badminton twice a week as a hobby.
I enjoy playing badminton as a way to stay active and relieve stress.
I usually play with friends or family members at a local community center.
I have been playing badminton for several years and have improved my skills over time.
No, I don't have any problem working in Bangalore.
I am familiar with the city and its culture
I have worked in Bangalore before and enjoyed my experience
I am open to new experiences and challenges
I am willing to adapt to the local environment and work culture
Real Madrid is my favorite because of their rich history, success, and style of play.
Real Madrid has won a record 13 Champions League titles, which is a testament to their success
Their style of play is attractive and entertaining to watch
The club has a rich history and has had some of the greatest players in football history, such as Cristiano Ronaldo and Zinedine Zidane
Factors to consider before going App only as CEO of Flipkart
Analyze the data from website and app to understand user behavior
Evaluate the impact on sales and revenue
Consider the potential loss of customers who prefer website over app
Assess the cost of developing and maintaining the app
Evaluate the competition and their strategies
Consider the impact on brand image and customer loyalty
Assess the feasibility of providing ...
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
Use conditional formatting to highlight odd cells in Excel
Select the range of cells you want to highlight
Go to the 'Home' tab and click on 'Conditional Formatting'
Choose 'New Rule' and select 'Use a formula to determine which cells to format'
Enter the formula '=MOD(A1,2)=1' (assuming A1 is the top-left cell of your selected range)
Choose the formatting style you want for the odd cells
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
INNER JOIN returns rows when there is at least one match in both tables
LEFT JOIN returns all rows from the left table and the matched rows from the right table
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FU...
Use window function to calculate running sum of salary in SQL
Use window function like SUM() with OVER() clause
Partition the data by employee ID if needed
Order the data by date or any other relevant column
posted on 10 Mar 2023
posted on 25 Feb 2025
I appeared for an interview in Jan 2025.
Round 1 was aptitude test which was eliminator round. Questions related to quant, english, and role related mcq were asked.
Overall 3/5 difficulty.
based on 6 interviews
Interview experience
based on 101 reviews
Rating in categories
Software Engineer
48
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Software Engineer
45
salaries
| ₹6.1 L/yr - ₹24 L/yr |
Senior Engineer
45
salaries
| ₹6.3 L/yr - ₹22 L/yr |
Associate Engineer
33
salaries
| ₹2.8 L/yr - ₹8.2 L/yr |
Technical Lead
27
salaries
| ₹12 L/yr - ₹34.9 L/yr |
Cyfuture
Value Point Systems
JoulestoWatts Business Solutions
ARMSOFTECH.AIR