Filter interviews by
I applied via Referral and was interviewed in Sep 2022. There were 4 interview rounds.
Business problem statement and window function in SQL
A business problem statement defines the problem that needs to be solved
Window functions in SQL allow for calculations to be performed on a specific subset of data
They are useful for calculating running totals, moving averages, and ranking data
Examples of window functions include ROW_NUMBER(), RANK(), and LAG()
The problem statement defines the issue that needs to be addressed and solved.
The problem statement should be clear and concise.
It should identify the root cause of the problem.
It should explain the impact of the problem on the organization or individuals involved.
It should provide a framework for finding a solution.
For example, a problem statement could be: 'The company's website is not generating enough traffic, resu...
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
Data analyst case study
I applied via LinkedIn and was interviewed in Sep 2024. There were 4 interview rounds.
I have worked on a variety of technologies including Java, Python, SQL, and AWS.
Java
Python
SQL
AWS
Case study ppt and related questions
Qral Company is a leader in innovative solutions and has a strong reputation for delivering results.
Qral Company has a proven track record of successful projects in the industry.
The company values collaboration and teamwork, which aligns with my own work style.
Qral Company offers opportunities for professional growth and development.
I admire the company's commitment to sustainability and social responsibility.
I applied via Handshake and was interviewed in Apr 2024. There were 2 interview rounds.
General behavioral questions
Top trending discussions
Yes, I have worked on RFPs in my previous roles.
I have experience in responding to RFPs from clients.
I have worked on creating proposals and presentations for RFPs.
I have collaborated with cross-functional teams to gather information and create RFP responses.
I have also reviewed and evaluated RFPs from potential vendors.
For example, in my previous role at XYZ Company, I was responsible for leading the RFP response proc...
I applied via Company Website and was interviewed in Jul 2020. There were 3 interview rounds.
CI/CD pipeline is a process of continuous integration and continuous delivery/deployment of software.
CI/CD pipeline automates the software delivery process
It helps in detecting and fixing bugs early in the development cycle
It ensures that the software is always in a releasable state
It reduces the time between writing code and deploying it to production
Examples of CI/CD tools include Jenkins, Travis CI, and CircleCI
Jenkinsfile is a text file that defines the entire build process for a Jenkins pipeline.
Jenkinsfile is written in Groovy syntax
It can be stored in a version control system like Git
It allows for defining stages, steps, and conditions for a pipeline
Jenkinsfile can be executed on any Jenkins instance
Example: pipeline { agent { docker 'maven:3-alpine' } stages { stage('Build') { steps { sh 'mvn -B -DskipTests clean package...
To connect a machine in a private subnet, use a bastion host or VPN.
Set up a bastion host in the public subnet to act as a gateway.
Use SSH tunneling or RDP to connect to the bastion host.
From the bastion host, connect to the machine in the private subnet.
Alternatively, set up a VPN to securely connect to the private subnet.
Configure the security group and network ACLs to allow the necessary traffic.
Ansible playbooks can be verified/validated using various tools and techniques.
Use Ansible's built-in syntax checker 'ansible-playbook --syntax-check'
Use Ansible's 'ansible-lint' tool to check for best practices and potential issues
Use 'ansible-playbook --check' to simulate playbook execution without making changes
Use 'ansible-playbook --diff' to show the differences between the current and desired state
Use 'ansible-pl...
Inventory is a list of hosts where Ansible runs tasks. Roles are reusable collections of tasks, files, and templates. Variables are used to store data.
Inventory is a file or directory containing a list of hosts or groups of hosts
Roles are used to organize tasks, files, and templates into reusable collections
Variables are used to store data that can be used across multiple tasks and roles
Example: inventory file can cont...
Adding a user in Jenkins
Go to Jenkins dashboard and click on 'Manage Jenkins'
Click on 'Manage Users' and then 'Create User'
Fill in the user details and click 'Create User'
Assign the necessary permissions to the user
Maven is a build automation tool used for Java projects. Install is for local repository, deploy is for remote repository.
Maven is used to manage dependencies and build Java projects
Install command installs the project's artifact (jar, war, etc.) to the local repository
Deploy command uploads the artifact to a remote repository
Install is used during development, deploy is used for distribution
Example: 'mvn install' inst...
I applied via Campus Placement and was interviewed before Oct 2021. There were 4 interview rounds.
If you were to consult an automobile firm to upgrade their in-vehicle, what changes would you suggest? Note that the firm primarily manufactures lowe end cars
Ice cream cart owner wants to increase profitability with an increase in the price of milk. How would you suggest that the owner maintain/ increase his profitability
I applied via LinkedIn and was interviewed in Mar 2021. There was 1 interview round.
I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.
Standard Coding questing
based on 4 interview experiences
Difficulty level
Duration
based on 11 reviews
Rating in categories
Management Consultant
55
salaries
| ₹22 L/yr - ₹39 L/yr |
Consultant
5
salaries
| ₹14 L/yr - ₹26.5 L/yr |
TCS
Accenture
Wipro
Cognizant