i
eClerx
Filter interviews by
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 Company Website and was interviewed in Nov 2024. There was 1 interview round.
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...
I applied via campus placement at Pune Institute of Business Management, Pune and was interviewed in Dec 2023. There were 2 interview rounds.
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
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
What people are saying about eClerx
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
eClerx interview questions for designations
Get interview-ready with Top eClerx Interview Questions
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
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.
I was interviewed before Sep 2023.
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
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...
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...
posted on 13 Oct 2024
I applied via Referral and was interviewed before Oct 2023. There were 3 interview rounds.
50 Questions for Aptitude
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
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
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...
I applied via Approached by Company and was interviewed before Feb 2023. There were 2 interview rounds.
Online Aptitude test was taken
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 23 interviews
4 Interview rounds
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