DGliger Consultancy- Data Analytics Interview Experience

Position/Role

• Experience: Data Analyst

Where Applied

• Company: DGliger Consultancy
• Application Method: Direct application through DGliger Consultancy’s careers portal

Total Rounds

1. Screening Round
2. SQL Technical Round
3. Case Study & Projects Round
4. Final HR Round

Every Round Experience

1. Screening Round

• Format: Initial HR Interview
• Questions:
  • General questions about background and experience
  • Discussion about the role and the candidate’s fit

2. SQL Technical Round

• Format: Technical Skills Assessment
• Questions:
  • SQL Basics and Query Writing:
    • Example: Write a query to find the second highest salary from an Employee table.
  • Joins and Subqueries:
    • Example: Explain the difference between INNER JOIN and OUTER JOIN with examples.
  • Data Manipulation:
    • Example: How do you update records in a table based on conditions?

3. Case Study & Projects Round

• Format: Case Study and Project Discussion
• Questions:
  • Case Study:
    • Presented with a business problem and asked to analyze data to provide solutions.
    • Example: Analyze sales data to identify trends and suggest improvements.
  • Project Discussion:
    • Detailed discussion on past projects.
    • Example: Describe a project where you used data analysis to drive business decisions.

4. Final HR Round

• Format: HR Interview
• Questions:
  • Behavioral Questions:
    • Example: Describe a challenging situation and how you overcame it.
  • Role-Specific Questions:
    • Example: Why do you want to join DGliger Consultancy?

Final Outcome

• Result: Selected