Upload Button Icon Add office photos

IDC Technologies

Compare button icon Compare button icon Compare

Filter interviews by

IDC Technologies SQL Developer Interview Questions and Answers

Updated 23 Dec 2023

IDC Technologies SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

user image VIJAY KUMAR MANGALI

posted on 23 Dec 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Selected Selected
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 

(2 Questions)

  • Q1. What are joins
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Joins are used in SQL to retrieve data from multiple tables based on a related column between them.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q2. What is DML and use
  • Ans. 

    DML stands for Data Manipulation Language and is used to manipulate data in a database.

    • DML is used to insert, update, delete, and retrieve data in a database.

    • Examples of DML statements include INSERT, UPDATE, DELETE, and SELECT.

    • DML is essential for managing and modifying data within a database.

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Explain your job experience and projects done till now
  • Q2. What is your expected salary

Skills evaluated in this interview

Top trending discussions

View All
Interview Tips & Stories
1w (edited)
a team lead
Why are women still asked such personal questions in interview?
I recently went for an interview… and honestly, m still trying to process what just happened. Instead of being asked about my skills, experience, or how I could add value to the company… the questions took a totally unexpected turn. The interviewer started asking things like When are you getting married? Are you engaged? And m sure, if I had said I was married, the next question would’ve been How long have you been married? What does my personal life have to do with the job m applying for? This is where I felt the gender discrimination hit hard. These types of questions are so casually thrown at women during interviews but are they ever asked to men? No one asks male candidates if they’re planning a wedding or how old their kids are. So why is it okay to ask women? Can we please stop normalising this kind of behaviour in interviews? Our careers shouldn’t be judged by our relationship status. Period.
Got a question about IDC Technologies?
Ask anonymously on communities.

Interview questions from similar companies

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

