DevOps Consultant Interview Questions and Answers: Insights from Experience Recently, Someone had the opportunity to interview for a DevOps Consultant role. The session lasted 45 minutes and covered various aspects of my 3-year experience, tools, technologies, and best practices. Here’s how I tackled the questions: 1. Walk me through your profile? I highlighted my journey from the basics of DevOps to working on advanced tools and technologies. I emphasized: My hands-on experience with CI/CD pipelines. Proficiency in tools like Jenkins, Docker, Kubernetes, Terraform, Ansible, and Prometheus. Key projects, challenges faced, and my contributions to optimizing DevOps processes. 2. What are the tools and technologies you have worked on? I listed the tools with context: CI/CD : Jenkins, GitHub Actions. Containerization : Docker, Kubernetes, Helm. Infrastructure as Code (IaC) : Terraform, CloudFormation. Monitoring : Prometheus, Grafana, Loki. Security : SonarQube, Trivy for image...
EXL Interview Experience for Power BI Developer (3 Years of Experience) I recently appeared for an interview at EXL for the role of Power BI Developer . The selection process consisted of three rounds: 2 Technical Rounds 1 Managerial Round Here, I’ll share the key technical questions I encountered, along with my approach to answering them. SQL Questions 1️⃣ Write a SQL query to find the second most recent order date for each customer from a table Orders ( OrderID , CustomerID , OrderDate ). To solve this, I used the ROW_NUMBER() window function: sql WITH RankedOrders AS ( SELECT CustomerID, OrderDate, ROW_NUMBER () OVER ( PARTITION BY CustomerID ORDER BY OrderDate DESC ) AS RowNum FROM Orders ) SELECT CustomerID, OrderDate AS SecondMostRecentOrderDate FROM RankedOrders WHERE RowNum = 2 ; 2️⃣ Write a query to find the nth highest salary from a table Employees with columns ( EmployeeID , Name , Salary ). The DENSE_RANK() fu...