Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Smollan Group Team. If you also belong to the team, you can get access from here

Smollan Group Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Smollan Group SQL Developer Interview Questions and Answers

Updated 13 Oct 2022

Smollan Group SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2022

I applied via Naukri.com and was interviewed in Sep 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(3 Questions)

  • Q1. Sql all basic including performance tuning
  • Q2. Ssis or ETL individual blocks details
  • Q3. Also prepare Power BI interview questions, it will be an additional

Interview Preparation Tips

Interview preparation tips for other job seekers - Be sure with your basics. As they asked basic technical questions with why. So always keep in mind for answers of the next question as why

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Calender, time, relationship

Round 3 - HR 

(3 Questions)

  • Q1. Interduction itself
  • Q2. Technical questions
  • Q3. Data structure and algorithms

I applied via Naukri.com and was interviewed in May 2022. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    I am a highly motivated and experienced professional with a strong background in the field.

    • I have a Bachelor's degree in Business Administration

    • I have over 5 years of experience in sales and marketing

    • I am skilled in developing and implementing effective strategies

    • I have a proven track record of exceeding sales targets

    • I am a team player and have excellent communication skills

  • Answered by AI
  • Q2. Last movie you have watched
  • Ans. 

    The last movie I watched was 'Inception'.

    • The movie is directed by Christopher Nolan.

    • It is a science fiction action film.

    • The plot revolves around a thief who steals corporate secrets through dream-sharing technology.

    • The film stars Leonardo DiCaprio, Joseph Gordon-Levitt, and Ellen Page.

    • It received critical acclaim for its unique concept and visual effects.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - easy and nothing tough good communication is only required.

Associate Interview Questions & Answers

Mediamint user image Sohail Akhtar

posted on 13 Apr 2023

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(5 Questions)

  • Q1. What is retargeting
  • Ans. 

    Retargeting is a marketing strategy that targets users who have previously interacted with a brand or website.

    • Retargeting uses cookies to track user behavior and display targeted ads to them.

    • It helps to increase brand awareness and conversions by reminding users of products or services they showed interest in.

    • Retargeting can be done on various platforms such as social media, search engines, and display networks.

    • Example...

  • Answered by AI
  • Q2. What fascinates you about digital marketing
  • Ans. 

    The ability to reach and engage with a large audience in real-time through various digital channels.

    • The constantly evolving nature of digital marketing keeps me on my toes and allows for continuous learning and growth.

    • The data-driven approach in digital marketing enables precise targeting and measurement of campaign effectiveness.

    • The creativity involved in crafting compelling content and campaigns to capture audience a...

  • Answered by AI
  • Q3. What is targeting
  • Ans. 

    Targeting is the process of identifying and selecting a specific audience or group of individuals for a particular product or service.

    • Targeting involves analyzing data to determine the characteristics of the desired audience

    • It helps in creating personalized marketing messages and campaigns

    • Examples of targeting include demographic targeting, geographic targeting, and behavioral targeting

    • Targeting can also be used in adv...

  • Answered by AI
  • Q4. Example of retargeting in daily life
  • Ans. 

    Retargeting is when ads follow you after visiting a website or searching for a product.

    • After searching for a product on Amazon, ads for that product appear on other websites

    • Ads for a hotel you looked at on Booking.com follow you on social media

    • After browsing a clothing website, ads for that brand appear on your Instagram feed

  • Answered by AI
  • Q5. What is Seo and how it works
  • Ans. 

    SEO stands for Search Engine Optimization. It is the process of optimizing a website to rank higher in search engine results pages.

    • SEO involves optimizing website content, structure, and HTML code

    • Keyword research and analysis is a crucial part of SEO

    • Link building and social media marketing can also improve SEO

    • Search engines use complex algorithms to determine website rankings

    • SEO is an ongoing process that requires cons

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with basics of digital marketing terms

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Email Writing 

(1 Question)

  • Q1. Tell me about yourself
Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. What are your hobbies?
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Oct 2023.

Round 1 - Coding Test 

It was based on frontend technologies

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic frontend question
Round 3 - One-on-one 

(1 Question)

  • Q1. Managerial round
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Easy-Medium level Leetcode questions on linkedlists
  • Q2. Simple recursion question
  • Q3. An SQL query Basic question in OOPS and resume description..
  • Q4. Basic questions regarding SQL
  • Q5. Difference between thread and process
  • Ans. 

    A process is an instance of a program while a thread is a subset of a process that can run concurrently with other threads.

    • Processes have their own memory space while threads share the same memory space within a process.

    • Processes are independent of each other while threads within the same process can communicate with each other.

    • Processes are heavier in terms of resource consumption compared to threads.

    • Example: A web br...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with your basics

