Filter interviews by
HAVING filters groups after aggregation, while WHERE filters rows before aggregation in SQL queries.
HAVING is used with aggregate functions like COUNT, SUM, AVG. Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10.
WHERE filters records before any groupings are made. Example: SELECT * FROM employees WHERE salary > 50000.
You can use WHERE to filter individual rows, whil...
PU functions in Celonis are powerful tools for analyzing and optimizing business processes.
PU functions allow users to create custom calculations and metrics based on process data.
Examples include calculating cycle times, identifying bottlenecks, and measuring compliance rates.
They can be used to aggregate data, such as summing total costs or counting occurrences of specific events.
PU functions enhance data visual...
Master data refers to the core data essential for operations in an organization, including customers, products, and suppliers.
Customer Master Data: Contains information about customers, such as names, addresses, and contact details.
Material Master Data: Includes details about products, such as descriptions, pricing, and inventory levels.
Vendor Master Data: Information about suppliers, including payment terms, cont...
The pandas 'describe' function provides summary statistics of DataFrame columns, useful for exploratory data analysis.
Returns count, mean, std, min, 25%, 50%, 75%, and max for numerical columns.
Example: df.describe() gives summary for all numerical columns in DataFrame df.
For categorical data, use df.describe(include='object') to get counts and unique values.
Can specify percentiles with the 'percentiles' parameter...
What people are saying about Accenture
Lambda functions are anonymous functions defined with the lambda keyword, useful for short, throwaway functions.
Lambda functions can take any number of arguments but can only have one expression.
They are often used in functions like map(), filter(), and reduce().
Example: Squaring numbers in a list: `squared = list(map(lambda x: x**2, [1, 2, 3, 4]))` results in `[1, 4, 9, 16]`.
They help in writing concise code, esp...
Effective communication is the most important behavior for a telecaller, ensuring clarity and engagement with clients.
Active Listening: Understanding client needs by listening attentively, e.g., summarizing their concerns before responding.
Empathy: Building rapport by showing understanding, e.g., acknowledging a client's frustration with a service.
Clarity: Communicating information clearly to avoid misunderstandin...
Customer service is the support and assistance provided to customers before, during, and after purchasing products or services.
Involves addressing customer inquiries and concerns promptly.
Example: A customer service representative helping a client with a product return.
Focuses on enhancing customer satisfaction and loyalty.
Example: Offering personalized recommendations based on customer preferences.
Includes provid...
B2B sales focus on relationships and long-term contracts, while B2C targets individual consumers with quick transactions.
B2B transactions often involve larger quantities and higher values, e.g., a company purchasing machinery.
B2C sales typically involve smaller quantities and lower values, e.g., a consumer buying a smartphone.
B2B sales cycles are longer due to multiple decision-makers, e.g., a corporate client eva...
The end-to-end sales process encompasses all stages from lead generation to closing the sale and post-sale follow-up.
Lead Generation: Identifying potential customers through marketing campaigns or referrals.
Qualification: Assessing leads to determine their potential as customers, e.g., BANT (Budget, Authority, Need, Timeline).
Needs Assessment: Understanding customer requirements through discussions and surveys.
Pro...
I have managed various phases of the sales process, from lead generation to closing deals and post-sales support.
Lead Generation: Developed targeted campaigns that increased qualified leads by 30%.
Qualification: Implemented a scoring system to prioritize leads based on their potential value.
Proposal Development: Collaborated with technical teams to create tailored proposals that addressed client needs.
Negotiation:...
I appeared for an interview in Jan 2025.
Debit note is a document issued by a buyer to a seller to request a credit for overpayment or return of goods. Credit note is a document issued by a seller to a buyer to reduce the amount owed due to overpayment or return of goods.
Debit note is issued by the buyer to request a credit from the seller.
Credit note is issued by the seller to reduce the amount owed by the buyer.
Debit note is used when there is an overpaymen...
Matching principle is an accounting concept that requires expenses to be matched with revenues in the period they are incurred.
Expenses should be recorded in the same period as the revenues they helped generate.
It ensures accurate financial reporting by showing the true cost of generating revenue.
Example: If a company sells products in January, the cost of goods sold for those products should also be recorded in Januar...
A subledger is a detailed record of transactions that feed into the general ledger.
Subledgers provide more detailed information on specific accounts or categories.
They help in tracking individual transactions before they are summarized in the general ledger.
Examples include accounts receivable subledger, accounts payable subledger, and inventory subledger.
Bank reconciliation statement is a document that compares the bank's records with the company's records of its bank account.
It is used to ensure the accuracy of the company's financial records.
It lists out any discrepancies between the two sets of records, such as outstanding checks or deposits in transit.
The goal is to reconcile the balance per the company's records with the balance per the bank's records.
It helps in ...
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There was 1 interview round.
Some other CRMs include Salesforce, Microsoft Dynamics, and Zoho CRM.
Salesforce is a popular CRM used by many companies for sales and marketing purposes.
Microsoft Dynamics is known for its integration with other Microsoft products and its customization options.
Zoho CRM is a cloud-based CRM solution that offers a wide range of features for managing customer relationships.
Yes, I am comfortable with Marketing CRM capabilities and have experience in building and utilizing them.
I have experience in implementing and customizing Marketing CRM systems to meet business needs.
I have utilized Marketing CRM capabilities to track customer interactions, manage campaigns, and analyze data for insights.
I have integrated Marketing CRM with other systems to streamline processes and improve efficiency.
O...
Plugins are custom code that can be added to extend functionality, while workflows are automated processes that can be triggered by events.
Plugins are custom code that can be added to extend the functionality of a system.
Workflows are automated processes that can be triggered by events in a system.
Plugins can be used to add new features or customize existing ones.
Workflows can automate repetitive tasks and streamline p...
Canvas Apps are highly customizable and visually rich, while Model Driven Apps are more structured and data-driven. Both can be integrated with CRM using customizations.
Canvas Apps allow for more flexibility in design and layout, with drag-and-drop functionality for components.
Model Driven Apps are more focused on data and business processes, with a predefined data model and UI components.
Both types of apps can be cust...
I hold Microsoft certifications in Azure and SQL Server. No pending renewals.
Certifications in Azure and SQL Server
No pending renewals
Power BI helps in visualizing data through interactive and customizable dashboards.
Power BI allows users to create visually appealing charts, graphs, and maps to represent data in a meaningful way.
Basic dashboards in Power BI typically include simple visuals like bar charts, line graphs, and pie charts to display key metrics.
Advanced dashboards in Power BI involve more complex visuals like heat maps, scatter plots, and...
Pro Power BI users enhance data transformation through advanced techniques and tools for better insights.
Utilize Power Query for data cleansing, such as removing duplicates or filtering rows based on specific criteria.
Implement M language for custom transformations, like creating calculated columns or complex aggregations.
Leverage DAX for advanced calculations, enabling dynamic measures that respond to user interaction...
I have worked with over 20 connectors in Power Apps, including SharePoint, Outlook, and SQL Server.
Worked with over 20 connectors in Power Apps
Familiar with connectors such as SharePoint, Outlook, and SQL Server
I have extensive experience with C#, .Net, and SQL.
Over 5 years of hands-on experience with C# and .Net development
Proficient in writing complex SQL queries and stored procedures
Experience in optimizing database performance and data modeling
Familiar with Entity Framework and LINQ for data access
Developed multiple web applications using ASP.NET MVC framework
Implemented a CRM project for a retail company to streamline customer interactions and improve sales.
Analyzed business requirements and designed the CRM system architecture
Customized CRM software to fit the specific needs of the retail company
Integrated CRM with existing systems for seamless data flow
Trained end users on how to effectively use the CRM system
Implemented data analytics tools to track customer interaction...
Yes, I have explored AI features integrating with CRM and I believe Copilot capabilities can greatly enhance productivity and efficiency.
I have experience implementing AI chatbots for customer service in CRM systems
AI features can automate repetitive tasks, improve data accuracy, and provide personalized customer interactions
Copilot capabilities can assist users in making data-driven decisions and predicting customer b...
Marketing CRM includes customer data management, campaign tracking, lead generation, and customer engagement.
Customer data management involves storing and organizing customer information such as contact details, purchase history, and preferences.
Campaign tracking allows marketers to monitor the performance of their marketing campaigns, including metrics like open rates, click-through rates, and conversions.
Lead generat...
Workflows are a series of tasks that are automated to achieve a specific goal, while Power Automate is a tool that allows users to create automated workflows.
Workflows are a sequence of tasks that are executed in a specific order to achieve a desired outcome
Power Automate is a platform that enables users to automate workflows across various applications and services
Workflows can be manual or automated, while Power Auto...
Yes, in C# you can quickly write code to a plugin using classes.
Yes, in C# you can quickly write code to a plugin by creating a class that implements a specific interface or inherits from a base class.
Classes in C# are blueprints for creating objects. They can contain fields, properties, methods, events, and more.
For example, you can create a plugin interface and then create a class that implements that interface to wr...
Aptitude questions choose the multiple answers
Technical coding which choose the multiple answers
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
Code is maintained using version control systems like Git, with separate branches for Dev, QA, and Production.
Use version control systems like Git to track changes and manage code.
Create separate branches for Dev, QA, and Production to isolate changes and prevent conflicts.
Implement a code review process to ensure quality and consistency across environments.
Automate deployment processes to easily promote code changes f...
ACID properties ensure database transactions are processed reliably.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that either all operations in a transaction are completed or none are.
Consistency ensures that the database remains in a valid state before and after the transaction.
Isolation ensures that multiple transactions can occur concurrently without affecting each other.
Durabil...
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit. Abstraction is the concept of hiding the implementation details and showing only the necessary features of an object.
Encapsulation helps in data hiding and prevents direct access to data from outside the class.
Abstraction helps in reducing complexity by hiding unnecessary details and showing only essential features.
En...
Abstract class is a class that cannot be instantiated and may contain abstract methods. Interface is a contract that defines methods that a class must implement.
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
A class can inherit only one abstract class but can implement multiple interfaces.
Abstract classes are used when you want to provide a default impleme...
Routing is the process of directing network traffic to its destination. Conventional Routing is a method of defining routes based on conventions.
Routing is the process of determining the path that network packets should take from the source to the destination.
Conventional Routing involves defining routes based on conventions or predefined rules.
In web development, routing refers to mapping URLs to specific controllers ...
GC stands for Garbage Collection. It is a process of automatically reclaiming memory occupied by objects that are no longer in use.
GC is a part of the .NET runtime that manages memory by automatically freeing up memory occupied by objects that are no longer needed.
We can suggest the GC to run by calling the GC.Collect() method, but it is not recommended to force GC as it can have performance implications.
Forcing GC to ...
MasterPage is a feature in ASP.NET that allows for creating a consistent layout for multiple pages.
MasterPage defines the common structure and interface for all pages in a web application.
It allows for the separation of content and layout, making it easier to maintain and update.
MasterPage can contain placeholders for content that can be filled in by individual pages.
Changes made to the MasterPage will be reflected acr...
Error handling in .NET application involves using try-catch blocks to handle exceptions and ensure graceful error recovery.
Use try-catch blocks to catch exceptions and handle them appropriately
Use specific exception types for different error scenarios
Implement logging to track errors and troubleshoot issues
Consider using global exception handling for unhandled exceptions
Use custom error messages to provide meaningful f...
Code deployment in test environment involves creating a deployment package and deploying it to the test server.
Create a deployment package containing all necessary files and configurations.
Deploy the package to the test server using tools like Octopus Deploy or Azure DevOps.
Test the deployed code in the test environment to ensure it functions as expected.
finally is used in exception handling, final is a keyword for classes, Dispose is used for releasing unmanaged resources.
finally block is used in exception handling to ensure a piece of code is always executed, whether an exception is thrown or not.
final keyword is used in C# to prevent inheritance or overriding of a method, class, or property.
Dispose method is used to release unmanaged resources like file handles or d...
Lazy loading is a design pattern where data is loaded only when it is needed.
Lazy loading helps improve performance by loading data on demand
It is commonly used in ORM frameworks like Entity Framework
Example: Loading related entities only when accessed in a database query
SOLID is a set of five design principles in object-oriented programming. One of them is the Single Responsibility Principle (SRP).
SRP states that a class should have only one reason to change, meaning it should only have one job or responsibility.
For example, a class that handles both user authentication and database operations violates SRP. It should be split into two separate classes.
SRP helps in making code more mai...
MVC page cycle is the sequence of events that occur during the lifespan of a MVC page.
MVC page is requested by the user
Routing engine determines the appropriate controller and action method
Controller executes the action method and returns a view
View is rendered and sent back to the user's browser
ASP .Net Page Lifecycle is a series of events that occur when a page is requested, processed, and rendered by the server.
Page Request: Initiated by the user or browser.
Page Initialization: Page properties are set.
Page Load: Controls on the page are loaded and data is bound.
Postback Event Handling: User interactions trigger events.
Page Rendering: Page is rendered to HTML and sent to the browser.
Page Unload: Cleanup and ...
Sealed classes cannot be inherited from. They are used to prevent inheritance and ensure class integrity.
Sealed classes are declared using the 'sealed' keyword in C#.
They are used to prevent other classes from inheriting from them.
Sealed classes can inherit from other classes, but they cannot be inherited from.
Global tables are accessible to all sessions, while temp tables are only accessible to the session that created them.
Global tables are permanent and stored in the database, while temp tables are temporary and stored in memory or tempdb.
Global tables can be accessed by multiple users and sessions, while temp tables are local to the session that created them.
Global tables require explicit creation and dropping, while tem...
Session management in ASP .Net involves storing user-specific data during their visit to a website.
ASP .Net provides in-process, state server, and SQL Server session management options
In-process session management stores session data in memory on the web server
State server session management stores session data in a separate server process
SQL Server session management stores session data in a SQL Server database
Session...
Cursors in SQL are used to iterate through a result set, triggers are not always required but can be useful for enforcing business rules.
Cursors in SQL are used to fetch and process individual rows from a result set.
Triggers in SQL are used to automatically perform actions when certain events occur in a database.
Triggers can be useful for enforcing data integrity constraints or auditing changes to data.
Syntax of a trig...
Regular expression is a sequence of characters that define a search pattern.
Regular expressions are used for pattern matching in strings
They can be used for tasks like validation, searching, and replacing text
Examples: ^[a-zA-Z0-9]+@[a-zA-Z0-9]+\.[a-zA-Z]{2,4}$ is a regex for email validation
The var keyword is not used in SQL, it is used in C# to declare implicitly typed variables.
The var keyword in C# allows you to declare a variable without explicitly specifying the type, the type is inferred by the compiler.
In SQL, you must explicitly specify the data type when declaring variables or columns.
Example in C#: var number = 10; // Compiler infers that number is an integer
Example in SQL: DECLARE @name VARCHAR...
I appeared for an interview in Dec 2024.
The assessment consists of four components: 1. Logical reasoning, 2. MS Excel, 3. PTP, and 4. Detail orientation.
In my previous position, I was responsible for managing daily operations, coordinating with different departments, and ensuring smooth workflow.
Managed daily operations to ensure efficiency
Coordinated with various departments for seamless communication
Ensured smooth workflow by resolving any operational issues
Implemented process improvements to increase productivity
SAP is an enterprise resource planning software that helps streamline business processes, including the Procure-to-Pay process.
SAP stands for Systems, Applications, and Products in Data Processing.
It integrates various functions within an organization, such as finance, HR, and procurement.
In the Procure-to-Pay process, SAP helps automate and optimize the purchasing process from requisition to payment.
It allows for bett...
I handle vendors by establishing clear communication channels, setting expectations, negotiating terms, and monitoring performance.
Establish clear communication channels with vendors to ensure smooth operations
Set clear expectations regarding deliverables, timelines, and quality standards
Negotiate terms and contracts to ensure mutually beneficial agreements
Monitor vendor performance regularly and address any issues pro...
The organization offers competitive salary structure, various shifts, and comprehensive benefits.
Competitive salary structure based on experience and qualifications
Multiple shifts available including day, evening, and night shifts
Comprehensive benefits package including health insurance, retirement plans, and paid time off
My expectations are to contribute to the success of the company by utilizing my skills and knowledge. My long-term goal is to grow within the organization and take on more responsibilities.
Expectations to contribute to the success of the company
Long-term goal to grow within the organization
Desire to take on more responsibilities
I applied via Approached by Company and was interviewed in Dec 2024. There was 1 interview round.
Core ABAP involves programming fundamentals in SAP, focusing on data manipulation, reporting, and application development.
Data Dictionary: Defines database objects like tables and views. Example: Creating a table for storing customer data.
Modularization: Use of function modules and methods to enhance code reusability. Example: Creating a function module for calculating discounts.
Reports: ABAP allows for the creation of...
I applied via Referral and was interviewed in Oct 2024. There were 2 interview rounds.
Implement a dynamic drop-down for multiple catalog items by using a centralized data source and event-driven updates.
Identify a centralized data source (e.g., database or API) for the drop-down options.
Use AJAX or similar technology to fetch options dynamically based on user input or selections.
Implement event listeners to update the drop-down when related fields change.
Ensure the drop-down is populated with relevant o...
Code to print a user and their manager hierarchy in a structured format.
Define a data structure to represent users and their managers.
Use recursion or iteration to traverse the hierarchy.
Example structure: { 'Alice': 'Bob', 'Bob': 'Charlie' }
Print the user and each level of their managers.
I applied via Naukri.com
Find pairs in an array that sum up to a specified target number.
Use a hash set to track numbers we've seen.
For each number, check if (target - number) exists in the set.
Example: For array [1, 2, 3, 4] and target 5, pairs are (1, 4) and (2, 3).
Return unique pairs to avoid duplicates.
I applied via Approached by Company and was interviewed in Nov 2024. There were 2 interview rounds.
HTML, CSS, and JS have seen significant updates, enhancing web development with new features and improved performance.
HTML: HTML5 introduced semantic elements like <article>, <section>, and <header> for better structure.
CSS: CSS Grid and Flexbox allow for responsive layouts, making design more flexible and easier to manage.
JavaScript: ES2022 brought features like class fields and top-level await, stre...
ES10 introduced features like optional catch binding, array flat methods, and more for improved JavaScript functionality.
Optional Catch Binding: You can omit the error parameter in catch blocks. Example: 'try { ... } catch { ... }'
Array.prototype.flat(): Flattens nested arrays. Example: '[1, 2, [3, 4]].flat() // [1, 2, 3, 4]'
Array.prototype.flatMap(): Maps and flattens arrays in one go. Example: '[1, 2, 3].flatMap(x =&...
Async functions simplify working with promises, allowing for cleaner, more readable asynchronous code.
Promises are objects representing the eventual completion (or failure) of an asynchronous operation, while async functions are a syntactic sugar over promises.
Async functions always return a promise, even if you return a non-promise value; it gets wrapped in a resolved promise.
Example: const result = await someAsyncFun...
In JavaScript, everything is an object, allowing for flexible data manipulation and dynamic behavior in programming.
Primitive types (like numbers, strings) are wrapped in objects when needed, e.g., `let str = 'hello'; str.length`.
Functions are first-class objects, meaning they can be assigned to variables, passed as arguments, and returned from other functions.
Arrays are special types of objects, allowing for indexed c...
The duration of Accenture interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 1.8k interview experiences
Difficulty level
Duration
based on 63.6k reviews
Rating in categories
Application Development Analyst
39.3k
salaries
| ₹4.8 L/yr - ₹11 L/yr |
Application Development - Senior Analyst
27.7k
salaries
| ₹8.2 L/yr - ₹16 L/yr |
Team Lead
26.5k
salaries
| ₹12.6 L/yr - ₹22.4 L/yr |
Senior Analyst
19.5k
salaries
| ₹9 L/yr - ₹15.7 L/yr |
Senior Software Engineer
18.5k
salaries
| ₹10.4 L/yr - ₹18 L/yr |
TCS
Cognizant
Capgemini
Infosys