Eclerx Most asked Q+A for Program Manager role with Full details of Interview Rounds #work

How many rounds are there in eClerx Associate Process Manager interview? eClerx interview process usually has 2-3 rounds. The most common rounds in the eClerx interview process are One-on-one Round, Technical and HR. Round 1 - Resume Shortlist Round 2 - Aptitude Test 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 Round 3 - Group Discussion Simple topics given by interviewer like moonlighting and work life balance in corporates Round 4 - ONE on ONE (HR) How to prepare for eClerx Associate Process Manager interview? Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at eClerx. The most common topics and skills that interviewers at eClerx expect are Process Management, Business Process Management, KYC, Finance and SQL/Javascript. eClerx - Associate Process Manager - Most asked Q & A : 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 dates. Q2. Difference between future and forwards Ans. Futures and forwards are both types of financial contracts, but futures are standardised and traded on exchanges while forwards are customised and traded over-the-counter. Futures are standardised contracts traded on exchanges, while forwards are customised contracts traded over-the-counter. Futures have daily settlement, while forwards settle at the end of the contract period. Q3. What corporate Action? Ans. Corporate actions are events initiated by a company that affect its securities and shareholders, impacting stock value and ownership. Types of corporate actions include stock splits, dividends, mergers, and acquisitions. Q4. What are Interest Rate Swaps? Ans. 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. Q5. 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. Q6. How do you 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 Q7. How do you optimize a 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 Q8. What is the difference between DROP, DELETE, and 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-increment values. Q9. What SQL queries have you written? 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. Q10. 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. Connect Me at : https://topmate.io/himani_tank