Filter interviews by
I applied via Company Website
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
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
Research industry standards for similar positions
Consider cost of living in the area
Factor in benefits and bonuses offered by the company
Be prepared to negotiate based on your value to the organization
I am a results-driven executive with over 10 years of experience in leading teams and driving business growth.
Experienced executive with a proven track record of success
Skilled in team leadership and business development
Strong focus on achieving results and driving growth
I managed the night shift and traveling by prioritizing rest, staying organized, and utilizing technology.
Prioritized rest by ensuring adequate sleep during the day
Stayed organized by planning ahead and packing essentials in advance
Utilized technology for efficient communication and navigation while traveling
EXL is a leading operations management and analytics company that helps businesses improve performance.
EXL offers services in areas such as finance and accounting, healthcare, insurance, and more
They use advanced analytics and technology to drive business transformation
EXL has a global presence with offices in multiple countries
Insurance is a financial product that provides protection against potential risks and losses.
Insurance involves an agreement between an individual or entity and an insurance company.
The individual or entity pays a premium in exchange for coverage against specific risks, such as property damage, illness, or liability.
Examples of insurance include health insurance, car insurance, life insurance, and property insurance.
Premium refers to the amount of money an individual or business pays for an insurance policy.
Premium is the cost of purchasing an insurance policy
It is typically paid on a regular basis, such as monthly or annually
The premium amount is determined by factors such as the type of insurance, coverage amount, and the individual's risk profile
My current CTC is $100,000 and I am looking for a 15% increase in my next role.
Current CTC: $100,000
Expectation: 15% increase
Looking for opportunities in the range of $115,000 - $120,000
Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.
posted on 23 Oct 2024
I applied via Naukri.com and was interviewed in Sep 2024. There were 5 interview rounds.
Easy Level DS Questions - 30 mins
A comprehensive coding test which included job role simulation.
Advanced Cloud Services questions
I am a Senior Software Developer with 8 years of experience in full-stack development, specializing in Java and Angular.
8 years of experience in full-stack development
Specialize in Java and Angular
Strong problem-solving skills
Experience working in agile environments
posted on 14 Oct 2024
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There was 1 interview round.
Wifi AC is the 5th generation of wifi technology, while Wifi Ax is the 6th generation with improved speed and efficiency.
Wifi AC operates on the 5 GHz band, while Wifi Ax operates on both 2.4 GHz and 5 GHz bands.
Wifi Ax supports MU-MIMO (Multi-User, Multiple Input, Multiple Output) technology for better performance in crowded networks.
Wifi Ax offers higher data rates and improved efficiency compared to Wifi AC.
Wifi Ax ...
DTIM stands for Delivery Traffic Indication Message, used in Wi-Fi networks to inform clients about the presence of buffered broadcast and multicast frames.
DTIM is a parameter in the Wi-Fi beacon frame that indicates to clients how often they should wake up to receive broadcast and multicast traffic.
It helps in saving battery life for devices by allowing them to sleep for longer periods of time.
Clients can set their po...
posted on 2 Nov 2024
I applied via Walk-in and was interviewed in May 2024. There was 1 interview round.
SEO stands for Search Engine Optimization, which is the practice of increasing the quantity and quality of traffic to your website through organic search engine results.
SEO involves optimizing your website to improve its visibility on search engines like Google.
It includes keyword research, on-page optimization, link building, and content creation.
The goal of SEO is to drive more organic traffic to your website and imp...
Domain is the address of a website, hosting is the service that stores the website's files and makes it accessible online.
Domain is the unique address of a website on the internet, like www.example.com
Hosting is the service that stores the website's files and data on a server, making it accessible online
Domain registration is the process of purchasing and owning a domain name
Web hosting providers offer different types ...
Some main SEO tools include Google Analytics, SEMrush, Ahrefs, Moz, and Screaming Frog.
Google Analytics for tracking website traffic and user behavior
SEMrush for keyword research and competitive analysis
Ahrefs for backlink analysis and site auditing
Moz for SEO insights and rank tracking
Screaming Frog for website crawling and technical SEO analysis
Google Adwords is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google ad network to web users.
Online advertising platform by Google
Advertisers pay to display ads
Can display various types of ads like text, display, video, etc.
Helps in reaching target audien
Organic search refers to the unpaid search results generated by search engines based on relevance to the user's query.
Organic search results are not influenced by paid advertising.
Websites can improve their organic search rankings through search engine optimization (SEO) techniques.
Examples of organic search results include links to websites, blogs, and articles that are deemed relevant to the user's search query.
Keywords are specific words or phrases that describe the content of a webpage and are used in SEO to help search engines understand the topic of the page.
Keywords are used to optimize a website's content for search engines.
They help search engines match a webpage to relevant search queries.
Examples of keywords include 'SEO tips', 'best digital marketing agency', 'how to increase website traffic'.
Keywords analysis is the process of researching and identifying the most relevant keywords for a website to improve its search engine rankings.
Keywords analysis involves identifying popular search terms related to a website's content.
It helps in understanding what keywords users are searching for and how competitive those keywords are.
Tools like Google Keyword Planner can be used for keywords analysis.
The goal is to se...
I applied via Naukri.com and was interviewed in Mar 2024. There were 3 interview rounds.
Securitisation is the process of pooling various types of debt and selling them as securities to investors.
Securitisation involves bundling together various types of debt, such as mortgages, auto loans, or credit card debt.
These debts are then sold to a special purpose vehicle (SPV) which issues securities backed by the cash flows from the underlying assets.
Investors purchase these securities and receive payments based...
Financial ratios are tools used to evaluate a company's financial performance and health.
Financial ratios are calculated using data from a company's financial statements.
They help investors and analysts assess a company's profitability, liquidity, efficiency, and solvency.
A good number for a financial ratio can vary depending on the industry and company size.
For example, a current ratio of 2 or higher is generally cons...
Excel functions like Vlookup, Hlookup, Xlookup, IF/AND/OR are used for data lookup and logical operations.
Vlookup: Searches for a value in the first column of a table and returns a value in the same row from a specified column.
Hlookup: Similar to Vlookup but searches for a value in the first row of a table.
Xlookup: A more versatile version of Vlookup and Hlookup that can search both vertically and horizontally.
IF: Retu...
I applied via Naukri.com and was interviewed in Jul 2024. There were 2 interview rounds.
JAM just introduce yourself or speak on sometime topic shared
English knowledge pen n paper
posted on 16 Dec 2024
First round is easy the aptitude test, they will mainly focus on the logical question
They have asked 2 coding questions you can write in python or c or java
based on 33 reviews
Rating in categories
HR Manager
6
salaries
| ₹4.1 L/yr - ₹10.5 L/yr |
E-Commerce Executive
5
salaries
| ₹1.5 L/yr - ₹2.5 L/yr |
Senior Merchandiser
5
salaries
| ₹4.2 L/yr - ₹6.4 L/yr |
Team Lead
4
salaries
| ₹2 L/yr - ₹8 L/yr |
Merchandiser
4
salaries
| ₹3 L/yr - ₹7 L/yr |
Prime Focus
Reliance Big Entertainment
DNEG CREATIVE SERVICES
Technicolor