i
Idfy
Filter interviews by
SQL is preferred for structured data, transactions, complex queries, and ACID compliance.
SQL is better for structured data and relationships between data.
SQL is preferred for transactions and ensuring data integrity.
SQL is more suitable for complex queries involving multiple tables.
SQL databases provide ACID compliance for data consistency and reliability.
Use a subquery to remove the second-highest salary in SQL
Use a subquery to select the highest salary
Use the NOT IN operator to exclude the second-highest salary from the results
Overfitting occurs when a model learns the training data too well, leading to poor performance on new, unseen data.
Overfitting occurs when a model is too complex and captures noise in the training data.
It can be identified when a model performs well on training data but poorly on test data.
Techniques to prevent overfitting include cross-validation, regularization, and early stopping.
Example: A decision tree with t...
To find errors from a service, analyze logs, monitor system metrics, and use debugging tools.
Analyze logs generated by the service to identify any error messages or exceptions.
Monitor system metrics such as CPU usage, memory usage, and network traffic for any anomalies that may indicate errors.
Use debugging tools like breakpoints, stack traces, and error logs to pinpoint the source of errors.
Perform thorough testi...
Approximately 18 million vadapavs are consumed in Mumbai every day.
Consider the population of Mumbai and the popularity of vadapav as a snack.
Estimate the number of street vendors selling vadapav in Mumbai.
Assume an average number of vadapavs sold per vendor per day.
Factor in the demand for vadapav during peak hours and festivals.
Consider the price of vadapav and its affordability for the common people.
Compare the...
Different data definition language queries in SQL
DDL queries are used to create, modify, and delete database objects
Some common DDL queries include CREATE, ALTER, and DROP
CREATE TABLE is used to create a new table
ALTER TABLE is used to modify an existing table
DROP TABLE is used to delete a table
I applied via Recruitment Consulltant and was interviewed before Jan 2022. There were 4 interview rounds.
Linux commands, SQL and basic Python
Different data definition language queries in SQL
DDL queries are used to create, modify, and delete database objects
Some common DDL queries include CREATE, ALTER, and DROP
CREATE TABLE is used to create a new table
ALTER TABLE is used to modify an existing table
DROP TABLE is used to delete a table
To find errors from a service, analyze logs, monitor system metrics, and use debugging tools.
Analyze logs generated by the service to identify any error messages or exceptions.
Monitor system metrics such as CPU usage, memory usage, and network traffic for any anomalies that may indicate errors.
Use debugging tools like breakpoints, stack traces, and error logs to pinpoint the source of errors.
Perform thorough testing an...
I applied via Approached by Company and was interviewed in Sep 2024. There were 4 interview rounds.
They will send you a link for aptitude test
Yes, I am comfortable with night shifts as I am able to adapt to different schedules and prioritize work efficiently.
I have previous experience working night shifts and have been able to perform well during those hours.
I am a night owl and find that I am more productive during the night.
I understand the importance of maintaining a healthy work-life balance and am willing to adjust my schedule to accommodate night shift...
It takes me approximately 30 minutes to reach the office from my current location.
I live about 10 miles away from the office.
I usually drive to work, taking the highway to avoid traffic.
On average, it takes me half an hour to commute to the office.
I prefer to discuss salary expectations based on the responsibilities and requirements of the position.
Focus on discussing salary expectations based on the job role and industry standards.
Avoid disclosing current salary to ensure fair compensation.
Highlight relevant experience and skills that justify desired salary.
Discuss potential for growth and additional benefits instead of current salary.
I was a marketing manager at a tech company.
Managed marketing campaigns and strategies
Collaborated with cross-functional teams to drive brand awareness
Analyzed market trends and competitor activities
Implemented digital marketing initiatives
Organized events and promotions
Seeking new challenges and opportunities for growth.
Desire for career advancement
Lack of growth opportunities in previous organization
Seeking new challenges and learning experiences
IDfy is a leading identity verification and fraud prevention platform.
IDfy offers solutions for KYC verification, customer onboarding, and fraud detection.
Their platform uses AI and machine learning algorithms to verify identities in real-time.
IDfy serves a wide range of industries including finance, e-commerce, and healthcare.
The case study involves asking you about the documents and how will you verify fraud with the given documents like offer letter , and others. And the second
2 case study was
How will you teach the blind man colour blue
The answer was this was given by me hence it was out of the book
Nuts and bolts game, to output date in a certain format, one SQL query
Round 1: Basic Stats & ML MCQ followed by one EDA on Particular Problem.
The right side view of a binary tree shows the nodes visible when the tree is viewed from the right.
Use a level-order traversal (BFS) to explore the tree level by level.
Keep track of the last node at each level to capture the rightmost node.
Example: For the tree [1, 2, 3, null, 5, null, 4], the right side view is [1, 3, 4].
Utilize a queue to manage nodes at each level during traversal.
I applied via Campus Placement and was interviewed in Feb 2024. There were 2 interview rounds.
It had 2 coding questions
I applied via Campus Placement and was interviewed in Mar 2024. There was 1 interview round.
Use a subquery to remove the second-highest salary in SQL
Use a subquery to select the highest salary
Use the NOT IN operator to exclude the second-highest salary from the results
I appeared for an interview before May 2024, where I was asked the following questions.
Top trending discussions
The duration of Idfy interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 21 interview experiences
Difficulty level
Duration
3-5 Yrs
Not Disclosed
3-5 Yrs
₹ 15.7-35 LPA
2-6 Yrs
Not Disclosed
Software Engineer
59
salaries
| ₹7.3 L/yr - ₹18 L/yr |
Associate Product Manager
24
salaries
| ₹9 L/yr - ₹15 L/yr |
Executive
23
salaries
| ₹2.2 L/yr - ₹4 L/yr |
Customer Success Manager
14
salaries
| ₹9.1 L/yr - ₹20 L/yr |
Product Manager
14
salaries
| ₹12 L/yr - ₹35 L/yr |
Global Edge Software
Moveinsync Technology Solutions
PagarBook
Trawex Technologies