i
Coforge
Work with us
Filter interviews by
To efficiently lookup data from a master dataset, use indexing, filtering, and optimized query techniques.
Use indexing to speed up data retrieval. For example, create an index on a 'patient_id' column in a medical dataset.
Implement filtering to narrow down results. For instance, filter records by 'date_of_visit' to find relevant entries.
Utilize SQL joins to combine data from multiple tables. For example, join 'pat...
Designing a strategy for migrating data from Oracle to MongoDB, focusing on table-to-collection mapping.
Analyze the existing Oracle schema to identify tables and relationships.
Define MongoDB collections based on the logical grouping of data, e.g., user data from multiple tables into a 'users' collection.
Map Oracle data types to MongoDB data types, ensuring compatibility, e.g., VARCHAR to String.
Use ETL tools or sc...
Effective SQL query tuning enhances performance and reduces resource consumption through various strategies.
Analyze execution plans to identify bottlenecks and optimize query paths.
Use indexing strategically; for example, create composite indexes for multi-column searches.
Limit the result set with WHERE clauses to reduce the amount of data processed.
Avoid SELECT *; specify only the necessary columns to minimize da...
Fetching data from Excel involves using libraries like Apache POI or OpenPyXL in Java or Python respectively.
Use Apache POI for Java: Load workbook and sheet, iterate through rows and cells.
Example in Java: Workbook workbook = WorkbookFactory.create(new FileInputStream("file.xlsx"));
Use OpenPyXL for Python: Load workbook and access sheets using workbook['SheetName'].
Example in Python: wb = load_workbook('file.xlsx...
Retrieve the highest stock price from a dynamic web table using web scraping techniques.
Use a web scraping library like BeautifulSoup (Python) or Selenium for dynamic content.
Identify the table structure in the HTML to locate stock names and prices.
Extract stock prices and convert them to a comparable format (e.g., float).
Iterate through the extracted data to find the maximum price and its corresponding stock name...
The program compresses the string by counting consecutive characters and appending counts to the output.
Input: 'aabbcccd' -> Output: 'aa2bb2ccc3d1'
Counts consecutive characters: 'aa' -> 'a2', 'bb' -> 'b2', 'ccc' -> 'c3', 'd' -> 'd1'
Final output combines characters and their counts.
This Java program shifts all zeros in an array to the end while maintaining the order of non-zero elements.
Initialize a count variable to track the position of non-zero elements.
Iterate through the array and copy non-zero elements to the front.
Fill the remaining positions in the array with zeros after processing all elements.
Example: For input [0, 1, 0, 3, 12], output will be [1, 3, 12, 0, 0].
XPath expression helps locate the discount percentage of a phone on Flipkart by its name.
Use the phone's name to identify the specific product element.
XPath syntax: //div[contains(@class, 'product-name') and contains(text(), 'PhoneName')]//following-sibling::div[contains(@class, 'discount')]
Replace 'PhoneName' with the actual name of the phone you're searching for.
Ensure the XPath accurately reflects the structure...
The student with the second highest score is Adil, who scored 70, following Vikas with 99 and Goutham with 90.
Score Ranking: The scores are ranked as follows: Vikas (99), Goutham (90), Adil (70), and Sam (10).
Identifying Second Highest: To find the second highest, we can sort the scores and select the second entry.
Data Structure: The data is stored in a dictionary format, which allows for easy access to scores by ...
AppDynamics and Dynatrace are both application performance management tools, but they differ in features and focus areas.
Focus Areas: AppDynamics is known for its deep application performance monitoring, while Dynatrace emphasizes full-stack observability, including infrastructure.
User Experience Monitoring: AppDynamics offers robust end-user monitoring capabilities, whereas Dynatrace provides real user monitoring...
I appeared for an interview in Feb 2025.
I appeared for an interview in Feb 2025.
Apache Spark is a distributed computing system designed for fast data processing and analytics.
Spark operates on a master-slave architecture with a Driver and Executors.
The Driver program coordinates the execution of tasks and maintains the SparkContext.
Executors are worker nodes that execute tasks and store data in memory for fast access.
Spark uses Resilient Distributed Datasets (RDDs) for fault tolerance and parallel...
Spark optimization techniques enhance performance by improving resource utilization and reducing execution time.
1. Catalyst Optimizer: Automatically optimizes query plans in Spark SQL, improving execution efficiency.
2. Tungsten Execution Engine: Focuses on memory management and code generation for better performance.
3. Data Serialization: Use efficient serialization formats like Kryo to reduce data transfer time.
4. Bro...
SparkSession is the entry point for Spark SQL, while SparkContext is the entry point for Spark Core functionalities.
SparkSession encapsulates SparkContext and provides a unified entry point for DataFrame and SQL operations.
SparkContext is used to connect to a Spark cluster and is the primary interface for Spark Core functionalities.
You can create a SparkSession using: `SparkSession.builder.appName('example').getOrCreat...
Read and write modes define how data is accessed and modified in files or streams, impacting data integrity and performance.
Read Mode (r): Opens a file for reading only. Example: 'file = open('data.txt', 'r')'
Write Mode (w): Opens a file for writing, truncating the file if it exists. Example: 'file = open('data.txt', 'w')'
Append Mode (a): Opens a file for writing, appending data to the end without truncating. Example: ...
Faced challenges in data accuracy, stakeholder communication, and adapting to market changes in previous projects.
Data Accuracy: Encountered discrepancies in historical data which required extensive validation and cleaning before analysis.
Stakeholder Communication: Misalignment with stakeholders on project goals led to revisions; implemented regular updates to ensure clarity.
Market Changes: Rapid shifts in market trend...
Both Azure and GCP have unique strengths; preference depends on specific project needs and organizational goals.
Azure offers seamless integration with Microsoft products, ideal for enterprises using Windows Server and SQL Server.
GCP excels in data analytics and machine learning, with tools like BigQuery and TensorFlow for advanced data processing.
Azure has a strong hybrid cloud strategy, allowing businesses to integrat...
I appeared for an interview in Feb 2025.
Props are inputs to components, while state is a component's internal data that can change over time.
Props (short for properties) are read-only and passed from parent to child components.
State is mutable and managed within the component itself, allowing it to change over time.
Example of props: <ChildComponent name='John' /> where 'name' is a prop.
Example of state: this.setState({ count: this.state.count + 1 }) up...
The spread operator expands iterable elements into individual elements, simplifying array and object manipulation in JavaScript.
Syntax: The spread operator is represented by three dots (...).
Usage with arrays: It can be used to create a new array by combining existing arrays. Example: const newArray = [...array1, ...array2];
Usage with objects: It allows for shallow copying and merging of objects. Example: const newObje...
Optimize React by minimizing re-renders, using memoization, and leveraging code-splitting techniques.
Use React.memo to prevent unnecessary re-renders of functional components.
Implement useCallback and useMemo hooks to memoize functions and values.
Utilize React.lazy and Suspense for code-splitting to load components only when needed.
Avoid inline functions in render methods to reduce re-creation on each render.
Use the sh...
React hooks can replace Redux for state management in simpler applications, but Redux offers more structure for complex states.
React's useState and useReducer hooks can manage local state effectively.
For global state, useContext combined with useReducer can mimic Redux functionality.
Example: useReducer can handle complex state logic similar to Redux reducers.
Redux provides middleware support (like redux-thunk) for asyn...
ES6 introduces significant improvements to JavaScript, enhancing syntax and functionality for developers.
Arrow Functions: Shorter syntax for function expressions. Example: const add = (a, b) => a + b;
Template Literals: Multi-line strings and string interpolation. Example: const greeting = `Hello, ${name}!`;
Destructuring Assignment: Unpacking values from arrays or properties from objects. Example: const [x, y] = [1, ...
Default parameters in ES6 allow functions to initialize parameters with default values if no argument is provided.
Default parameters are defined in the function signature: `function multiply(a, b = 1) { return a * b; }`.
If no value is passed for `b`, it defaults to `1`: `multiply(5)` returns `5`.
Default parameters can be any expression, including function calls: `function greet(name = getDefaultName()) { ... }`.
They ca...
Design principles are fundamental guidelines that inform and shape software architecture and design decisions.
Separation of Concerns: Different functionalities should be separated into distinct sections, e.g., MVC architecture.
Single Responsibility Principle: A class should have one reason to change, like a User class managing user data only.
Open/Closed Principle: Software entities should be open for extension but clos...
Liskov Substitution Principle states that objects of a superclass should be replaceable with objects of a subclass without affecting functionality.
Subtypes must be substitutable for their base types without altering the correctness of the program.
Example: If 'Bird' is a superclass, 'Sparrow' and 'Penguin' should be subclasses that can replace 'Bird' without issues.
Violating this principle can lead to unexpected behavio...
The Interface Segregation Principle advocates for creating smaller, specific interfaces rather than large, general-purpose ones.
Clients should not be forced to depend on interfaces they do not use.
Example: Instead of a single 'Animal' interface with methods like 'fly', 'swim', and 'walk', create separate interfaces like 'Flyable', 'Swimmable', and 'Walkable'.
This reduces the impact of changes and promotes better code o...
A request delegate in ASP.NET Core handles HTTP requests and defines how to process them in middleware.
Request delegates are functions that take an HttpContext and return a Task.
They are used in middleware to process requests and responses.
Example: app.Use(async (context, next) => { await next(); });
Delegates can be composed to create a pipeline of request processing.
They allow for separation of concerns in handling...
I appeared for an interview in Jan 2025.
Callback is a function passed as an argument to another function to be executed later. Callback hell is the nesting of multiple callbacks resulting in unreadable code.
Callback is a function passed as an argument to another function, to be executed later.
Callback hell occurs when multiple callbacks are nested, leading to unreadable and difficult to maintain code.
To prevent callback hell, use Promises, async/await, or mo...
Closures are functions that have access to their own scope, as well as the scope in which they were defined.
Closures allow functions to access variables from their parent function even after the parent function has finished executing.
Closures are created whenever a function is defined within another function.
Closures are commonly used in event handlers, callbacks, and in functional programming.
ES6 (ECMAScript 2015) introduced several new features to JavaScript, making the language more powerful and expressive.
Arrow functions for concise syntax: const add = (a, b) => a + b;
Let and const for block-scoped variables: let x = 5; const y = 10;
Template literals for string interpolation: const name = 'Alice'; console.log(`Hello, ${name}!`);
Destructuring assignment for easily extracting values from arrays or objec...
Yes, {cat, Act} & {mary, Army} are anagrams.
Convert both words to lowercase to ignore case sensitivity.
Sort the characters in both words alphabetically.
Check if the sorted characters in both words are equal.
var is function scoped, let is block scoped, and const is block scoped with read-only values.
var is function scoped, meaning it is accessible throughout the function it is declared in.
let is block scoped, meaning it is only accessible within the block it is declared in.
const is block scoped like let, but the value cannot be reassigned.
I appeared for an interview in Dec 2024.
Utilize Data Extensions and SQL queries to manage large amounts of data in Salesforce Marketing Cloud.
Use Data Extensions to store and organize large amounts of data.
Utilize SQL queries to extract, manipulate, and update data in Data Extensions.
Consider using Automation Studio to automate data management processes.
Implement best practices for data hygiene and segmentation to optimize performance.
OOP in C# is a programming paradigm that uses objects to design applications, focusing on data encapsulation, inheritance, and polymorphism.
OOP in C# involves creating classes and objects to represent real-world entities
It emphasizes data encapsulation, allowing data to be hidden and accessed only through methods
Inheritance allows classes to inherit properties and behaviors from other classes
Polymorphism enables object...
An example of a design pattern is the Singleton pattern.
Design patterns are reusable solutions to common problems in software design.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Other examples include Factory, Observer, and Strategy patterns.
I appeared for an interview in Jan 2025.
An interface in software development is a contract that defines the methods that a class must implement.
Interfaces allow for multiple inheritance in programming languages that do not support it.
Interfaces provide a way to achieve abstraction in code, making it easier to maintain and extend.
Interfaces are used to define a set of methods that a class must implement, ensuring consistency and interoperability.
Example: Java...
To initialize a WebDriver object for controlling the Chrome browser.
To interact with the Chrome browser using Selenium WebDriver
To perform automated testing on web applications
To access the browser's functionalities and manipulate web elements
Reverse a string while keeping numbers and symbols in their original positions.
Iterate through the string and store the positions of numbers and symbols.
Reverse the string using a two-pointer approach.
Place the numbers and symbols back in their original positions.
I applied via Referral and was interviewed in Nov 2024. There was 1 interview round.
BGP is used for routing and exchanging routing information between different autonomous systems.
BGP allows for dynamic routing between different autonomous systems
It provides redundancy and load balancing by choosing the best path for data traffic
BGP helps in preventing network loops and ensuring efficient data routing
It is commonly used by Internet Service Providers (ISPs) to exchange routing information
BGP is essenti...
A switch stack is a group of network switches that are interconnected and operate as a single unit.
Switch stack simplifies network management by allowing multiple switches to be managed as one entity.
It provides high availability and redundancy by allowing one switch to take over if another fails.
Switch stack can also increase network performance by load balancing traffic across multiple switches.
Examples of switch sta...
Configurations required in wireless networking include SSID, security settings, encryption type, and channel selection.
Set up a unique SSID to identify the network
Choose appropriate security settings such as WPA2-PSK
Select encryption type like AES for secure data transmission
Optimize channel selection to avoid interference
Different types of VPNs include remote access VPN, site-to-site VPN, and client-to-site VPN.
Remote access VPN allows individual users to connect to a private network remotely.
Site-to-site VPN connects multiple networks together over the internet.
Client-to-site VPN allows individual devices to connect to a private network remotely.
Other types include MPLS VPN, SSL VPN, and IPsec VPN.
The purpose of native VLAN is to carry untagged traffic across a trunk link.
Native VLAN is used for untagged traffic on a trunk link
It allows devices that do not support VLAN tagging to communicate over the trunk link
Native VLAN should be the same on both ends of the trunk link to avoid VLAN hopping attacks
I appeared for an interview in Jan 2025.
I am a highly experienced Senior Test Engineer with a strong background in software testing and quality assurance.
Over 8 years of experience in software testing
Proficient in test planning, execution, and reporting
Skilled in automation testing tools such as Selenium and JUnit
Experience in testing web and mobile applications
Strong problem-solving and analytical skills
I have 5 years of experience in using Selenium with C# for automation testing of web applications.
Developed automation scripts using Selenium WebDriver with C# for regression testing
Implemented Page Object Model design pattern for better code maintenance
Used NUnit or MSTest for test execution and reporting
Integrated with CI/CD tools like Jenkins for automated test runs
Handled dynamic elements and pop-ups using explicit...
What people are saying about Coforge
Some of the top questions asked at the Coforge interview -
The duration of Coforge interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 575 interview experiences
Difficulty level
Duration
based on 5.5k reviews
Rating in categories
Senior Software Engineer
4.9k
salaries
| ₹6 L/yr - ₹26.6 L/yr |
Technical Analyst
2.8k
salaries
| ₹9.7 L/yr - ₹38.4 L/yr |
Software Engineer
2.2k
salaries
| ₹2.4 L/yr - ₹10 L/yr |
Senior Test Engineer
1.8k
salaries
| ₹4.8 L/yr - ₹20 L/yr |
Technology Specialist
1.3k
salaries
| ₹12 L/yr - ₹42 L/yr |
Capgemini
Cognizant
Accenture
Infosys