Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Merilytics Team. If you also belong to the team, you can get access from here

Merilytics Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Merilytics Senior Technical Associate Interview Questions and Answers

Updated 16 May 2024

Merilytics Senior Technical Associate Interview Experiences

3 interviews found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Oct 2023.

Round 1 - Aptitude Test 

Some basic aptitude , data analysis

Round 2 - Technical 

(2 Questions)

  • Q1. Some basic data structures and algorithms
  • Q2. Discussion on projects and internship
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Coding Test 

CS Fundamentals and Aptitude

Round 2 - One-on-one 

(1 Question)

  • Q1. Resume and SQL based questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Resume and basic logic-based programming questions, aptitude questions, and behavioural questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL well and be through with your Resume.

Senior Technical Associate Interview Questions Asked at Other Companies

asked in Genpact
Q1. What about DNS, query, zones, records, stub zone, PTR, Point reco ... read more
asked in Genpact
Q2. Active Directory, How to migrate AD from legacy server to new ser ... read more
asked in Genpact
Q3. How to upgrade windows from user end, what about antivirus, encry ... read more
Q4. Puzzle: Measure 4ltr exactly with with a 3ltr and 5ltr bucket.
Q5. Convert the number given in the word to a numeral ex: if three mi ... read more

I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 
Round 3 - Technical 

(1 Question)

  • Q1. SQL Basics, Joins, Window functions, CTEs and temp tables Excel- basic functions like IF, Pivot
Round 4 - Case Study 

Profit and loss scenario based case study

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn basics of SQL and Excel.

Interview questions from similar companies

I applied via Campus Placement and was interviewed in Jun 2021. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself
  • Q2. Hiw arhi hkh

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and answer all yhe hjksoi hhjjd hhjjj
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. What are the important financials , case study based questions over cash flow
  • 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...

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • 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
  • 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
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - There was no formal technical assesment but the technical architect will ask about experience, logic based and system based questions.

I applied via Naukri.com and was interviewed in Dec 2020. There were 6 interview rounds.

Interview Questionnaire 

5 Questions

  • Q1. Explain Structured Finance?
  • Ans. 

    Structured finance refers to complex financial instruments that are created by pooling together various financial assets.

    • Structured finance involves the creation of securities that are backed by a pool of assets such as mortgages, loans, or bonds.

    • These securities are then sold to investors who receive payments based on the cash flows generated by the underlying assets.

    • Structured finance can be used to manage risk, rais...

  • Answered by AI
  • Q2. Why I left my previous organisation?
  • Q3. What incites me to take this particular job opportunity
  • Q4. What do I understand about the job profile for which I am being interviewed
  • Q5. Tell a scenario where you went wrong and you could do things differently

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident! And try to go through the job profile and company’s profile and how does it generates revenue. Always search for your interviewer on linkedin before the interview
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Basic c#and MVC architecture, partial view, singleton class
  • 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
Round 2 - Technical 

(2 Questions)

  • 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...

  • Answered by AI
  • 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

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - Case Study 

Basics of market estimations

Round 2 - One-on-one 

(1 Question)

  • Q1. Basics on market research
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Oct 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Assignment 

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

Round 3 - Case Study 

Hurdles in delivering client report

Merilytics Interview FAQs

How many rounds are there in Merilytics Senior Technical Associate interview?
Merilytics interview process usually has 3 rounds. The most common rounds in the Merilytics interview process are Aptitude Test, Technical and One-on-one Round.
How to prepare for Merilytics Senior Technical Associate 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 Merilytics. The most common topics and skills that interviewers at Merilytics expect are Azure, Business Intelligence, Data Analytics, Data Modeling and Data Warehousing.
What are the top questions asked in Merilytics Senior Technical Associate interview?

Some of the top questions asked at the Merilytics Senior Technical Associate interview -

  1. SQL Basics, Joins, Window functions, CTEs and temp tables Excel- basic function...read more
  2. Resume and basic logic-based programming questions, aptitude questions, and beh...read more
  3. some basic data structures and algorit...read more

Tell us how to improve this page.

Merilytics Senior Technical Associate Interview Process

based on 2 interviews

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 233 Interviews
Sigmoid Interview Questions
3.3
 • 59 Interviews
ICRA Analytics Interview Questions
3.4
 • 39 Interviews
Dunnhumby Interview Questions
4.0
 • 29 Interviews
Everest Group Interview Questions
3.3
 • 25 Interviews
Coronis Health Interview Questions
3.7
 • 24 Interviews
View all
Merilytics Senior Technical Associate Salary
based on 76 salaries
₹5 L/yr - ₹10.4 L/yr
At par with the average Senior Technical Associate Salary in India
View more details

Merilytics Senior Technical Associate Reviews and Ratings

based on 6 reviews

3.7/5

Rating in categories

4.1

Skill development

3.1

Work-life balance

3.4

Salary

3.7

Job security

3.4

Company culture

3.8

Promotions

3.2

Work satisfaction

Explore 6 Reviews and Ratings
Senior Business Analyst
156 salaries
unlock blur

₹6.6 L/yr - ₹11 L/yr

Business Associate
130 salaries
unlock blur

₹8.1 L/yr - ₹15 L/yr

Business Analyst
87 salaries
unlock blur

₹5 L/yr - ₹10 L/yr

Senior Technical Associate
76 salaries
unlock blur

₹5 L/yr - ₹10.4 L/yr

Senior Analyst
68 salaries
unlock blur

₹3.6 L/yr - ₹14 L/yr

Explore more salaries
Compare Merilytics with

Indegene

3.4
Compare

Markets and Markets

3.2
Compare

LogixHealth

3.5
Compare

Coronis Health

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview