Intellicus Technologies interview experience Real time questions & tips from candidates to crack your interview
Data Engineer
Intellicus Technologies
2 rounds | 2 Coding
problems
Rejected
Interview preparation journey
Journey
Focused on building strong foundations in SQL, data modeling, and pipelines, revised DSA, and practiced tools like Spark and Airflow. Gave multiple mock interviews to refine problem-solving, communication, and boost confidence.
Preparation
Topics: Excel, Power Bi, SQL
Application process
Where: Coding Ninjas Placement Cell
Eligibility: Any Graduate
Interview rounds
01
Round
Medium
Online Coding Interview
Duration
Interview date17 Jul 2025
Coding problem1
1. SQL Problem-Solving in Data Engineer Interview
In the interview, I was given SQL-based problem scenarios to test query writing, joins, CTEs, aggregate functions, and handling NULL values. Tasks included creating an employee table, inserting data, finding the highest-paid employee in each department, identifying customers with/without orders, fetching the latest order per customer, and applying HAVING with NULL conditions. The objective was to evaluate my ability to translate business requirements into optimized SQL queries with accurate results.
Problem approach
To solve the given problems, I showcased SQL proficiency across multiple scenarios. I began by creating an Employee table with relevant attributes and wrote queries to:
- Fetch the first contact for every order.
- Identify the department with the maximum salary.
- Retrieve customers with at least one order or none using LEFT JOIN and CTE.
- Determine the latest order per customer by applying the ROW_NUMBER() window function, partitioned by customer and ordered by date.
I also demonstrated best practices by clarifying that:
- The HAVING clause should reference aggregate functions (e.g., HAVING MAX(salary) > 10000) instead of non-aggregated columns.
- NULL values must be checked using IS NULL rather than = NULL.
These solutions highlighted not only my SQL query-writing ability but also my understanding of optimization, correctness, and relational data handling best practices.
02
Round
Easy
Online Coding Interview
Duration
Interview date21 Jul 2025
Coding problem1
1. Database Relationships and SQL Operations
- Conceptual and practical questions on database relationships, including one-to-one, one-to-many, many-to-one, many-to-many, and self-joins, with examples using real table structures.
- How these relationships can be implemented and combined using SQL joins.
- To define DBMS and RDBMS, and explain what “relational” means in databases.
- To list the different types of DBMS.
- To explain the concepts of primary keys and foreign keys.
- To differentiate between UNION and UNION ALL operators in SQL with examples, highlighting their impact on duplicates, performance, and result sets.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
SDE - 1
4 rounds | 8 problems
Interviewed by Amazon
Selected 
8518 views
0 comments
0 upvotes
Analytics Consultant
3 rounds | 10 problems
Interviewed by ZS
Selected 907 views
0 comments
0 upvotes
SDE - Intern
1 rounds | 3 problems
Interviewed by Amazon
Selected 3320 views
0 comments
0 upvotes
SDE - 2
4 rounds | 6 problems
Interviewed by Expedia Group
Selected 2581 views
0 comments
0 upvotes
Companies with similar interview experiences
Data Engineer
2 rounds | 4 problems
Interviewed by Amazon
Rejected
1838 views
0 comments
0 upvotes
Data Engineer
4 rounds | 15 problems
Interviewed by Intuit
Selected 0 views
0 comments
0 upvotes