Ephicacy Lifescience Analytics Senior Technical Lead Interview Questions and Answers

Use SQL query to fetch maximum and minimum salary from emp table

• Use SELECT MAX(salary) FROM emp to fetch maximum salary

• Use SELECT MIN(salary) FROM emp to fetch minimum salary

Indexes and exceptions are used to optimize database performance and handle errors in code.

• Indexes are used to quickly retrieve data from a database by creating a sorted list of values.

• Exceptions are used to handle errors in code and prevent the program from crashing.

• Examples: Creating indexes on frequently queried columns like 'id' or 'timestamp'. Using try-catch blocks to handle exceptions like divide by zero.

Present c to c refers to the current customer to customer interactions within a business.

• Present c to c focuses on the direct interactions between customers in a business setting.

• It involves analyzing customer behavior, preferences, and feedback to improve customer experience.

• Examples include customer reviews, complaints, referrals, and interactions on social media platforms.

3 way matching is a process of matching three documents - purchase order, invoice and receiving report - to ensure accuracy of payment.

• Three documents - purchase order, invoice and receiving report - are matched to ensure accuracy of payment.

• The purchase order is matched with the receiving report to confirm that the goods have been received.

• The invoice is matched with the purchase order and receiving report to confirm ...read more

AP cycle is Accounts Payable cycle which involves processing of vendor invoices and making payments. P2P cycle is Procure to Pay cycle which involves procurement of goods and services and making payments.

• AP cycle includes receiving invoices, verifying them, recording them in the system, and making payments to vendors.

• P2P cycle includes identifying the need for goods or services, selecting vendors, creating purchase ord...read more

I am open to discussing a fair and competitive salary based on the responsibilities and requirements of the position.

• I am flexible and willing to negotiate based on the company's compensation structure

• I am looking for a salary that is commensurate with my experience and skills

• I am open to discussing additional benefits such as health insurance, retirement plans, and vacation time

• I have researched the industry standard ...read more

I have over 10 years of experience in project management, leading cross-functional teams to successful project completion.

• Led cross-functional teams to successfully complete projects on time and within budget

• Developed and implemented project plans, timelines, and budgets

• Managed stakeholder relationships and communicated project updates regularly

• Identified and mitigated project risks to ensure successful delivery