Upload Button Icon Add office photos
Engaged Employer

i

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

ICRA Analytics Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ICRA Analytics SQL Developer Interview Questions and Answers

Updated 9 Jul 2024

ICRA Analytics SQL Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Technical 

(2 Questions)

  • Q1. Type of joins in sql server
  • Ans. 

    Types of joins in SQL Server include inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is at least one match in both tables

    • Left join: Returns all rows from the left table and the matched rows from the right table

    • Right join: Returns all rows from the right table and the matched rows from the left table

    • Full outer join: Returns rows when there is a match in one of the tables

  • Answered by AI
  • Q2. What is super key in sql
  • Ans. 

    A super key is a set of attributes that uniquely identifies each tuple in a table.

    • A super key can contain more attributes than necessary to uniquely identify a tuple.

    • Example: {ID, Name} can be a super key for a table with attributes {ID, Name, Age}.

    • Super keys are used in database design to ensure data integrity.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: Pre-placement offer
Experience: Each intern was assigned a individual project and mentor.
In the last week of internship there was project presentation and interview.
interview was easy .For me 50% of the questions were about project and some questions about algorithms and DBMS.
More emphasis was given to the quality of work on project.

General Tips: Working in company is complete different from working on course project. learning many new frameworks required for the project was really challenging.
Programming : Tree, Btree, Tries ..
Operating System: Memory Management
Networks: OSI model
DBMS : basics. they dint ask me any. Show case your interest in big data, servers and passion for technology
Skill Tips: Be confident, even if you don't know the exact answer don't give up tell your approaches to interviewer. some times they will also help you. Software Developer some question s you can ask are: what technologies do your company works on. how are freshers will be selected to different teams in the company.
Skills:
College Name: NIT Surathkal

I was interviewed before Jun 2016.

Interview Questionnaire 

6 Questions

  • Q1. What is a bond? What are different types of bonds?
  • Ans. 

    A bond is a debt security that represents a loan made by an investor to a borrower.

    • Bonds are issued by governments, municipalities, and corporations.

    • They are used to raise capital and finance projects.

    • Different types of bonds include government bonds, corporate bonds, municipal bonds, and convertible bonds.

    • Government bonds are issued by national governments and are considered low-risk.

    • Corporate bonds are issued by comp...

  • Answered by AI
  • Q2. Tell us something about your specialisation subjects of BBA
  • Ans. 

    My specialisation subjects in BBA include marketing, finance, human resource management, and operations management.

    • Marketing involves understanding consumer behavior and creating strategies to promote products or services.

    • Finance focuses on managing funds, investments, and financial planning.

    • Human resource management deals with recruiting, training, and managing employees.

    • Operations management involves overseeing produ...

  • Answered by AI
  • Q3. Which is your favourite subject? Describe about it
  • Ans. 

    My favorite subject is history because I enjoy learning about past events and how they have shaped the world we live in today.

    • I find studying different time periods and cultures fascinating

    • I enjoy analyzing historical documents and artifacts

    • I like understanding how historical events have influenced current societies and politics

  • Answered by AI
  • Q4. Are you comfortable in night shifts
  • Ans. 

    Yes, I am comfortable with night shifts as I have prior experience working in night shifts.

    • I have previous experience working night shifts in my previous job.

    • I am able to adjust my sleep schedule to accommodate night shifts.

    • I understand the importance of being alert and focused during night shifts.

    • I am willing to work night shifts if required for the role.

  • Answered by AI
  • Q5. What are your hobbies
  • Ans. 

    My hobbies include hiking, painting, and playing the guitar.

    • Hiking: I enjoy exploring nature trails and challenging myself physically.

    • Painting: I find relaxation and creativity in expressing myself through art.

    • Playing the guitar: I love learning new songs and improving my musical skills.

  • Answered by AI
  • Q6. Where do your parents and siblings work
  • Ans. 

    My parents work in education and my siblings work in finance and healthcare.

    • Parents work in education

    • Siblings work in finance and healthcare

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: In this round there was an online test which had objective and subjective questions regarding the mentioned sections.
Duration: 1 hour
Total Questions: 30

Round: Technical Interview
Experience: The interviewer asked such questions about my graduation subjects and a little about how familiar I am of the work the company deals in.

Round: HR Interview
Experience: This round had the HR person ask general questions about my hobbies and about my family background and also told me about the company, its culture and the salary structure

College Name: Maharaja Surajmal Institute Of Technology

Interview Preparation Tips

Round: Test
Experience: Quantitative, verbal, reasoning and basic technical questions.
Duration: 1 hour
Total Questions: 50

