i
Synechron
Filter interviews by
Yes, the transaction will be rolled back if the innermost stored procedure throws an error.
If an error occurs in the innermost stored procedure, it will cause the entire transaction to be rolled back.
This ensures that the database remains in a consistent state.
Rolling back the transaction means that any changes made by the stored procedures within the transaction will be undone.
I use Ngrx for state management in my current project by defining actions, reducers, effects, and selectors.
Define actions to describe user events or interactions
Create reducers to specify how state should change in response to actions
Implement effects to manage side effects like API calls
Use selectors to retrieve specific pieces of state for components
zone.js is a library for managing asynchronous operations in Angular applications.
zone.js helps in tracking asynchronous operations and their execution context in Angular applications.
It provides hooks for intercepting asynchronous tasks like setTimeout, setInterval, and promises.
zone.js can be used for profiling, debugging, and error handling in Angular applications.
DOM sanitizer in Angular is used to sanitize untrusted HTML to prevent XSS attacks.
DOM sanitizer is used to sanitize HTML content before rendering it in Angular templates.
It helps prevent Cross-Site Scripting (XSS) attacks by removing potentially harmful content.
Angular provides a built-in DomSanitizer service for sanitizing HTML content.
Example: Using DomSanitizer in Angular template to sanitize a URL before rend...
What people are saying about Synechron
Liskov Substitution Principle ensures that objects of a superclass can be replaced with objects of a subclass without affecting functionality.
Substitutability: A subclass should be substitutable for its superclass.
Behavior Preservation: Subclasses must maintain the behavior expected from the superclass.
Example: If a function uses a class type, it should work with any subclass without modification.
Violation: If a s...
Model binder in MVC is used to map data from HTTP requests to action method parameters in controllers.
Model binder maps form data, query string parameters, and route data to action method parameters in MVC controllers.
It helps in simplifying the process of extracting data from HTTP requests.
Model binder can be customized by creating custom model binders to handle complex data binding scenarios.
Use a query with GROUP BY and HAVING clause to identify and remove duplicates from a table.
Use GROUP BY to group rows with the same values
Use HAVING COUNT(*) > 1 to identify duplicates
Use DELETE statement to remove duplicates
MVC is a design pattern used in .NET development, while .NET lifecycle refers to the stages of a .NET application's execution.
MVC is a design pattern that separates an application into three main components: Model, View, and Controller.
.NET lifecycle refers to the stages of a .NET application's execution, including initialization, execution, and termination.
MVC helps in achieving separation of concerns and making ...
Stored procedures are precompiled SQL queries stored in the database, while functions are reusable code blocks that return a value.
Stored procedures are used for performing specific tasks or operations on the database.
Functions are used to encapsulate logic and can be called within SQL queries or other functions.
Stored procedures can have input and output parameters, while functions always return a value.
Stored pr...
NgOnInit is a lifecycle hook in Angular that is called after the component has been initialized, while the constructor is a TypeScript feature used to initialize class properties.
NgOnInit is specific to Angular components, while constructor is a general TypeScript feature.
NgOnInit is used for initialization logic that relies on Angular's view and input bindings being initialized, while constructor is used for basi...
MVC is a design pattern used in .NET development, while .NET lifecycle refers to the stages of a .NET application's execution.
MVC is a design pattern that separates an application into three main components: Model, View, and Controller.
.NET lifecycle refers to the stages of a .NET application's execution, including initialization, execution, and termination.
MVC helps in achieving separation of concerns and making the c...
Dispose is used to release unmanaged resources immediately, while Finalize is used for cleanup operations before an object is destroyed by the garbage collector.
Dispose is called explicitly by the developer, while Finalize is called by the garbage collector.
Dispose should be implemented in classes that directly interact with unmanaged resources.
Finalize should be implemented in classes that need to release resources be...
Liskov Substitution Principle ensures that objects of a superclass can be replaced with objects of a subclass without affecting functionality.
Substitutability: A subclass should be substitutable for its superclass.
Behavior Preservation: Subclasses must maintain the behavior expected from the superclass.
Example: If a function uses a class type, it should work with any subclass without modification.
Violation: If a subcla...
DOM sanitizer in Angular is used to sanitize untrusted HTML to prevent XSS attacks.
DOM sanitizer is used to sanitize HTML content before rendering it in Angular templates.
It helps prevent Cross-Site Scripting (XSS) attacks by removing potentially harmful content.
Angular provides a built-in DomSanitizer service for sanitizing HTML content.
Example: Using DomSanitizer in Angular template to sanitize a URL before rendering...
I use Ngrx for state management in my current project by defining actions, reducers, effects, and selectors.
Define actions to describe user events or interactions
Create reducers to specify how state should change in response to actions
Implement effects to manage side effects like API calls
Use selectors to retrieve specific pieces of state for components
Stored procedures are precompiled SQL queries stored in the database, while functions are reusable code blocks that return a value.
Stored procedures are used for performing specific tasks or operations on the database.
Functions are used to encapsulate logic and can be called within SQL queries or other functions.
Stored procedures can have input and output parameters, while functions always return a value.
Stored procedu...
Yes, the transaction will be rolled back if the innermost stored procedure throws an error.
If an error occurs in the innermost stored procedure, it will cause the entire transaction to be rolled back.
This ensures that the database remains in a consistent state.
Rolling back the transaction means that any changes made by the stored procedures within the transaction will be undone.
NgOnInit is a lifecycle hook in Angular that is called after the component has been initialized, while the constructor is a TypeScript feature used to initialize class properties.
NgOnInit is specific to Angular components, while constructor is a general TypeScript feature.
NgOnInit is used for initialization logic that relies on Angular's view and input bindings being initialized, while constructor is used for basic ini...
zone.js is a library for managing asynchronous operations in Angular applications.
zone.js helps in tracking asynchronous operations and their execution context in Angular applications.
It provides hooks for intercepting asynchronous tasks like setTimeout, setInterval, and promises.
zone.js can be used for profiling, debugging, and error handling in Angular applications.
I appeared for an interview before Mar 2021.
Round duration - 75 minutes
Round difficulty - Medium
This was an online coding round where we had 2 questions to solve under 75 minutes. I found both the questions to be of Easy to Medium level of difficulty.
You are given several sets of points on a 2D plane, each set represented as a list of coordinates. Your task is to determine if there exists a line parallel to the Y-axis...
The task is to determine if there exists a line parallel to the Y-axis that reflects given points symmetrically.
Iterate through each test case and check if a vertical reflection line exists for the given points
Calculate the midpoint of the x-coordinates and check if it reflects the points symmetrically
Consider edge cases where points are on the reflection line or have the same x-coordinate
You are provided with a 2-dimensional matrix having N
rows and M
columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...
Count the number of islands in a 2D matrix of 1s and 0s.
Iterate through the matrix and perform depth-first search (DFS) to find connected 1s.
Mark visited cells to avoid redundant traversal.
Increment island count whenever a new island is encountered.
Round duration - 60 minutes
Round difficulty - Medium
This round had 2 coding questions followed by some questions from DBMS.
You are given an array/list HEIGHTS
of length N
, where each element represents the height of a histogram bar. The width of each bar is considered to be 1.
Find the area of the largest rectangle that can be formed within the bounds of a given histogram.
Iterate through the histogram bars and calculate the area of the largest rectangle that can be formed using each bar as the height.
Use a stack to keep track of the indices of the bars in non-decreasing order of height.
Pop elements from the stack and calculate the area until a smaller height bar is encountered.
Update the max...
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
The first line contains an...
The task is to determine if a given string consisting of parentheses is balanced or not.
Iterate through the characters of the string and use a stack to keep track of opening parentheses.
If an opening parenthesis is encountered, push it onto the stack.
If a closing parenthesis is encountered, check if it matches the top of the stack. If it does, pop the stack, else the string is not balanced.
At the end, if the stack is e...
ACID properties in DBMS ensure data integrity and consistency in transactions.
Atomicity: All operations in a transaction are completed successfully or none at all.
Consistency: Data is always in a valid state before and after a transaction.
Isolation: Transactions are isolated from each other to prevent interference.
Durability: Once a transaction is committed, changes are permanent and survive system failures.
Example: If...
Levels of data abstraction in a DBMS refer to the different views of data provided to users and applications.
Physical level: Deals with how data is stored on the storage media. Example: data blocks, pages, indexes.
Logical level: Focuses on how data is represented to users. Example: tables, views, constraints.
View level: Provides a customized view of the database for specific users or applications. Example: queries, rep...
Round duration - 60 minutes
Round difficulty - Medium
Standard DS/Algo round with 2 coding questions followed by 2 interesting puzzles.
You are provided with an undirected graph containing 'N' vertices and 'M' edges. The vertices are numbered from 1 to 'N'. Your objective is to determi...
Detect if an undirected graph contains a cycle by exploring all possible paths.
Use Depth First Search (DFS) algorithm to traverse the graph and detect cycles.
Maintain a visited set to keep track of visited vertices and a parent pointer to avoid visiting the same vertex twice.
If a visited vertex is encountered that is not the parent of the current vertex, a cycle is present.
Consider edge cases like disconnected graphs a...
Given a matrix ARR
with dimensions N
* M
, consisting only of 0s and 1s where each row is sorted, determine the index of the row that contains the highest number of 1s. If multi...
Find the row with the maximum number of 1s in a sorted matrix.
Iterate through each row of the matrix and count the number of 1s in each row
Keep track of the row index with the maximum number of 1s
Return the index of the row with the highest count of 1s
By lighting both wires at the same time, the shorter wire will burn out first, allowing you to measure a specific duration of time.
Light both wires at the same time
Measure the time it takes for the shorter wire to burn out completely
The remaining length of the longer wire will indicate the specific duration of time
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Naukri.com and was interviewed in Aug 2020. There were 5 interview rounds.
Interfaces define a contract for classes to implement certain methods and properties.
Interfaces allow for polymorphism and loose coupling.
Classes can implement multiple interfaces.
Interfaces cannot be instantiated on their own.
Interfaces can have default method implementations.
Interfaces can be used to enforce design patterns like the adapter pattern.
I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.
Company policies and locations
Our company has strict policies regarding data privacy and security
We have multiple locations across the country and internationally
Each location has its own set of policies and procedures
Employees are expected to adhere to all company policies regardless of location
I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.
NTT is a global technology services company that provides IT solutions and services to clients worldwide.
NTT offers a wide range of services including cloud computing, cybersecurity, data analytics, and IoT solutions.
The company operates in over 80 countries and has over 300,000 employees.
NTT is also involved in research and development in areas such as artificial intelligence and quantum computing.
Some of NTT's client...
posted on 13 Jan 2015
I am a software developer with experience in various programming languages and frameworks.
Proficient in Java, C++, and Python
Familiar with web development using HTML, CSS, and JavaScript
Experience with database management systems such as MySQL and MongoDB
Strong problem-solving and analytical skills
Worked on projects involving machine learning and artificial intelligence
Method overloading is having multiple methods with the same name but different parameters. Method overriding is having a subclass method with the same name and parameters as a superclass method.
Method overloading is used to provide different ways of calling the same method with different parameters.
Method overriding is used to provide a specific implementation of a method in a subclass that is already defined in the su...
Switch case is used for multiple conditions while if else is used for binary conditions.
Switch case is faster than if else for multiple conditions.
If else can handle complex conditions while switch case cannot.
Switch case can only compare values of the same data type.
If else can handle null values while switch case cannot.
Example: switch (day) { case 1: console.log('Monday'); break; case 2: console.log('Tuesday'); brea...
Inheritance is a fundamental OOP concept allowing a class to inherit properties and methods from another class.
Promotes code reusability by allowing new classes to use existing code.
Supports the creation of a hierarchical relationship between classes.
Example: A 'Dog' class can inherit from an 'Animal' class, gaining its properties like 'eat' and 'sleep'.
Facilitates polymorphism, enabling methods to be overridden in der...
Default case in switch case statement
Default case is executed when no other case matches the switch expression
It is optional and can be placed anywhere in the switch statement
It is often used to handle unexpected input or errors
It should always be the last case in the switch statement
Yes, I have received offers from two other companies.
Received offers from Company A and Company B
Currently evaluating all offers to make an informed decision
Considering factors like company culture, growth opportunities, and compensation
I would like to join Google because of their innovative projects and work culture.
Google is known for its cutting-edge technology and innovative projects.
They have a strong focus on employee well-being and work-life balance.
Google offers opportunities for career growth and development.
The company has a diverse and inclusive work culture.
Google is a leader in the tech industry with a global presence.
Yes, they are similar.
All 8 metal balls are of the same material.
They have the same size and weight.
They have the same physical properties.
They are interchangeable in any given situation.
I'm a passionate software developer with a strong background in full-stack development and a love for problem-solving.
Over 5 years of experience in software development, specializing in JavaScript and Python.
Worked on a project that improved application performance by 30% through code optimization.
Collaborated with cross-functional teams to deliver high-quality software solutions on time.
Contributed to open-source proj...
The missing rupee is not actually missing. The calculation is misleading and does not account for the total amount paid.
The initial amount paid by each person was Rs.10, totaling Rs.30.
The owner gave them a discount of Rs.5, so they paid Rs.25 in total.
The broker took Rs.2, leaving them with Rs.23.
When the broker returned Rs.1 to each person, they each received Rs.1 back, totaling Rs.3.
So, the total amount paid by the ...
Inheritance in Java allows a class to inherit properties and methods from another class.
Inheritance is achieved using the 'extends' keyword.
The class that is being inherited from is called the superclass or parent class.
The class that inherits from the superclass is called the subclass or child class.
Subclasses can access the public and protected members of the superclass.
Inheritance promotes code reusability and allow...
A program to check if a given number is a palindrome or not.
Convert the number to a string.
Reverse the string and compare it with the original string.
If they are equal, the number is a palindrome.
If not, the number is not a palindrome.
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
It involves breaking down a table into smaller tables and defining relationships between them.
Normalization helps to eliminate data inconsistencies and anomalies.
There are different levels of normalization, with each level having specific rules to follow.
For example, first normal form (1NF) requires that each t...
I would be ready to accept a project in Java even if I was trained in DotNet earlier.
I have a strong foundation in programming principles and concepts, which can be applied to any language.
I am confident in my ability to quickly learn and adapt to new technologies.
I have experience working with multiple programming languages and frameworks.
I can leverage my knowledge of DotNet to understand similar concepts in Java.
I a...
I want to join Sapient because of its reputation for innovative projects and collaborative work environment.
Sapient is known for working on cutting-edge projects that push the boundaries of technology
I value the collaborative work environment at Sapient, where team members support each other to achieve success
I am impressed by Sapient's commitment to professional development and growth opportunities for employees
My expectations from Sapient
I expect Sapient to provide a challenging and innovative work environment
I expect Sapient to offer opportunities for professional growth and learning
I expect Sapient to have a collaborative and supportive team culture
I expect Sapient to provide competitive compensation and benefits
I expect Sapient to have a strong focus on quality and delivering excellent software solutions
I'm proud of my contributions to open-source projects and mentoring aspiring developers in my community.
Contributed to several open-source projects on GitHub, enhancing features and fixing bugs.
Mentored junior developers through coding bootcamps, helping them build confidence and skills.
Developed a mobile app for local businesses to improve their online presence and customer engagement.
Participated in hackathons, winni...
Some of the top questions asked at the Synechron DOT NET Developer interview -
based on 1 interview experience
based on 2 reviews
Rating in categories
Technical Lead
2.9k
salaries
| ₹19.9 L/yr - ₹35 L/yr |
Senior Associate
2k
salaries
| ₹14.5 L/yr - ₹26 L/yr |
Senior Software Engineer
1.6k
salaries
| ₹13.8 L/yr - ₹28 L/yr |
Associate Specialist
928
salaries
| ₹22.2 L/yr - ₹38 L/yr |
Senior Associate Technology L1
899
salaries
| ₹14.7 L/yr - ₹27 L/yr |
DXC Technology
Optum Global Solutions
Virtusa Consulting Services
CGI Group