Search

Interview Questions

  • Reviews
  • Salaries
  • Interview Questions
  • About Company
  • Benefits
  • Jobs
  • Office Photos
  • Community
+ Contribute
notification
notification
Login
Upload Button Icon Add office photos
Employer? Claim Account for FREE

First American Corporation

Compare button icon Compare button icon Compare
3.6

based on 1.4k Reviews

Play video Play video Video summary

Filter interviews by

First American Corporation Database Developer Interview Questions and Answers

Updated 9 Nov 2022

First American Corporation Database Developer Interview Experiences

1 interview found

Database Developer Interview Questions & Answers

user image Anonymous

posted on 9 Nov 2022

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 - HR 

(2 Questions)

  • Q1. Work through resume and professional experience
    • Add your answer
  • Q2. Work authorization status and do you need sponsorship
  • Ans. 

    I am authorized to work in the country and do not require sponsorship.

    • I have the necessary work authorization to legally work in the country

    • I do not require sponsorship from the employer for my work authorization

    • I am eligible to work without any restrictions

    • Answered by AI
    Add your answer
Round 3 - Technical 

(2 Questions)

  • Q1. Tell me more about yourself and what's this role will do
  • Ans. 

    I am a Database Developer with expertise in designing, implementing, and optimizing databases. This role involves creating and maintaining databases, writing efficient queries, and ensuring data integrity.

    • Designing and implementing databases

    • Writing efficient queries

    • Optimizing database performance

    • Ensuring data integrity and security

    • Collaborating with software developers and stakeholders

    • Troubleshooting and resolving data...

    • Answered by AI
    Add your answer
  • Q2. What is temporary table and what is view
  • Ans. 

    Temporary table is a table that exists temporarily and is used to store data temporarily. A view is a virtual table that is based on the result-set of an SQL statement.

    • Temporary table is created for a specific session or task and is dropped automatically when the session is closed or the task is completed.

    • Temporary table can be used to store intermediate results during complex queries or to store data that needs to be ...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare technical knowledge and prepare self introduction

Top trending discussions

View All
Interview Tips & Stories
2w
a business analyst
Best answer to give to HR on why am I on notice!
Hi, I have recently left my job and on my notice with 20 days pending. While giving interviews, when the HR asks me what's the notice I say it's 30 days (officially 60 days). But since only 20 days are left, is it better to tell them outright that I'm on notice or wait for them to ask? 1 or 2 replies I have thought of if they ask why I am already on notice is - "In my current role I was not able to leverage and improve my current skills optimally and it was detrimental to my career path of working towards Product from Business Analyst. With the decision to change company and since I have given quite a few interviews in the last 1.5 months, I decided to put down my papers in order to mitigate the risk of not getting an offer due to a longer notice period." I would like some reviews or feedback on this or is there a better answer to give so that I don't lose much leverage during the interview process. Thanks! P.S. This is for a job in India.
Got a question about First American Corporation?
Ask anonymously on communities.

Interview questions from similar companies

Software Developer Interview Questions & Answers

Tata AIA Life Insurance user image Aditya Gupta

posted on 9 Oct 2023

Interview experience
4
Good
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Sep 2023. There were 4 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 

(1 Question)

  • Q1. Coding ques mid level and project
    • Add your answer
Round 3 - Technical 

(1 Question)

  • Q1. Project discussion
    • Add your answer
Round 4 - HR 

(1 Question)

  • Q1. Hr ques mixed with project
    • Add your answer

Software Developer Interview Questions & Answers

Tata AIG user image Anonymous

posted on 5 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is pointer
  • Ans. 

    A pointer is a variable that stores the memory address of another variable.

    • Pointers are used to access and manipulate memory directly.

    • They are commonly used in programming languages like C and C++.

    • Example: int *ptr; // declares a pointer to an integer variable

    • Answered by AI
    Add your answer

Skills evaluated in this interview

Software Developer Interview Questions & Answers

Tata AIG user image Anonymous

posted on 23 Sep 2023

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Difference b/w map and array in CPP. What are generators in Python. What is Polynomial Regression? Normalisation in DBMS.
  • Ans. 

    Map and array in CPP are both data structures, but map is a key-value pair container while array is a collection of elements with a fixed size.

    • Map in CPP is a container that stores elements in key-value pairs, allowing fast lookups based on keys.

    • Array in CPP is a collection of elements of the same data type, stored in contiguous memory locations.

    • Generators in Python are functions that allow you to iterate over a sequen...

    • Answered by AI
    Add your answer
  • Q2. Realtional Algebra in DBMS
  • Ans. 

    Relational Algebra is a procedural query language used to query databases in DBMS.

    • Relational Algebra is used to perform basic operations like selection, projection, join, etc. on relations.

    • It helps in retrieving specific information from databases based on certain conditions.

    • Examples of operations in Relational Algebra include Union, Intersection, Difference, Cartesian Product, etc.

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Expect that all the questions will be from the resume.

