Skip to content

Submit Resume

Please check your inbox for a confirmation email containing a link to set your password. Don't forget to also peek into your spam folder, just in case
You wont be contacted by company if it does not matches your criteria
You wont be contacted by company if it does not matches your criteria
Here are some prompts to craft your unique pitch:
* Introduction: Share your professional journey - years of experience and your core skills.
* Unique Value: What's your standout quality that makes you exceptional?
* Experience Highlight: Spotlight on a significant project or experience that showcases your expertise.
* Future Aspirations: Describe your ideal role or what you're seeking in your next career move.
Craft your narrative, make it engaging, and let your brilliance shine! 
  •             Explain the key differences between Snowflake and traditional data warehousing solutions.
        
  •             Explain Snowflake Time travel feauture
        
  •             Discuss your experience in implementing Snowflake's data sharing feature and its significance in a multi-tenant environment.
        
  • 

    Write a solution to calculate the number of unique subjects each teacher teaches in the university.
    


    Example 1:
    


    Input: 
Teacher table:
+------------+------------+---------+
| teacher_id | subject_id | dept_id |
+------------+------------+---------+
| 1          | 2          | 3       |
| 1          | 2          | 4       |
| 1          | 3          | 3       |
| 2          | 1          | 1       |
| 2          | 2          | 1       |
| 2          | 3          | 1       |
| 2          | 4          | 1       |
+------------+------------+---------+
Output:  
+------------+-----+
| teacher_id | cnt |
+------------+-----+
| 1          | 2   |
| 2          | 4   |
+------------+-----+
Explanation: 
Teacher 1:
  - They teach subject 2 in departments 3 and 4.
  - They teach subject 3 in department 3.
Teacher 2:
  - They teach subject 1 in department 1.
  - They teach subject 2 in department 1.
  - They teach subject 3 in department 1.
  - They teach subject 4 in department 1.

    

    

  • Write a solution to report the name and bonus amount of each employee with a bonus less than 1000.
    

    Example 1:
    

    Input: 
Employee table:
+-------+--------+
| empId | name   |
+-------+--------+
| 3     | Brad   |
| 1     | John   |
| 2     | Dan    |
| 4     | Thomas |
+-------+--------+
Bonus table:
+-------+-------+
| empId | bonus |
+-------+-------+
| 2     | 500   |
| 4     | 2000  |
+-------+-------+
Output: 
+------+-------+
| name | bonus |
+------+-------+
| Brad | null  |
| John | null  |
| Dan  | 500   |
+------+-------+

    cNote Brad and John did not have bonus

  • Write a solution to report the movies with an odd-numbered ID and a description that is not "boring".

    Input: 
Cinema table:
+----+------------+-------------+
| id | movie      | description |
+----+------------+-------------+
| 1  | War        | great 3D    |
| 2  | Science    | fiction     |
| 3  | irish      | boring      |
| 4  | Ice song   | Fantacy     |
| 5  | House card | Interesting |
+----+------------+-------------+
Output: 
+----+------------+-------------+
| id | movie      | description |
+----+------------+-------------+
| 5  | House card | Interesting |
| 1  | War        | great 3D    |
+----+------------+-------------+
Explanation: 
We have three movies with odd-numbered IDs: 1, 3, and 5. The movie with ID = 3 is boring so we do not include it in the answer.


  • Find EmpID for third Highest salary
    
+-------+-------+
| empId | salary|
+-------+-------+
| 1     | 500   |
| 2     | 2000  |
| 3     | 3000  |
| 4     | 2000  |
+-------+-------+

     output 
    
+-------+-------+
| empId | salary|
+-------+-------+
| 4     | 2000  |
+-------+-------+

  • Delete dulplicate rows from table

    +-------+-------+
| empId | salary|
+-------+-------+
| 1     | 500   |
| 1     | 500   |
| 2     | 3000  |
| 3     | 2000  |
+-------+-------+

    output
    
+-------+-------+
| empId | salary|
+-------+-------+
| 1     | 500   |
| 2     | 3000  |
| 3     | 2000  |
+-------+-------+

  • find rows that contain only numerical data

    +-------+-------+
| empId | val   |
+-------+-------+
| 1     | 500   |
| 2     | abc   |
| 3     | 2A    |
| 4     | 2000  |
+-------+-------+

    output
    
+-------+-------+
| empId | val   |
+-------+-------+
| 1     | 500   |
| 4     | 2000  |
+-------+-------+

  • Department with Highest Number of Employees

    +-------+--------+----+
| empId | Dept_name   |
+-------+--------+----+
| 1     | IT          |
| 2     | IT   	      |
| 3     | HR          | 
| 4     | Finance     | 
+-------+--------+----+

    output
    
+-------+---+
| Dept_name |
+-------+---+
| IT        |
+-----------+

  • Difference between Inner and Left Join


  • Find next Hire date

    Employee table:
+-------+--------+---+
| empId | Hire_Date  |
+-------+--------+---+
| 1     | 1/1/2023   |
| 2     | 2/1/2023   |
| 3     | 3/1/2023   |
| 4     | 4/1/2023   |
+-------+--------+---+

Output: 
+-------+--------+---------------------+
| empId | Hire_Date  | Next_Hire_Date  |
+-------+--------+---------------------+
| 1     | 1/1/2023   |        2/1/2023 |
| 2     | 2/1/2023   |        3/1/2023 |
| 3     | 3/1/2023   |        4/1/2023 |
| 4     | 4/1/2023   |        Null     |
+-------+--------+---------------------+

  •             Discuss a challenging data analysis project you've worked on and how you approached it.
        
  •             Explain the process of creating interactive dashboards in Tableau and how they add value to data analysis.
        
  •             Discuss your experience in optimizing Tableau visualizations for performance and efficiency.
        
  •             Explain the steps you take to ensure data accuracy and reliability when working with Tableau.
        
  •             Describe a complex data visualization project you've undertaken using Tableau and the challenges you faced.
        
  •             Discuss the benefits of Tableau extracts and the scenarios where they are useful.
        
  •             Given an array arr[] of n elements, write a function to search a given element x in arr[]
            Input : arr[] = {10, 20, 80, 30, 60, 50, 110, 100, 130, 170}
                    x = 110;
            Output : 6
            Element x is present at index 6
        
  •             Convert key-values list to flat dictionary
            The original dictionary is : {'name': ['Jan', 'Feb', 'March'], 'month': [1, 2, 3]}
            Flattened dictionary : {1: 'Jan', 2: 'Feb', 3: 'March'}
        
  •             Describe program to check whether a number is Prime or not
           
        
  •             Describe Program for factorial of a number
           
        
  •             Describe program to check if a string is palindrome or not
           
        
  •             Describe Program to find largest element in an array
           
        
  •             Describe program to Reversing a List
           
        
  •             Describe program to Reverse words in a given String 
           
        
  •             Explain the concept of stream processing and how Databricks supports real-time analytics.
        
  •             How can you troubleshoot and optimize the performance of a slow-running Spark job on Databricks?
        
  •             What is Node.js, and how does it differ from traditional backend JavaScript?
        
  •             Explain the concept of event-driven programming in Node.js and its significance.
        
  •             How does Node.js handle asynchronous operations, and what are its advantages?
Only PDF format.