AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
eClerx
Compare
Filter interviews by
eClerx Associate Process Manager Interview Questions, Process, and Tips
Top eClerx Associate Process Manager Interview Questions and Answers
- Q1. What type of order will you place if the market is expected to go upward?
- Q2. 1.What do you understand by derivative markets and types 2. Types of cryptocurrency 3. Questions over internship or work exp.
- Q3. How to fetch multiple rows dynamically in SSRS,
eClerx Associate Process Manager Interview Experiences
28 interviews found
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
Selected
I applied via Company Website and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Trade life cycle in OTC derivatives
- Ans.
The trade life cycle in OTC derivatives involves several stages from trade initiation to settlement.
Trade initiation: Counterparties agree on terms and execute the trade.
Confirmation: Parties confirm the trade details to ensure accuracy.
Valuation: Mark-to-market valuation of the trade is performed regularly.
Margining: Margin calls may be made to cover potential losses.
Settlement: Cash flows are exchanged on agreed-upon...
- Q2. Team Management
Interview Preparation Tips
Selected
I applied via campus placement at Pune Institute of Business Management, Pune and was interviewed in Dec 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Tell me about yourself
- Q2. Tell me about derivatives
- Ans.
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage
Common types of derivatives include options, futures, forwards, and swaps
Derivatives allow investors to take on leverage and potentially amplify returns
Derivatives markets are often used by institutional investors and traders
(2 Questions)
- Q1. Tell me about derivatives
- Ans.
Derivatives are financial instruments whose value is derived from an underlying asset or group of assets.
Derivatives can be used for hedging, speculation, or arbitrage
Common types of derivatives include options, futures, forwards, and swaps
Derivatives allow investors to take on leverage and potentially increase returns
Derivatives are traded on exchanges or over-the-counter markets
- Q2. Difference between future and forwards
Interview Preparation Tips
What people are saying about eClerx
Selected
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. What leader qualities you have.
- Ans. Explain the qualities what u have in yourself or what u did in your current profile.
eClerx interview questions for designations
(2 Questions)
- Q1. What corporate Action
- Q2. How to manage team
Get interview-ready with Top eClerx Interview Questions
(1 Question)
- Q1. About Sebi laws and companies act
(1 Question)
- Q1. About sebi laws and companies act
(1 Question)
- Q1. Salary negotiation
Associate Process Manager Jobs at eClerx
(1 Question)
- Q1. How you handle team attrition? What should be the goal?
(1 Question)
- Q1. Why should be hire you?
Selected
I applied via Campus Placement and was interviewed in Sep 2022. There were 4 interview rounds.
Test Pattern –
Paper 1: Aptitude Assessment – 30 Questions for 30 Mins (English & Logical Reasoning– 15 Questions Each); +1 Mark for each Ans & No Negative marking
Paper 2: Written English Test – 1 Question for 25 Mins (+ 10 Marks & No Negative marking)
**Both papers are connected one after the other & mandatory to appear
Simple topics given by interviewer like moonlighting and work life balance in corporates
(5 Questions)
- Q1. What type of order will you place if the market is expected to go upward?
- Ans.
I will place a buy order if the market is expected to go upward.
I will analyze the market trends and indicators to confirm the upward trend.
I will place a limit order to buy at a specific price point.
I will monitor the market closely to ensure the order is executed at the desired price.
I will set a stop loss order to minimize potential losses if the market unexpectedly turns downward.
- Q2. What will you do if one of your team members is not performing well?
- Q3. What is your biggest failure in life?
- Q4. Where do you see yourself in next 5 years?
- Q5. Tell me about yourself
Interview Preparation Tips
Selected
I was interviewed before Sep 2023.
(2 Questions)
- Q1. What is sql queries you did
- Ans.
I have experience writing SQL queries for data retrieval, manipulation, and analysis.
Used SELECT, INSERT, UPDATE, and DELETE statements to retrieve and modify data
Utilized JOINs to combine data from multiple tables
Used WHERE clause to filter data based on specific conditions
Used GROUP BY and HAVING clauses for data aggregation and filtering
Used ORDER BY clause to sort data in ascending or descending order
- Q2. Why did you use sas
- Ans.
I used SAS for its powerful data analysis capabilities and ability to handle large datasets efficiently.
SAS is widely used in the industry for statistical analysis and data management.
It has a user-friendly interface and offers a wide range of statistical functions.
SAS can handle large datasets with ease, making it ideal for processing and analyzing big data.
The software also provides advanced reporting and visualizati...
(2 Questions)
- Q1. Difference between drop delete truncate
- Ans.
Drop, delete, and truncate are SQL commands used to remove data from a database table, but they differ in their functionality and impact.
DROP: Removes an entire table from the database along with all its data and structure.
DELETE: Removes specific rows from a table based on a condition, but keeps the table structure intact.
TRUNCATE: Removes all rows from a table, but keeps the table structure intact and resets auto-inc...
- Q2. Different types of joins questions
Skills evaluated in this interview
Associate Process Manager Interview Questions & Answers
Raghavendra Piraji Patil
posted on 13 Oct 2024
Selected
I applied via Referral and was interviewed before Oct 2023. There were 3 interview rounds.
50 Questions for Aptitude
(1 Question)
- Q1. Explain yourself in brief.
- Ans.
I am a detail-oriented professional with strong analytical skills and a passion for process improvement.
Experienced in analyzing and optimizing processes to increase efficiency
Skilled in project management and leading cross-functional teams
Strong communication skills and ability to work well under pressure
(2 Questions)
- Q1. Difference between auto transformer and Normal transformer?
- Ans.
Auto transformer has a single winding with a common portion while normal transformer has two separate windings.
Auto transformer has a single winding with a common portion for both input and output voltage
Normal transformer has two separate windings for input and output voltage
Auto transformer is smaller in size and lighter in weight compared to normal transformer
Auto transformer is less efficient and has limited isolat
- Q2. Explain Relays?
- Ans.
Relays are electrically operated switches used to control high power circuits with low power signals.
Relays consist of a coil, an armature, and contacts.
When current flows through the coil, it creates a magnetic field that moves the armature to open or close the contacts.
Relays are commonly used in automotive, industrial, and household applications.
Examples include controlling the starting motor in a car, turning on/of...
Selected
I applied via Approached by Company and was interviewed before Feb 2023. There were 2 interview rounds.
Online Aptitude test was taken
(2 Questions)
- Q1. Asked about work profile
- Q2. Asked about why I want to left previous organisation
eClerx Interview FAQs
Some of the top questions asked at the eClerx Associate Process Manager interview -
The duration of eClerx Associate Process Manager interview process can vary, but typically it takes about less than 2 weeks to complete.
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
- Process Associate Interview Questions
- Senior Process Associate Interview Questions
- Processing Executive Interview Questions
- Process Engineer Interview Questions
- Process Developer Interview Questions
- Transaction Processing Associate Interview Questions
- Non Voice Process Associate Interview Questions
- Senior Processing Executive Interview Questions
- Show more
eClerx Associate Process Manager Interview Process
based on 23 interviews
4 Interview rounds
- Resume Shortlist Round
- HR Round
- Group Discussion Round
- Personal Interview1 Round
Interview Questions from Similar Companies
Fast track your campus placements
eClerx Associate Process Manager Reviews and Ratings
based on 369 reviews
Rating in categories
|
Senior Analyst
5.5k
salaries
|  ₹2 L/yr - ₹8 L/yr |
|
Financial Analyst
4.1k
salaries
| ₹1.1 L/yr - ₹6.5 L/yr |
|
Analyst
4.1k
salaries
| ₹1 L/yr - ₹4.2 L/yr |
|
Associate Process Manager
2.7k
salaries
| ₹3.8 L/yr - ₹13 L/yr |
|
Processing Manager
1.7k
salaries
| ₹6 L/yr - ₹20 L/yr |
Genpact
WNS
TCS
Infosys
- Home >
- Interviews >
- eClerx Interview Questions >
- eClerx Associate Process Manager Interview Questions
