AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
eClerx
Compare
Filter interviews by
eClerx Interview Questions, Process, and Tips
Top eClerx Interview Questions and Answers
- Q1. What is capital markets its types and money Marketasked in Financial Analyst interview
- Q2. what will you do if set of box suddenly switched off?asked in Analyst interview
- Q3. Q.What does an AUC value of 50% mean? Is it possible to have an AUC value of less than 50%?asked in Senior Analyst interview
eClerx Interview Experiences
516 interviews found
Anonymous
Interview Questionnaire
8 Questions
- Q1. I joined as MSBI and Power Bi developer
- Q2. Count the duplicate values in table.
- Ans.
To count duplicate values in a table, use the COUNT and GROUP BY functions in SQL.
Write a SQL query that selects the column with the duplicate values.
Use the COUNT function to count the number of times each value appears.
Use the GROUP BY function to group the results by the column with the duplicate values.
Filter the results to only show values with a count greater than 1.
Alternatively, use Excel's COUNTIF function to
- Q3. Question on join and their types and store procedure, function
- Q4. How to optimize query
- Ans.
Optimizing queries involves reducing the time and resources required to retrieve data from a database.
Use indexes to speed up data retrieval
Avoid using SELECT * and instead specify the required columns
Use JOINs instead of subqueries
Avoid using functions in WHERE clauses
Limit the number of rows returned using LIMIT
Use EXPLAIN to analyze query performance
Normalize the database to reduce redundancy
Consider using caching m
- Q5. How to fetch multiple rows dynamically in SSRS,
- Ans.
To fetch multiple rows dynamically in SSRS, use parameters and SQL queries.
Create a parameter to accept multiple values
Use the IN operator in SQL query to fetch multiple rows
Example: SELECT * FROM table WHERE column IN (@parameter)
Ensure the parameter is set to allow multiple values
Preview the report to test the dynamic fetching
- Q6. How to deployed bulk report in ssrs
- Ans.
Bulk reports in SSRS deployment
Create a data-driven subscription
Use the Report Manager to upload and deploy the report
Use PowerShell scripts to automate the deployment process
- Q7. Group by in SSRS
- Ans.
Group by in SSRS allows grouping of data based on a specific column or expression.
Grouping can be done in the tablix or matrix data region.
Grouping can be based on a single column or multiple columns.
Grouping can also be done based on expressions or custom code.
Grouping can be used to create subtotals and totals for each group.
Grouping can also be used to create drilldown reports.
Examples: Grouping sales data by region
- Q8. 2nd highest salary in sql
- Ans.
To find 2nd highest salary in SQL, use the ORDER BY and LIMIT clauses.
Use ORDER BY to sort the salaries in descending order
Use LIMIT to select the second highest salary
Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT 1,1
Skills evaluated in this interview
Top eClerx Associate Process Manager Interview Questions and Answers
Associate Process Manager Interview Questions asked at other Companies
Selected
(6 Questions)
- Q1. Whats your name?
- Ans.
My name is John Doe.
Full name is John Doe
Common first and last name combination
Easy to remember and pronounce
- Q2. Csv stand for?
- Ans.
CSV stands for Comma-Separated Values.
CSV is a file format used to store tabular data in plain text.
Each line in a CSV file represents a row of data, with columns separated by commas.
CSV files can be easily imported and exported in spreadsheet software like Excel.
Example: 'name,age,city' on the first line, followed by 'John,25,New York' on the second line.
- Q3. Tell me something about yourself?
- Ans.
Hello,First of all thankyou very much for giving opportunity to introduced in front of you.I am harsh.I hail from ambala cantt but currently live in defence enclave.I am a fresher. I live in nuclear family.There are 5 of us in my family.I am a object oriented person. I have a master degree in computer application from kurukshetra university.I have done 6 month course in data analyst from chandigarh.I enjoy dancing,Sing...
- Q4. Sql stand for?
- Ans.
SQL stands for Structured Query Language.
SQL is a standard language for accessing and manipulating databases.
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables.
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
- Q5. Write a dml commands?
- Ans.
DML commands are used to manipulate data in a database.
DML stands for Data Manipulation Language
Common DML commands include INSERT, UPDATE, DELETE
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2)
- Q6. Rdbms stands for?
Top eClerx Data Analyst Interview Questions and Answers
Data Analyst Interview Questions asked at other Companies
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 3 interview rounds.
(3 Questions)
- Q1. Tell me about yourself
- Q2. What is derivative and its type
- Ans.
A derivative is a financial contract whose value is derived from the performance of an underlying asset, index, or rate.
Derivatives can be used for hedging, speculation, or arbitrage.
Types of derivatives include options, futures, forwards, and swaps.
Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price before or on a specified date.
Futures are contracts to buy or sell a...
- Q3. What is margin
- Ans.
Margin is the difference between the selling price of a product or service and the cost of producing it.
Margin is calculated by subtracting the cost of goods sold (COGS) from the selling price.
It represents the profit a company makes on each unit sold.
Gross margin is the percentage of revenue that exceeds the COGS.
For example, if a product sells for $100 and the COGS is $60, the margin is $40.
A higher margin indicates
English speaking test , one minute talk on particular topic , english grammar, typing test , reasoning and quants little
(3 Questions)
- Q1. What is derivative and its type
- Ans.
A derivative is a financial contract whose value is derived from the performance of an underlying asset, index, or entity.
Derivatives can be used for hedging, speculation, or arbitrage.
Types of derivatives include options, futures, forwards, and swaps.
Options give the holder the right, but not the obligation, to buy or sell an asset at a specified price before or on a specified date.
Futures are contracts to buy or sell...
- Q2. What is reconciliation
- Ans.
Reconciliation is the process of comparing two sets of records to ensure they are in agreement and resolving any discrepancies.
Reconciliation involves comparing financial records, such as bank statements and accounting records, to identify any discrepancies.
It is important for ensuring accuracy in financial reporting and detecting errors or fraud.
Examples of reconciliation include bank reconciliation, where the bank st...
- Q3. Behavioral based questions
Interview Preparation Tips
Top eClerx Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions asked at other Companies
What people are saying about eClerx
Selected
I was interviewed in Dec 2024.
(2 Questions)
- Q1. What is fund accounting and role of fund manager?
- Ans.
Fund accounting is a specialized form of accounting used by non-profit organizations and government agencies to track and manage funds.
Fund accounting involves tracking and reporting on funds designated for specific purposes or programs.
Fund managers are responsible for overseeing the investment and distribution of funds to ensure they are used in accordance with donor or regulatory requirements.
Examples of fund accoun...
- Q2. Hedge fund and reconciliation process
(1 Question)
- Q1. People management, team huddling experience.
eClerx interview questions for popular designations
Umarfarooq Kalmani
(2 Questions)
- Q1. What do you know about customer service
- Ans.
Customer service involves providing assistance and support to customers before, during, and after a purchase.
Customer service is essential for building and maintaining positive relationships with customers.
It includes addressing customer inquiries, resolving complaints, and ensuring customer satisfaction.
Examples of good customer service practices include active listening, empathy, and timely responses to customer need...
- Q2. How customer service is important
- Ans.
Customer service is important for building customer loyalty, resolving issues, and creating positive experiences.
Customer service is crucial for building customer loyalty and retaining customers.
It helps in resolving customer issues and complaints effectively.
Good customer service can lead to positive word-of-mouth and repeat business.
It plays a key role in creating a positive customer experience and building brand rep...
(2 Questions)
- Q1. What was your role and responsibilities
- Q2. What do you know about router
- Ans.
A router is a networking device that forwards data packets between computer networks.
Routers operate at the network layer of the OSI model
They use routing tables to determine the best path for data packets to reach their destination
Routers can be wired or wireless, and are commonly used in home and business networks
Examples of popular router brands include Cisco, Netgear, and TP-Link
Interview Preparation Tips
Skills evaluated in this interview
Top eClerx Analyst Interview Questions and Answers
Analyst Interview Questions asked at other Companies
Get interview-ready with Top eClerx Interview Questions
Selected
I applied via Walk-in and was interviewed in Nov 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Can you provide a self-introduction?
- Ans.
Experienced financial analyst with a strong background in financial modeling and data analysis.
Over 5 years of experience in financial analysis
Proficient in financial modeling and forecasting
Skilled in data analysis and interpretation
Strong knowledge of accounting principles and financial regulations
Excellent communication and presentation skills
- Q2. What is dervatives,investment banking,otc,capital markets,types of derivatives?
- Ans.
Derivatives are financial instruments whose value is derived from an underlying asset, investment banking involves providing financial services to corporations, OTC refers to over-the-counter trading, and capital markets are where securities are bought and sold.
Derivatives are financial instruments whose value is based on an underlying asset, such as stocks, bonds, commodities, or currencies
Investment banking involves ...
(2 Questions)
- Q1. Talk about covid pandemic for 5 mins ?
- Ans.
The COVID-19 pandemic has had a significant impact on global economies, financial markets, and businesses.
Global economies experienced recession due to lockdowns and restrictions.
Financial markets saw increased volatility and uncertainty.
Businesses had to adapt to remote work and changing consumer behavior.
Government stimulus packages were implemented to support economies.
Supply chains were disrupted, leading to shorta
- Q2. What are futures and options?
- Ans.
Futures and options are financial derivatives that allow investors to speculate on the price movements of assets without owning them.
Futures are contracts to buy or sell an asset at a specified price on a future date.
Options give the holder the right, but not the obligation, to buy or sell an asset at a predetermined price within a specific time frame.
Both futures and options are used for hedging, speculation, and arbi...
Interview Preparation Tips
Top eClerx Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions asked at other Companies
Jobs at eClerx
Selected
I was interviewed in Dec 2024.
(3 Questions)
- Q1. Introduction to myself
- Q2. My future planning
- Q3. Introduction to myself and my future planning
Interview Preparation Tips
Computer Operator Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Introduce yourself
- Ans.
I am a Citrix Administrator with 5 years of experience managing virtual desktop infrastructure.
5 years of experience in Citrix administration
Proficient in managing virtual desktop infrastructure
Skilled in troubleshooting Citrix-related issues
- Q2. What are the education and work experience
- Ans.
A bachelor's degree in computer science or related field is typically required, along with relevant work experience in IT administration.
Bachelor's degree in computer science, information technology, or related field
Experience in IT administration, particularly with Citrix systems
Certifications such as Citrix Certified Associate - Virtualization (CCA-V) or Citrix Certified Professional - Virtualization (CCP-V) may be p...
(6 Questions)
- Q1. What is the role of active directory and how should differentiate group policy?
- Ans.
Active Directory is a directory service that stores information about objects on a network and allows for centralized management. Group Policy is used to manage user and computer settings within an Active Directory environment.
Active Directory is a centralized database that stores information about network resources such as users, computers, and printers.
It allows for centralized management of network resources, includ...
- Q2. Experience about citrix
- Ans.
I have 5 years of experience working with Citrix, including managing virtual desktops, applications, and troubleshooting issues.
Managed Citrix XenApp and XenDesktop environments
Configured and maintained Citrix Provisioning Services
Troubleshooted user connectivity and performance issues
Implemented Citrix policies and profiles for security and user experience
Upgraded Citrix infrastructure to newer versions
- Q3. Diff between service request and incident ?
- Ans.
Service request is a request for a new service or change to an existing service, while an incident is an unplanned interruption to a service.
Service request is proactive, while incident is reactive
Service request is planned, while incident is unplanned
Examples: Requesting access to a new software (service request) vs. software crashing unexpectedly (incident)
- Q4. About ports like 443/80
- Q5. Osi model of network
- Ans.
The OSI model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven different layers.
The OSI model stands for Open Systems Interconnection model.
It consists of seven layers: Physical, Data Link, Network, Transport, Session, Presentation, and Application.
Each layer has specific functions and communicates with the adjacent layers.
The model helps in understanding h...
- Q6. What is idrac and networking system
- Ans.
iDRAC is Integrated Dell Remote Access Controller used for remote management of Dell servers. Networking system refers to the infrastructure that allows devices to communicate with each other.
iDRAC stands for Integrated Dell Remote Access Controller
iDRAC allows remote management of Dell servers
Networking system refers to the infrastructure that enables devices to communicate with each other
Networking system includes ha...
Interview Preparation Tips
Knowledge of virtual machine like VMware ,AVD ,Citrix.
Knowledge of group policy ,ou and active directory.
Knowledge of tools using in past organisation
Skills evaluated in this interview
Citrix Administrator Interview Questions asked at other Companies
Rohit Gothal
Selected
I applied via Walk-in and was interviewed in Dec 2024. There were 2 interview rounds.
(1 Question)
- Q1. Why do want to join eclerx?
- Ans.
I want to join eClerx because of its reputation for providing excellent analytical services and opportunities for professional growth.
I am impressed by eClerx's track record of delivering high-quality analytical solutions to clients.
I am excited about the potential for learning and growth within eClerx's dynamic and innovative work environment.
I believe that my skills and experience align well with the opportunities av...
(1 Question)
- Q1. Tell me about financial market?
- Ans.
Financial market is a platform where buyers and sellers trade financial securities, commodities, and other fungible items.
Financial markets facilitate the exchange of assets such as stocks, bonds, currencies, and derivatives.
They can be classified into primary and secondary markets based on the issuance of securities.
Examples include stock exchanges like NYSE and NASDAQ, commodity markets like CBOT and LME, and forex m...
Top eClerx Analyst Interview Questions and Answers
Analyst Interview Questions asked at other Companies
I applied via Walk-in and was interviewed in Jul 2024. There were 4 interview rounds.
They give trending topics to discuss to check our communication.
Moderate test not too hard basically related to communication, pronounciation, logical reasoning, graphs, charts, numericals...
(3 Questions)
- Q1. About your self?
- Q2. Past Job Experience based Questions...
- Q3. Basic Finance Related Questions
(6 Questions)
- Q1. Summary of your resume
- Q2. Investment banking topics
- Q3. Derivatives/types
- Q4. Future Contract/forward Contract
- Q5. Money market/Capital Market
- Q6. Accounting Golden rules with Examples and entries..
- Ans.
The accounting golden rules are basic principles that guide the process of recording financial transactions.
The first golden rule is Debit what comes in, Credit what goes out. For example, when cash is received, it is debited, and when cash is paid out, it is credited.
The second golden rule is Debit the receiver, Credit the giver. For example, when goods are purchased on credit, the receiver is debited, and the giver i...
Interview Preparation Tips
- Investment Banking
- Capital Market
- Anti Money Laundering
- KYC
- Money Market
- Derivatives
Top eClerx Financial Analyst Interview Questions and Answers
Financial Analyst Interview Questions asked at other Companies
Selected
I was interviewed in Jul 2024.
The first round was a communication test with an aptitude round consisting of three sections i.e. verbal ability, logical reasoning, and quantitative aptitude.
(7 Questions)
- Q1. What was your final year project?
- Ans.
Developed a machine learning model to predict stock prices using historical data
Used Python programming language for data preprocessing and model development
Implemented various machine learning algorithms such as Random Forest and LSTM
Evaluated model performance using metrics like RMSE and MAE
- Q2. What is the peak bandwidth of 5g network?
- Ans.
The peak bandwidth of 5G network is around 10 Gbps.
Peak bandwidth of 5G network can reach up to 10 Gbps (Gigabits per second).
5G technology offers significantly higher peak data rates compared to 4G networks.
The actual peak bandwidth may vary depending on network conditions and deployment.
5G networks use advanced technologies like massive MIMO and beamforming to achieve high data rates.
- Q3. What is a transistor?
- Ans.
A transistor is a semiconductor device used to amplify or switch electronic signals.
Transistors are fundamental building blocks of modern electronic devices.
They can amplify electrical signals, control the flow of current, and act as switches.
Common types of transistors include bipolar junction transistors (BJTs) and field-effect transistors (FETs).
- Q4. What is an amplifier?
- Ans.
An amplifier is a device that increases the amplitude of a signal.
An amplifier takes a weak input signal and increases its strength
It is commonly used in audio systems to increase the volume of sound
Examples include guitar amplifiers, stereo amplifiers, and operational amplifiers
- Q5. What is Surface mount technology (SMT)?
- Ans.
Surface mount technology (SMT) is a method for producing electronic circuits in which the components are mounted or placed directly onto the surface of printed circuit boards (PCBs).
Components are mounted directly onto the surface of PCBs, as opposed to through-hole technology where components have leads inserted into holes on the board.
SMT allows for smaller and lighter electronic devices, as well as automated assembl...
- Q6. Last question was scenario based technical question where they expected me to convince a user to purchase a smartphone based on technical specification of that smartphone?
- Q7. Resume based question for my past volunteer experience?
Interview Preparation Tips
Stay humble, be curious and be happy.
Top eClerx Analyst Interview Questions and Answers
Analyst Interview Questions asked at other Companies
eClerx Interview FAQs
The duration of eClerx interview process can vary, but typically it takes about less than 2 weeks to complete.
Recently Viewed
INTERVIEWS
3 Minds Digital
No Interviews
INTERVIEWS
Moris Media
No Interviews
SALARIES
Home First Finance Company India
SALARIES
Colgate Global Business Services
INTERVIEWS
Flipkart
No Interviews
INTERVIEWS
Genpact
No Interviews
SALARIES
OneAssist Consumer Solutions
DESIGNATION
SALARIES
OneAssist Consumer Solutions
INTERVIEWS
IBM
No Interviews
Tell us how to improve this page.
eClerx Interviews By Designations
- eClerx Financial Analyst Interview Questions
- eClerx Analyst Interview Questions
- eClerx Senior Analyst Interview Questions
- eClerx Associate Process Manager Interview Questions
- eClerx Data Analyst Interview Questions
- eClerx Processing Manager Interview Questions
- eClerx Senior Financial Analyst Interview Questions
- eClerx KYC Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Financial Analyst Interview Questions
- Analyst Interview Questions
- Senior Analyst Interview Questions
- Associate Process Manager Interview Questions
- Data Analyst Interview Questions
- Processing Manager Interview Questions
- Senior Financial Analyst Interview Questions
- KYC Analyst Interview Questions
- Show more
eClerx Interview Process
based on 405 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Analyst
5.5k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Financial Analyst
4.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Analyst
4.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Process Manager
2.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Processing Manager
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- eClerx Interview Questions
