i
Sgx Fx Systems
Filter interviews by
I applied via LinkedIn and was interviewed before Jan 2024. There were 4 interview rounds.
HackerRank coding assessment on java and dsa
Coding round cum system design
Top trending discussions
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
Codility Test General C# and SQL
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu
posted on 12 Dec 2024
I applied via Campus Placement and was interviewed in Nov 2024. There were 2 interview rounds.
Soo easy aptitude exam asked questions
OOPs in Java refers to Object-Oriented Programming concepts, fibo likely refers to Fibonacci sequence, and sorting refers to arranging elements in a specific order.
OOPs in Java includes concepts like classes, objects, inheritance, polymorphism, and encapsulation.
Fibo likely refers to the Fibonacci sequence, where each number is the sum of the two preceding ones (e.g. 0, 1, 1, 2, 3, 5, ...).
Sorting involves arranging el...
Yes, main can be overloaded but not overridden in C++.
Main can be overloaded by defining multiple functions with different parameters.
Example: int main() and int main(int argc, char* argv[])
Main cannot be overridden as it is a static function of the program.
posted on 16 Jan 2025
I applied via Referral and was interviewed in Dec 2024. There was 1 interview round.
The first round was a coding test, which was outsourced to an external vendor. I was asked 2 basic DSA questions, and there was discussions around the time and space complexity, and scope of optimizing the solutions. Post that there were a few questions around Spring Boot features and basic system design. The interviewer was professional throughout the interview, and the interview process felt more like a discussion, as compared to the standard interview process.
There was another round of coding - this time conducted by the organization itself. It consisted of a medium level DSA question on stacks. I wrote the code on my personal IDE and executed it there itself. The interviewer discussed about the possible edge cases and how I would deal with them. Post solving the question I was asked about my previous projects.
This was the final round where the discussion was largely around system design and HLD. It started off with questions are system design patterns and concepts. Then I was asked to design a booking design, with discussions around concurrency control and transaction management.
posted on 28 Dec 2024
I applied via LinkedIn and was interviewed in Jun 2024. There were 5 interview rounds.
Java coding questions, basic Java questions.
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There was 1 interview round.
A stage is a collection of tasks that perform a specific computation, while a task is a unit of work that is executed on a single executor.
Stage is a higher-level unit of work that can be broken down into multiple tasks.
Tasks are individual units of work that are executed on a single executor.
Stages are used to organize and coordinate tasks in a Spark job.
Tasks are the actual units of computation that are performed by ...
Actions and transformations are two types of operations in PySpark. Actions return a value to the driver program, while transformations create a new RDD.
Actions are operations that trigger the execution of the Spark job, such as collect(), count(), and saveAsTextFile().
Transformations are operations that create a new RDD from an existing one, such as map(), filter(), and reduceByKey().
Actions are lazy operations, meani...
RDD is a distributed collection of objects, while DataFrame is a distributed collection of data organized into named columns.
RDD is more low-level and requires manual schema definition, while DataFrame provides a higher-level API with schema inference.
DataFrames are optimized for processing structured data, while RDDs are more suitable for unstructured data.
DataFrames support SQL queries and optimizations through Catal...
I applied via Referral and was interviewed in Jul 2024. There were 3 interview rounds.
3 dsa questions medium level
based on 11 reviews
Rating in categories
Associate Technical Analyst
3
salaries
| ₹8.4 L/yr - ₹13.7 L/yr |
TCS
Accenture
Cognizant
Infosys