10+ Compunnel Interview Questions and Answers

Program to sort a linked list

• Traverse the linked list and compare adjacent nodes

• Use a temporary node to swap nodes

• Repeat until the list is sorted

The 4 pillars of OOP are encapsulation, inheritance, polymorphism, and abstraction.

• Encapsulation: Bundling data and methods that operate on the data into a single unit.

• Inheritance: Creating new classes from existing classes, inheriting their attributes and methods.

• Polymorphism: Objects of different classes can be treated as objects of a common superclass.

• Abstraction: Hiding the complex implementation details and showing only the necessary features.

Find second max salary of employee by department using pandas dataframe

• Group the dataframe by department

• Sort the salaries in descending order

• Select the second highest salary for each department

Python code to download file from aws s3 to local using boto3

• Install boto3 library using pip

• Create an S3 client using boto3

• Use the download_file method to download the file from S3 to local

A movie booking system allows users to browse movies, select showtimes, choose seats, and make payments online.

• Users can search for movies by title, genre, or location.

• Show available showtimes and theaters for selected movie.

• Select seats and view seating layout for chosen showtime.

• Provide payment options and confirm booking with email or SMS notification.

I prioritize features in the roadmap based on strategic goals, customer feedback, market trends, and resource availability.

• Align features with strategic goals of the company

• Consider customer feedback and prioritize based on impact and urgency

• Take into account market trends and competitive analysis

• Evaluate resource availability and feasibility of implementation

• Use frameworks like MoSCoW method or Kano model for prioritization

Find second max salary of employee by department in SQL

• Use GROUP BY clause to group employees by department

• Use MAX() function to find the maximum salary

• Use subquery to find the second maximum salary

I communicate changes or goals through clear and concise messaging, utilizing various channels and ensuring alignment with stakeholders.

• Utilize multiple communication channels such as emails, meetings, presentations, and project management tools

• Tailor the message to the audience to ensure understanding and buy-in

• Provide regular updates on progress towards goals and address any concerns or questions

• Seek feedback from stakeholders to ensure alignment and adjust communication st...read more

Yes, I have experience with SaS based products, APIs, and Splunk.

• I have worked with SaS based products such as Salesforce, Microsoft Azure, and Google Cloud Platform.

• I have experience in developing and integrating APIs for various applications.

• I have used Splunk for log management, monitoring, and data analysis in previous roles.

A program to count the number of words in a text file using PySpark.

• Read the text file using SparkContext

• Split the lines into words using flatMap

• Map each word to a tuple of (word, 1)

• Reduce by key to count the occurrences of each word

• Save the output to a file

I measure success by setting clear KPIs, tracking progress regularly, and analyzing data to make informed decisions.

• Set clear Key Performance Indicators (KPIs) to measure success

• Regularly track progress towards KPIs

• Analyze data to make informed decisions and adjustments

• Use tools like Google Analytics, Mixpanel, or internal dashboards for measurement

I have experience with several CSPM tools.

• I have used AWS Config to monitor and assess the configuration of AWS resources.

• I am familiar with Azure Security Center, which provides continuous monitoring and threat detection for Azure resources.

• I have worked with Google Cloud Security Command Center to gain visibility into security risks and vulnerabilities in Google Cloud Platform.

• I have also used tools like CloudCheckr and Dome9 for multi-cloud security management and complian...read more