Business Technology Development Associate

The company gave a case study which we had to read in detail. The case study had a brief about a business which need to expand. All the present data and numbers for the company were given. ideal future prospect was also given. The case study had three series of problems to be solved, mainly through analytical mathematical means. The solution involved creating a business presentation and addressing all the given three problems. 

i. First problem was focusing on the distribution network of the company and current production. An analytical approach was to be given how to target the markets for growth. Few factors like avg age, purchasing power etc of regions were provided.

ii. Second problem focused on the Methamatical aspect. This involved how much the company can grow YOY. The data for the past performance, new product pricing and tagret consumer base was given. Approximate estimation of the future revenue were to be provided with suitable assumptions.

iii. Third questions involved an assumption like the company was going through a cash crunch. Provided was the data on the different products the company offered in different markets with the total revenue it created for the company. An anayltical decision was to made with critical thinking about the companies decison to whether venture into new markets or sustain the existing business. The exact logic behind the decison made to be provided. This could be different for doferent thouught of approach. This was to test the broader vision of the candidates and the creativity they offered on the table

The selection process involved two distinct stages designed to assess a range of skills in the candidates.

The first stage comprised General Aptitude and Mathematics multiple-choice questions (MCQs). This section tested the candidates' quantitative abilities, logical reasoning, and overall intellectual capacity. The questions ranged from basic arithmetic and algebra to more complex problems involving geometry and data interpretation. This stage aimed to filter candidates based on their analytical and problem-solving skills, which are crucial for success in any business environment.

The second stage required candidates to submit a live video recording. Each candidate had to speak continuously for two minutes on the topic "Technology in Business." This video submission was a critical component of the selection process, as it assessed the candidates' communication skills, clarity of thought, and ability to articulate ideas coherently under pressure. There were no breaks allowed during the recording, adding an element of spontaneity and ensuring that the candidates could think on their feet.

Third round was specific to the Business Technology Development role. This involed broadly SQL based and DBMS related questions both practical and theoratical.

i. Theoratical: Data redundancy and inconsistency, Data isolation – multiple files and formats , Concurrent access by multiple users and What are the different types of joins in SQL?

ii. Practical: Given was Tables for 3 DataSets a company had. The aim was to transform the data into a specific format the company wanted. Basically the idea was to make sense out of 3 related DataSets. Problem Statment:

Context:
A company has three datasets containing information about their employees, departments, and projects. The goal is to transform these datasets into a specific format that provides meaningful insights for the company’s HR and project management operations.

Given Tables:

Employees Table:

EmployeeID (Primary Key), FirstName, DepartmentID, Position, Salary, HireDate


Departments Table:

DepartmentID (Primary Key), DepartmentName, ManagerID (Foreign Key referencing EmployeeID)


Projects Table:

ProjectID (Primary Key), ProjectName, StartDate, EndDate, DepartmentID (Foreign Key referencing DepartmentID), EmployeeID (Foreign Key referencing EmployeeID)


Task:
Create a New Table for Active Projects:

The company wants a list of all active projects (those which are currently ongoing) along with the details of the employees working on these projects.

1. Create a View for Department-wise Salary Expenditure:

2. Create a view that shows the total salary expenditure for each department.

3. Generate a report that lists each project along with the name of the manager of the department overseeing the project.

Ensure that any updates or deletions in the Employees table cascade appropriately to the related Departments and Projects tables.
Enforce that Salary in the Employees table should be a positive number.

This involved the behaviourial round and the interview experience. What could have been better in the process. Any questions regarding company and compensations/ perks discussion.