Skills evaluated in this interview

Interview Questionnaire 

3 Questions

  • Q1. N a line where words are separated by spaces, , and capitalize first letter of the reversed word. Other letters of the word should be in small. Input : “how are you?” → Output: “Woh Era ?uoy”
  • Ans. 

    The program capitalizes the first letter of each reversed word in a sentence.

    • Split the sentence into an array of words using space as a delimiter.

    • Reverse each word in the array and capitalize the first letter.

    • Join the modified words back into a sentence.

  • Answered by AI
  • Q2. He second question reduced to finding maximum weight matching in a bipartite graph. Not many people would have done this (maybe none)
  • Q3. There are 2 sets of countries. One set will donate clothes (something of this sort) and anotherset will accept clothes. A country can be in only 1 of the sets. The amount of clothes donated is also given. ...

Interview Preparation Tips

Round: Test
Experience: There were about 20 MCQs (30 minutes) to be done after the coding section. MCQs were totally nonsense. Can be done in 10 mins.For coding section 60 mins.  It was hosted on Hackerrank.
Duration: 90 minutes
Total Questions: 2

Round: Technical Interview
Experience: After this, selected candidates were interviewed that consists of 4 rounds and discussion was mostly on your CV and data structure problems.

General Tips: Be honest with your interviewer. If you are not comfortable in 1 topic, tell your interviewer honestly. Do well in other areas. Look for hints from the interviewer if you get stuck. They want to see how you approach a problem.
Skills: Algortihm, Data structure
College Name: IIT DELHI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Prepare js array and string functions, and React js core concepts
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Feb 2024.

Round 1 - Aptitude Test 

In this exam, they will be evaluated on logic, mathematics, general knowledge, and grammar.

Round 2 - Assignment 

In this, they will conduct a scenario-based email writing exam.

Round 3 - HR 

(2 Questions)

  • Q1. What types of questions can I expect in the first round of HR interviews, particularly regarding my background and motivations for seeking a job in digital marketing?
  • Q2. Was the second round of the interview a technical round?

Smollan Group Interview FAQs

How many rounds are there in Smollan Group SQL Developer interview?
Smollan Group interview process usually has 2 rounds. The most common rounds in the Smollan Group interview process are Resume Shortlist and Technical.
How to prepare for Smollan Group SQL Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Smollan Group. The most common topics and skills that interviewers at Smollan Group expect are SQL, SQL Development, SQL Programming and SQL Server.
What are the top questions asked in Smollan Group SQL Developer interview?

Some of the top questions asked at the Smollan Group SQL Developer interview -

  1. Also prepare Power BI interview questions, it will be an additio...read more
  2. Sql all basic including performance tun...read more
  3. Ssis or ETL individual blocks deta...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Epsilon Interview Questions
4.0
 • 90 Interviews
Regalix Interview Questions
2.9
 • 45 Interviews
Denave Interview Questions
3.6
 • 40 Interviews
Xdbs Interview Questions
3.2
 • 39 Interviews
InMobi Interview Questions
3.4
 • 35 Interviews
Mediamint Interview Questions
3.4
 • 33 Interviews
MiQ Digital Interview Questions
3.3
 • 32 Interviews
View all
Smollan Group SQL Developer Salary
based on 7 salaries
₹6.2 L/yr - ₹10 L/yr
56% more than the average SQL Developer Salary in India
View more details

Smollan Group SQL Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

4.0

Work-life balance

4.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Sales Executive
111 salaries
unlock blur

₹1.6 L/yr - ₹4.2 L/yr

Marketing Executive
90 salaries
unlock blur

₹1.4 L/yr - ₹3.8 L/yr

Team Lead
85 salaries
unlock blur

₹2.1 L/yr - ₹6.2 L/yr

Field Manager
71 salaries
unlock blur

₹5.2 L/yr - ₹14 L/yr

Rural Sales Promoter
61 salaries
unlock blur

₹1.3 L/yr - ₹3.2 L/yr

Explore more salaries
Compare Smollan Group with

Epsilon

4.0
Compare

Denave

3.6
Compare

Regalix

2.9
Compare

Dentsu Aegis Network

3.4
Compare
Did you find this page helpful?
Yes No
write
Share an Interview