2 ICRA Analytics SQL Developer Interview Questions & Answers | Complete Prep Guide 2025

ICRA Analytics SQL Developer Interview Experiences

1 interview found

SQL Developer Interview Questions & Answers

Anonymous

posted on 9 Jul 2024

Interview experience

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

Add your answer

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

Add your answer

Skills evaluated in this interview

Top trending discussions

View All

Engineering - Software & QA

fabulousboss

works at

R1 RCM

Hello guys, I’m working as Senior Customer Associate in R1. I’m looking to move in IT field, i have to 2 option to choose Data Analyst or Automation . I never used any language or software, I’m only aware abo... read more

21 participants . expiring in 1w

Got a question about ICRA Analytics?

Ask anonymously on communities.

Interview questions from similar companies

Software Developer Interview Questions & Answers

S&P Global

Santhosh M S

posted on 2 Dec 2015

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

Associate Interview Questions & Answers

S&P Global

Anonymous

posted on 8 Jun 2017

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

Add your answer

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

Add your answer

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

Add your answer

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

Add your answer

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

Add your answer

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

Add your answer

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

Software Developer Interview Questions & Answers

S&P Global

Anonymous

posted on 6 Jun 2017

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

Software Developer Interview Questions & Answers

Equifax

Anonymous

posted on 11 May 2023

Interview experience

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

Add your answer

Q2. It’s a collection framework.

Add your answer

Interview Preparation Tips

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

Skills evaluated in this interview

Associate Interview Questions & Answers

Crisil

Anonymous

posted on 2 Jun 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

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

Add your answer

Round 2 - Technical

(1 Question)

Q1. Work experience Auction process Bidding

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with fundamentals

Associate Interview Questions & Answers

Crisil

Anonymous

posted on 30 Mar 2024

Interview experience

Good

Difficulty level

Hard

Process Duration

Less than 2 weeks

Result

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

Add your answer

Round 3 - HR

(1 Question)

Q1. Offer discussion

Add your answer

Associate Interview Questions & Answers

Crisil

Anonymous

posted on 26 Feb 2025

Interview experience

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

Add your answer

Associate Interview Questions & Answers

Crisil

Anonymous

posted on 5 Mar 2023

Interview experience

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

Add your answer

Q2. Aptitude question like 5 liter glass and 3 liter glass

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare according to your resume, you will be asked questions according to that.

Associate Interview Questions & Answers

Crisil

Anonymous

posted on 17 Jul 2023

Interview experience

Poor

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

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

Add your answer

Round 3 - One-on-one

(2 Questions)

Q1. Based on your resume, will ask questions based on your past questions

Add your answer

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

Add your answer

Round 4 - One-on-one

(1 Question)

Q1. Reason for choosing this job and salary negotiation

Add your answer

Skills evaluated in this interview

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 -

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

Senior Associate Analyst 423 salaries	₹0 L/yr - ₹0 L/yr
Lead Analyst 151 salaries	₹0 L/yr - ₹0 L/yr
Principal Analyst 80 salaries	₹0 L/yr - ₹0 L/yr
Assistant Manager 54 salaries	₹0 L/yr - ₹0 L/yr
Senior Associate 43 salaries	₹0 L/yr - ₹0 L/yr

ICRA Analytics SQL Developer Interview Questions and Answers

ICRA Analytics SQL Developer Interview Experiences

1 interview found

(2 Questions)

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Interview Questionnaire

6 Questions

Interview Preparation Tips

Interview Preparation Tips

(2 Questions)

Interview Preparation Tips

Skills evaluated in this interview

(1 Question)

(1 Question)

Interview Preparation Tips

(1 Question)

(1 Question)

(1 Question)

(2 Questions)

Interview Preparation Tips

(1 Question)

(2 Questions)

(1 Question)

Skills evaluated in this interview

ICRA Analytics Interview FAQs

Recently Viewed

ICRA Analytics

Cafe Coffee Day

PUMA

PUMA

Pragmatic Play

Pragmatic Play

Cafe Coffee Day

ICRA Analytics

Bank of Baroda

Cafe Coffee Day

Tell us how to improve this page.

ICRA Analytics Interviews By Designations

Interview Questions for Popular Designations

ICRA Analytics SQL Developer Interview Process

Interview Questions from Similar Companies

Fast track your campus placements