Round: Technical + HR Interview
Experience: Questions based on data structures, algorithms, and object oriented programming concepts.
Tested basic knowledge in Finance sector especially related to the company.

College Name: Delhi Technological University, Delhi
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. What is HashMap?
  • Ans. 

    HashMap is a data structure that stores key-value pairs and provides constant time complexity for basic operations.

    • HashMap allows quick access to values based on their keys

    • Keys must be unique and values can be duplicated

    • HashMap is not thread-safe and requires synchronization for concurrent access

    • Java's HashMap implementation uses hashing to distribute keys across buckets

  • Answered by AI
  • Q2. It’s a collection framework.

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic background related questions
Round 2 - Technical 

(1 Question)

  • Q1. Work experience Auction process Bidding

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with fundamentals
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Includes coding, mathematical

Round 2 - Technical 

(1 Question)

  • Q1. Based on ur resume
Round 3 - HR 

(1 Question)

  • Q1. Offer discussion
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about yourself and work experience
  • Ans. 

    I am a dedicated professional with 5 years of experience in marketing and project management.

    • Worked in marketing for a tech company for 3 years

    • Managed multiple projects simultaneously

    • Strong communication and organizational skills

    • Experience with data analysis and reporting

    • Led successful marketing campaigns resulting in increased sales

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Aptitude Test 

Python and Aptitude English Questions

Round 3 - One-on-one 

(2 Questions)

  • Q1. It was with the Manager with whom youll be working under
  • Q2. Aptitude question like 5 liter glass and 3 liter glass

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare according to your resume, you will be asked questions according to that.
Interview experience
2
Poor
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jan 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all Resume tips
Round 2 - HR 

(1 Question)

  • Q1. About reason for break if any
Round 3 - One-on-one 

(2 Questions)

  • Q1. Based on your resume, will ask questions based on your past questions
  • Q2. When will u get #ref error and when u get #value error in excel
  • Ans. 

    You get #REF error in Excel when a cell reference is not valid, and you get #VALUE error when a formula includes the wrong type of argument or operand.

    • You get #REF error when a formula refers to a cell that is not valid, such as a deleted cell or a cell in a different sheet.

    • You get #VALUE error when a formula includes the wrong type of argument, such as text instead of a number, or when an operand is not valid for the ...

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

(1 Question)

  • Q1. Reason for choosing this job and salary negotiation

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

ICRA Analytics Interview FAQs

How many rounds are there in ICRA Analytics SQL Developer interview?
ICRA Analytics interview process usually has 1 rounds. The most common rounds in the ICRA Analytics interview process are Technical.
How to prepare for ICRA Analytics 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 ICRA Analytics. The most common topics and skills that interviewers at ICRA Analytics expect are C#, SQL Development, VBA, Web Services and Web Technologies.
What are the top questions asked in ICRA Analytics SQL Developer interview?

Some of the top questions asked at the ICRA Analytics SQL Developer interview -

  1. What is super key in ...read more
  2. Type of joins in sql ser...read more

Recently Viewed

INTERVIEWS

ICRA Analytics

10 top interview questions

INTERVIEWS

Cafe Coffee Day

20 top interview questions

INTERVIEWS

PUMA

No Interviews

INTERVIEWS

PUMA

No Interviews

INTERVIEWS

Pragmatic Play

No Interviews

INTERVIEWS

Pragmatic Play

10 top interview questions

INTERVIEWS

Cafe Coffee Day

No Interviews

INTERVIEWS

ICRA Analytics

No Interviews

INTERVIEWS

Bank of Baroda

No Interviews

INTERVIEWS

Cafe Coffee Day

No Interviews

Tell us how to improve this page.

ICRA Analytics SQL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

S&P Global Interview Questions
4.1
 • 275 Interviews
Mu Sigma Interview Questions
2.6
 • 229 Interviews
Crisil Interview Questions
3.6
 • 188 Interviews
Sigmoid Interview Questions
3.2
 • 59 Interviews
Merilytics Interview Questions
3.0
 • 48 Interviews
Equifax Interview Questions
3.3
 • 30 Interviews
Dunnhumby Interview Questions
4.0
 • 29 Interviews
Everest Group Interview Questions
3.3
 • 25 Interviews
Coronis Health Interview Questions
3.7
 • 23 Interviews
View all
Senior Associate Analyst
423 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Analyst
151 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Principal Analyst
80 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
54 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ICRA Analytics with

Crisil

3.6
Compare

CareEdge Ratings

3.0
Compare

Brickwork Ratings

3.7
Compare

SMERA Ratings

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