Data Analyst

What is a generator?

How to compare the model's answer with the ground truth in a benchmark? What metric to use?

Intern

Яндекс

Do you have experience conducting A/B tests or self-studying this topic?

Where would you start on this position, what challenges would you face, what goals would you set, who would you meet first?

Did I understand correctly that there were no opportunities for horizontal or vertical growth in this department?

-- 1.2 How will the answer change if you switch the JOIN type to LEFT? -- 1.3 Specify the order of execution of the operators in this query. from join group by select order by limit -- 2. The campaigns table has been fixed: duplicates removed, primary key added. -- More campaigns were conducted, and due to bugs, users started receiving failed communication delivery attempts, and some couldn't see it at all. -- For the promotional campaigns sent to users: -- 2.1 Write a query that outputs the number of users who successfully received communication for each campaign. -- 2.2 Modify the query to output: the number of users who ultimately did not receive any successful communication, for each campaign?

Intern

Яндекс

Have you had experience working with Data Vault?

Imagine you are riding in an elevator for a minute with the CEO, who needs to sell himself in terms of expertise and hard skills. What would you say about yourself?

What happens to the table itself when executing the TRUNCATE command?

Tell us about your preferences regarding the work format (remote/office) and where you are geographically located.

Псевдокод sum_series(a={{1, 2}, {5, 1}}, b={{2, 4}, {3, 6}, {9, 7}}) -> {{1, 2}, {2, 6}, {3, 8}, {5, 7}, {9, 8}} def sum_series(a, b): result = [] i , j = 0, 0 val_a, val_b = 0, 0 while i < len(a) or j < len(b): a_next = a[i][0] if i < len(a) else float('inf') b_next = b[j][0] if j < len(b) else float('inf') if a_next <= b_next: val_a = a[i][1] t = a[i][0] i += 1 else: val_b = b[j][1] t = b[j][0] j += 1 result.append((t, val_a + val_b)) return result

Intern

Яндекс

func (r *OrderRepository) GetActiveOrderIDs(ctx context.Context, offset, limit int) ([]uint32, error) { var ( res []uint32 args []interface{} ) query := `SELECT id FROM "order" WHERE is_terminated = false LIMIT $1 OFFSET $2;` args = append(args, limit, offset) rows, err := r.slave.Query(ctx, query, args...) if err != nil { return nil, err } for rows.Next() { var orderID uint32 if err = rows.Scan(&orderID); err != nil { return nil, err } res = append(res, orderID) } return res, nil }

Principal

101ХР

Please tell us, using your work tasks as an example, how you apply the ETL process in your work.

Can the Product of Array Except Self problem be solved more simply if any operations are allowed?

Intern

Яндекс

Tell me a little about yourself, your career path, and the reasons for changing jobs, what are you looking for?

How did you handle seasonality and external influences in time series?

Intern

Т-Банк

Product case: you are a product analyst in car sharing. How do you evaluate the business and what is needed for growth? What metrics should be monitored?

Intern

СБЕР Звук

How to implement a knowledge base for LLM if the data volume exceeds the context window? What is a context window?

Are you currently actively or passively looking for a job? What is unsatisfactory at your current job?

What do you pay attention to when choosing a new workplace? What is important to you, including working conditions?