Skills evaluated in this interview

Software Developer Interview Questions & Answers

Gallagher user image Anonymous

posted on 18 Dec 2023

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed in Nov 2023. 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 

(3 Questions)

  • Q1. I am freshers soo please one chance for your company
    • Add your answer
  • Q2. Yes I am fresher soo for your company work
    • Add your answer
  • Q3. Talk about a range of elements, including customer service.
  • Ans. 

    Customer service is an essential element in software development.

    • Customer service involves providing support and assistance to users of software applications.

    • It includes addressing user queries, resolving issues, and ensuring customer satisfaction.

    • Software developers may interact with customers through various channels like email, phone, or live chat.

    • Good customer service can lead to positive user experiences and incre...

    • Answered by AI
    Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - job roles that align with your interests and skills. Networking is also a great way to learn about potential career opportunities.

Software Engineer Interview Questions & Answers

Bajaj Allianz Life Insurance user image Anonymous

posted on 27 Jul 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

General SQL Questions.

Round 2 - HR 

(1 Question)

  • Q1. Salary Negotiation.
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Third-party Payroll.

Software Developer Interview Questions & Answers

ICICI Prudential Life Insurance user image Anonymous

posted on 6 Feb 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Assignment 

Json data based assignment angular

Round 2 - One-on-one 

(1 Question)

  • Q1. Basic technical question based on js angular
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - fine

Salesforce Developer Interview Questions & Answers

PNB MetLife user image Anonymous

posted on 20 Mar 2022

I applied via Walk-in and was interviewed in Feb 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 - Group Discussion 

Sales and Callecshion ke bare me phucha gaya

Interview Preparation Tips

Topics to prepare for PNB MetLife Salesforce Developer interview:
  • Corporate Sales
Interview preparation tips for other job seekers - Sales and collection department

Developer Interview Questions & Answers

SBI Life Insurance Company user image Anonymous

posted on 19 Aug 2021

I applied via Job Portal

Interview Questionnaire 

1 Question

  • Q1. Java ,.net
    • Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of java .net

Developer Interview Questions & Answers

SBI Life Insurance Company user image Peddakotla Indrani

posted on 15 Aug 2023

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

I applied via LinkedIn and was interviewed in Feb 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 - One-on-one 

(1 Question)

  • Q1. Java basics, hashmap, collection
    • Add your answer
Round 3 - Aptitude Test 

General aptitude, code output, MQC

More about working at First American Corporation

First American Corporation Interview FAQs

How many rounds are there in First American Corporation Database Developer interview?
First American Corporation interview process usually has 3 rounds. The most common rounds in the First American Corporation interview process are Resume Shortlist, HR and Technical.

Tell us how to improve this page.

First American Corporation Interviews By Designations

Interview Questions for Popular Designations

Interview Questions from Similar Companies

HDFC Life Interview Questions
3.9
 • 628 Interviews
ICICI Prudential Life Insurance Interview Questions
4.1
 • 395 Interviews
Bajaj Allianz Life Insurance Interview Questions
3.9
 • 335 Interviews
Axis Max Life Insurance Interview Questions
4.1
 • 312 Interviews
SBI Life Insurance Company Interview Questions
3.8
 • 236 Interviews
Gallagher Interview Questions
3.7
 • 223 Interviews
Tata AIA Life Insurance Interview Questions
4.0
 • 175 Interviews
Tata AIG Interview Questions
4.1
 • 159 Interviews
PNB MetLife Interview Questions
3.4
 • 156 Interviews
Reliance Nippon Life Insurance Interview Questions
3.6
 • 138 Interviews
View all

Fast track your campus placements

Chandigarh Engineering College, Chandigarh Placement Questions
1 Interview
View all
First American Corporation Salaries in India
Process Associate
1.7k salaries
unlock blur

₹1 L/yr - ₹4.5 L/yr

Senior Process Associate
688 salaries
unlock blur

₹1.9 L/yr - ₹4.8 L/yr

Senior Software Engineer
305 salaries
unlock blur

₹8.8 L/yr - ₹25 L/yr

Software Engineer
282 salaries
unlock blur

₹4.4 L/yr - ₹19 L/yr

Senior Associate
221 salaries
unlock blur

₹1.8 L/yr - ₹5.4 L/yr

Explore more salaries
Compare First American Corporation with

HDFC Life

3.9
Compare

ICICI Prudential Life Insurance

4.1
Compare

Axis Max Life Insurance

4.1
Compare

Bajaj Allianz Life Insurance

3.9
Compare
Popular Calculators
Are you paid fairly?
Monthly In-hand Salary Calculator
Gratuity Calculator
HRA Calculator
Salary Hike Calculator
Did you find this page helpful?
Yes No
write
Share an Interview