Merilytics Senior Technical Associate Interview Questions and Answers

Q1. Typical questions about your experience, technical background and working knowledge relevant to their technical stack.
Add your answer
Q2. Tell me about your experience in network security.
Add your answer
Q3. Tell me about your experience in Java and Springboot.
Add your answer

Q1. Basic c#and MVC architecture, partial view, singleton class
Add your answer
Q2. Index ,view, optimisation techniques in database
Ans. 
Indexing, viewing, and optimization techniques are essential for improving database performance.
• Use indexes to quickly retrieve data from tables

• Regularly analyze and optimize queries for better performance

• Utilize views to simplify complex queries and improve readability

• Consider partitioning tables for better manageability and performance

• Use tools like explain plans to analyze query performance
Answered by AI
Add your answer

Q1. Difference in MVC and ado.net, filters in MVC, resultset in mvc
Ans. 
MVC is a design pattern for organizing code in web applications, while ADO.NET is a data access technology for connecting to databases.
• MVC stands for Model-View-Controller and helps in separating concerns in web applications.

• ADO.NET is a data access technology in .NET framework for connecting to databases.

• Filters in MVC are used to add pre-processing or post-processing logic to controller actions.

• Resultset in MVC refer...read more
Answered by AI
Add your answer
Q2. Rank functions in SQL server
Ans. 
Functions in SQL server can be ranked based on their usage, complexity, and performance.
• Rank functions based on usage - COUNT, SUM, AVG, MAX, MIN

• Rank functions based on complexity - CASE, COALESCE, ISNULL

• Rank functions based on performance - ROW_NUMBER, RANK, DENSE_RANK
Answered by AI
Add your answer

Report covering market trends, driver, SWOT and market share analysis

Hurdles in delivering client report

Guesstimate Assignment

Guesstimate GD round

Q1. What is forecasting
Add your answer
Q2. What is market sizing
Add your answer

Basics of market estimations

Q1. Basics on market research
Add your answer

Q1. What are the important financials , case study based questions over cash flow
Add your answer
Q2. What is Free Cash flow , NPV vs IRR , solvency ratios , different between depreciation and depletion,
Ans. 
Free cash flow, NPV vs IRR, solvency ratios, depreciation vs depletion
• Free cash flow is the amount of cash a company generates after accounting for all expenses and investments in capital assets.

• NPV (Net Present Value) and IRR (Internal Rate of Return) are both used in capital budgeting to evaluate the profitability of an investment.

• Solvency ratios measure a company's ability to meet its long-term debt obligations.

• Depr...read more
Answered by AI
Add your answer

Q1. Tell me something about yourself
Ans. 
I am a dedicated and experienced professional with a strong background in project management and team leadership.
• Over 8 years of experience in project management

• Proven track record of successfully leading cross-functional teams

• Strong communication and interpersonal skills

• Certified in project management (PMP)

• Passionate about continuous learning and professional development
Answered by AI
Add your answer
Q2. Why you want to join Icra Analytics
Ans. 
I want to join Icra Analytics because of its reputation for innovative solutions and strong team collaboration.
• I am impressed by Icra Analytics' track record of delivering cutting-edge analytics solutions to clients.

• I am excited about the opportunity to work with a talented team of professionals who are passionate about data analytics.

• I believe that Icra Analytics' focus on innovation and collaboration aligns with my o
Answered by AI
Add your answer