i
eClerx
Filter interviews by
Clear (1)
I applied via Campus Placement and was interviewed before Oct 2021. There were 3 interview rounds.
Just be confident for GD and learn about derivatives & finance. With this you are good to go. Best of luck
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 positions on the price movements of assets without owning the assets themselves.
They can be traded on exchanges or over-the-counter (OTC) market
Interest rate swaps are financial derivatives where two parties exchange interest rate cash flows, often to manage interest rate risk.
Interest rate swaps involve two parties exchanging interest rate payments based on a notional principal amount.
One party pays a fixed interest rate while the other pays a floating interest rate, typically based on a benchmark rate like LIBOR.
The purpose of interest rate swaps is to hedge...
I applied via Recruitment Consultant and was interviewed in Dec 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed in Sep 2021. There were 5 interview rounds.
What people are saying about eClerx
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
eClerx interview questions for designations
I applied via Naukri.com and was interviewed in Apr 2021. There were 5 interview rounds.
Get interview-ready with Top eClerx Interview Questions
I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.
I applied via Recruitment Consulltant and was interviewed before Sep 2021. There were 2 interview rounds.
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
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
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
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
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
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
I applied via Campus Placement and was interviewed in May 2020. There were 5 interview rounds.
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.
based on 24 interviews
4 Interview rounds
based on 372 reviews
Rating in categories
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