Ocrolus East Data Verifier Interview Questions and Answers for Freshers

Q1. Justification of what is written in the resume
Add your answer
Q2. Questions on case study to monitor your ability
Add your answer

Case study which need to plan GTM strategy for an existing product

Q1. What is your job role
Ans. 
I am responsible for assisting in various tasks and projects within the company.
• Supporting team members in daily operations

• Completing assigned tasks in a timely manner

• Assisting in research and analysis

• Participating in meetings and discussions
Answered by AI
Add your answer
Q2. What is the ctc
Ans. 
CTC stands for Cost to Company, which includes all expenses related to an employee's compensation.
• CTC includes salary, bonuses, benefits, and any other perks provided by the company

• It is the total amount of money a company spends on an employee in a year

• CTC is often used to negotiate job offers and understand the full value of a compensation package
Answered by AI
Add your answer

Basic python, sql and pandas questions

Q1. Case study (Probability questions)
Add your answer
Q2. Resume projects
Add your answer

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

Q1. In a marketing campaign, how would you decide which metrics to track?
Ans. 
Metrics selection based on campaign objectives, target audience, and key performance indicators.
• Identify campaign objectives and goals

• Consider target audience and their behavior

• Select key performance indicators (KPIs) relevant to the campaign

• Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

• Analyze data to measure success and make data-driven decisions
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round

Q1. Basic SQL questions are asked in this round Some theory questions are asked as well
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. Case Study of zomato ?
Add your answer
Q2. Some basic math questions. Simultaneous equations .
Add your answer

Technical SQL Coding Round of 1 hour

Began with 2 easy generic question -
1. No. of record on different types of joins.
2. Employees who have higher salaries than their managers,

Then moved to medium questions -
1. Implement Rolling sum with & without window functions.
2. Other questions were on CTEs, Joins & other complex queries.

Bar Raiser Round of 1 hour involving -

1. Case study: How can we leverage product knowledge & analytics to increase Amazon Prime Revenue from 10% to 12%?

2. Metrics awareness: Common metrics discussion like DAU, PDAU, MAU, Retention, Churn, etc.

3. Resume based work exp discussion

Q1. Quick culture fitment round with HR discussing about past work experience, my expectations & why I want to join Jupiter.
Add your answer