21 students were shortlisted from the 1st MCQ round and in this round we were asked to write the codes (function only) of 3 questions in 1 hour time.

  • Q1. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Q2. 

    Majority Element Problem Statement

    Given an array/list 'ARR' consisting of 'N' integers, your task is to find the majority element in the array. If there is no majority element present, return -1.

    Exampl...

  • Q3. 

    Maximum Path Sum Between Two Leaves Problem Description

    You are provided with a non-empty binary tree in which each node contains a non-negative integer value. Your task is to find and return the maximum ...

  • Ans. 

    Find the maximum path sum between two leaf nodes in a binary tree.

    • Traverse the tree to find the maximum path sum between two leaf nodes.

    • Keep track of the maximum sum found so far.

    • Consider all possible paths between leaf nodes.

    • Handle cases where the tree has only a single leaf node.

    • Implement a recursive function to calculate the maximum path sum.

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This was a technical round with DSA based questions.

  • Q1. 

    N-th Node From The End Problem Statement

    You are given a Singly Linked List of integers. The task is to find the N-th node from the end of the list.

    Example:

    Input:
    If the given list is (1 -> -2 -&g...
  • Ans. 

    Find the N-th node from the end of a Singly Linked List of integers.

    • Traverse the list to find the length L of the list.

    • Calculate the position of the N-th node from the beginning as L - N + 1.

    • Traverse the list again to reach the calculated position and return the node's value.

  • Answered by AI
  • Q2. 

    LCA of Binary Tree Problem Statement

    You are given a binary tree consisting of distinct integers and two nodes, X and Y. Your task is to find and return the Lowest Common Ancestor (LCA) of these two nodes...

  • Q3. 

    Reverse Words in a String: Problem Statement

    You are given a string of length N. Your task is to reverse the string word by word. The input may contain multiple spaces between words and may have leading o...

Round 3 - Face to Face 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions based on DSA

  • Q1. 

    Minimum Time To Solve The Problems

    Given 'N' subjects, each containing a certain number of problems, and 'K' friends, assign subjects to friends such that each subject goes to exactly one friend, maintain...

  • Q2. What is grammar in the context of compiler design?
  • Ans. 

    Grammar in compiler design defines the syntax and structure of a programming language.

    • Grammar specifies the rules for forming valid statements in a programming language.

    • It consists of a set of production rules that define how valid programs can be constructed.

    • There are different types of grammars such as context-free grammar, regular grammar, etc.

    • Example: In C programming language, the grammar specifies that a for loop...

  • Answered by AI
  • Q3. What is a token in compiler design?
  • Ans. 

    A token in compiler design is a basic unit of syntax that the compiler can understand and process.

    • Tokens are the smallest units of a program that are meaningful to the compiler.

    • Examples of tokens include keywords, identifiers, operators, and punctuation symbols.

    • Tokens are generated by the lexical analysis phase of the compiler.

    • Tokens are used by the parser to build the abstract syntax tree of the program.

  • Answered by AI
Round 4 - Video Call 

(3 Questions)

Round duration - 60 minutes
Round difficulty - Easy

Technical round with questions on DSA and Compiler Design mainly. He told me that you’ll be having your final HR round in some time. I knew that I was going well because he seemed to be quite satisfied with my answers.

  • Q1. 

    Sum Root to Leaf Numbers

    You are given an arbitrary binary tree consisting of N nodes, each associated with an integer value from 1 to 9. Each root-to-leaf path can be considered a number formed by concat...

  • Q2. What is a regular language?
  • Ans. 

    A regular language is a language that can be recognized by a finite automaton.

    • Regular languages can be described by regular expressions.

    • Regular languages are closed under union, concatenation, and Kleene star operations.

    • Examples of regular languages include the set of all strings over an alphabet that contain an even number of 'a's.

  • Answered by AI
  • Q3. What are NP and NP-Hard problems?
  • Ans. 

    NP problems are decision problems that can be verified in polynomial time, while NP-Hard problems are at least as hard as the hardest problems in NP.

    • NP problems can be verified in polynomial time but not necessarily solved in polynomial time.

    • NP-Hard problems are at least as hard as the hardest problems in NP, but may not be in NP themselves.

    • Examples of NP problems include the subset sum problem and the traveling salesm...

  • Answered by AI
Round 5 - HR 

Round duration - 30 minutes
Round difficulty - Easy

That was the round for which I’ve been waiting for hours 
She was very friendly and nice to talk to. It didn’t seem that I was talking to the HR. It was more like talking to a friend. Finally we discussed about the pay-scale and work culture in Accolite.

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAAccolite Digital Pvt Ltd interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, System Design, Aptitude, OOPSTime required to prepare for the interview - 6 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

SQL Developer Interview Questions Asked at Other Companies

asked in BNP Paribas
Q1. How does the development team service a change request in the app ... read more
asked in BNP Paribas
Q2. Write a procedure to return the series (99, 96, 93, ..., 6, 3).
Q3. Write a query to join two tables and display the combined informa ... read more
asked in BNP Paribas
Q4. Given sample data on two tables, write down the result sets of al ... read more
asked in HCLTech
Q5. What are the differences between TRUNCATE and DROP statements, es ... read more

I applied via Referral and was interviewed in Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Why do you want to join Incedo, what is your plan in future, explain your past experience with an example
  • Ans. 

    I am drawn to Incedo for its innovative approach and growth opportunities, aligning with my career aspirations in technology consulting.

    • Incedo's commitment to innovation resonates with my passion for technology and problem-solving.

    • I admire Incedo's collaborative culture, which I experienced in my previous role at XYZ Corp, where teamwork led to a successful project launch.

    • My future plan includes advancing my skills in ...

  • Answered by AI
  • Q2. Basic of capital market
  • Q3. Market capitalisation, capital market, derivatives, accounting knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - One should be more confident and should give prompt response

Associate Interview Questions & Answers

Incedo user image Abhishek Pandey

posted on 22 Nov 2021

I applied via Walk-in and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. A few terms related to mutual fund industry were asked.
  • Ans. I don't know.
  • Answered by Abhishek Pandey
  • Q2. What do you understand by market capitalisation?
  • Ans. Total number of shares outstanding multiplied by the price of one share.
  • Answered by Abhishek Pandey

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, confident and honest.

I appeared for an interview in Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 20 Minutes
Round difficulty - Easy

  • Q1. 

    Left View of a Binary Tree Problem Statement

    Given a binary tree, your task is to print the left view of the tree.

    Example:

    Input:
    The input will be in level order form, with node values separated by a...
Round 2 - Video Call 

(3 Questions)

Round duration - 45 Minutes
Round difficulty - Easy

It was a technical round held on skype.

  • Q1. 

    Intersection of Linked List Problem

    You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list.

    Your task is to determine t...

  • Q2. 

    Reverse Linked List Problem Statement

    Given a Singly Linked List of integers, your task is to reverse the Linked List by altering the links between the nodes.

    Input:

    The first line of input is an intege...
  • Q3. 

    Merge K Sorted Arrays Problem Statement

    You are provided with 'K' different arrays/lists, each sorted in ascending order. Your task is to merge all these arrays/lists into one sorted array/list in ascendi...

  • Ans. 

    Merge K sorted arrays into one sorted array in ascending order.

    • Iterate through all arrays/lists and merge them into one sorted array using a priority queue or merge sort algorithm.

    • Ensure to handle edge cases like empty arrays/lists or arrays/lists with different sizes.

    • Time complexity can be optimized by using a min-heap or priority queue to efficiently merge the arrays/lists.

  • Answered by AI
Round 3 - Video Call 

(1 Question)

Round duration - 60 Minutes
Round difficulty - Easy

It was also a technical round held on Google meet.
 

  • Q1. 

    Maximum Subarray Problem Statement

    Ninja has been given an array, and he wants to find a subarray such that the sum of all elements in the subarray is maximum.

    A subarray 'A' is considered greater than a...

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from B V Raju Institute of Technology. I applied for the job as SDE - 1 in HyderabadEligibility criteria7 CGPAAccolite interview preparation:Topics to prepare for the interview - DS, Algo, DBMS, HTML, CSS, Machine Learning, SQL, Java, OOPs, PythonTime required to prepare for the interview - 3 MonthsInterview preparation tips for other job seekers

Tip 1 : Maintain detail notes
Tip 2 : Revise the notes 
 

Application resume tips for other job seekers

Tip 1 : Mention the skills only which you are aware of
Tip 2 : Improve your resume

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. 1. Write a code to split an array of integers into two subarray where both the array has equal sum.
  • Ans. 

    Code to split an array of integers into two subarrays with equal sum.

    • Iterate through the array and calculate the total sum.

    • Divide the sum by 2 to get the target sum for each subarray.

    • Use dynamic programming to find a subset of the array that adds up to the target sum.

    • Return the two subarrays.

    • Example: [1, 2, 3, 4, 5, 6] -> [1, 2, 3, 6], [4, 5]

    • Example: [1, 2, 3, 4, 5] -> [1, 4, 5], [2, 3]

  • Answered by AI
  • Q2. To write code to build up a binary tree from scratch (implement a BST) and then to write all the methods like all the tree traversal algo, and all other stuffs.
  • Q3. Other OOPs concept and questions related to DSA and OS.

Interview Preparation Tips

Interview preparation tips for other job seekers - Accolite has a difficult hiring bar and hires only the good ones. Focus on DSA concepts and practice as many questions from Leetcode, Interviewbits, GFG. Focus on all the OOPs concept and subject like OS.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Java multithreading, oops
Are these interview questions helpful?

I applied via Company Website and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Related to react js amd js

Interview Preparation Tips

Interview preparation tips for other job seekers - Average interview. There will he two rounds technical. One will be telephonic and second will be skyp video.
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - HR 

(2 Questions)

  • Q1. What is nav describe
  • Ans. 

    NAV stands for Net Asset Value, which represents the per-share value of a mutual fund or exchange-traded fund (ETF).

    • NAV is calculated by subtracting a fund's liabilities from its assets and dividing by the number of shares outstanding.

    • It is used to determine the price at which investors can buy or sell shares of the fund.

    • NAV is typically calculated at the end of each trading day.

    • For example, if a mutual fund has assets...

  • Answered by AI
  • Q2. What is the function of custodian bank
  • Ans. 

    Custodian banks are financial institutions responsible for safeguarding assets, such as securities and cash, on behalf of institutional clients.

    • Provide safekeeping of assets

    • Settle trades on behalf of clients

    • Collect income on assets

    • Process corporate actions

    • Provide reporting and other administrative services

    • Act as a liaison between the client and the investment manager

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep up your technical knowledge high
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. They focusing on communication and ask capital markets, derivatives related questions.
Round 2 - Technical 

(1 Question)

  • Q1. Mutual fund, hedge fund, private equity, etf, performance fee, management fee, NAV calculation.
Round 3 - One-on-one 

(1 Question)

  • Q1. Same as technical and ask some behavioural questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - If you want to go in wealth management prepare for all questions in core which I mentioned in technical round.

IDC Technologies Interview FAQs

How many rounds are there in IDC Technologies SQL Developer interview?
IDC Technologies interview process usually has 3 rounds. The most common rounds in the IDC Technologies interview process are Resume Shortlist, Technical and One-on-one Round.
What are the top questions asked in IDC Technologies SQL Developer interview?

Some of the top questions asked at the IDC Technologies SQL Developer interview -

  1. what is DML and ...read more
  2. what are jo...read more

Tell us how to improve this page.

Overall Interview Experience Rating

4.5/5

based on 2 interview experiences

Difficulty level

Easy 50%
Moderate 50%

Duration

Less than 2 weeks 100%
View more

Interview Questions from Similar Companies

ITC Infotech Interview Questions
3.7
 • 378 Interviews
CitiusTech Interview Questions
3.3
 • 290 Interviews
NeoSOFT Interview Questions
3.6
 • 280 Interviews
Altimetrik Interview Questions
3.7
 • 243 Interviews
Episource Interview Questions
3.9
 • 224 Interviews
Xoriant Interview Questions
4.1
 • 215 Interviews
INDIUM Interview Questions
4.0
 • 203 Interviews
Incedo Interview Questions
3.0
 • 193 Interviews
Iris Software Interview Questions
4.0
 • 190 Interviews
View all
IDC Technologies SQL Developer Salary
based on 5 salaries
₹3.8 L/yr - ₹8 L/yr
9% more than the average SQL Developer Salary in India
View more details

IDC Technologies SQL Developer Reviews and Ratings

based on 4 reviews

3.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

3.0

Salary

3.0

Job security

3.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 4 Reviews and Ratings
Information Technology Recruiter
274 salaries
unlock blur

₹2.1 L/yr - ₹5.4 L/yr

Software Engineer
265 salaries
unlock blur

₹4.2 L/yr - ₹9.5 L/yr

Technical Recruiter
261 salaries
unlock blur

₹2 L/yr - ₹6 L/yr

Senior IT Recruiter
241 salaries
unlock blur

₹3.5 L/yr - ₹7.7 L/yr

Senior Technical Recruiter
219 salaries
unlock blur

₹3.7 L/yr - ₹7.8 L/yr

Explore more salaries
Compare IDC Technologies with

ITC Infotech

3.7
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

4.1
Compare
write
Share an Interview