4 Fidelity National Financial Data Engineer Interview Questions & Answers | Complete Prep Guide 2025

Fidelity National Financial Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

Ashwin Raje

posted on 11 Jun 2024

Interview experience

Average

Difficulty level

Process Duration

Result

Not Selected

Round 1 - One-on-one

(4 Questions)

Q1. What is delta lake and its architecture

Ans.

Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.

Delta Lake provides ACID transactions, scalable metadata handling, and unifies streaming and batch data processing.
It stores data in Parquet format and uses a transaction log to keep track of all the changes made to the data.
Delta Lake architecture includes a storage layer, a transaction log, and a metadata l...

Answered by AI

Add your answer

Q2. Activities in ADF

Ans.

Activities in ADF refer to the tasks or operations that can be performed in Azure Data Factory.

Activities can include data movement, data transformation, data processing, and data orchestration.
Examples of activities in ADF are Copy Data activity, Execute Pipeline activity, Lookup activity, and Web activity.
Activities can be chained together in pipelines to create end-to-end data workflows.
Each activity in ADF has prop...

Answered by AI

Add your answer

Q3. Explain mounting process in Databricks

Ans.

Mounting process in Databricks allows users to access external data sources within the Databricks environment.

Mounting allows users to access external data sources like Azure Blob Storage, AWS S3, etc.
Users can mount a storage account to a Databricks File System (DBFS) path using the Databricks UI or CLI.
Mounted data can be accessed like regular DBFS paths in Databricks notebooks and jobs.

Answered by AI

Add your answer

Q4. Difference between Blob storage vs Data Lake

Ans.

Blob storage is for unstructured data, while Data Lake is for structured and unstructured data with metadata.

Blob storage is optimized for storing large amounts of unstructured data like images, videos, and backups.
Data Lake is designed to store structured and unstructured data with additional metadata for easier organization and analysis.
Blob storage is typically used for simple storage needs, while Data Lake is used ...

Answered by AI

Add your answer

Skills evaluated in this interview

Top trending discussions

View All

Interview Tips & Stories

4d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Fidelity National Financial?

Ask anonymously on communities.

Interview questions from similar companies

Software Engineer Interview Questions & Answers

FactSet

SONELAL GUPTA

posted on 11 Sep 2015

Interview Questionnaire

8 Questions

Q1. Find a number which occurs odd number of times and all number occurs even number of times

Ans.

Find an odd occurring number among even occurring numbers.

Use XOR operation to cancel out even occurring numbers and get the odd occurring number.
Iterate through the array and XOR each element with the result variable.
The final result will be the odd occurring number.

Answered by AI

View 1 more answer

Q2. Some discussion about my minor project

Add your answer

Q3. Spiral order of binary tree and mattrix, print it

Ans.

Print the spiral order of a binary tree and matrix.

For binary tree, use level order traversal and alternate direction for each level.
For matrix, use four pointers to traverse in spiral order.
Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9
Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

Answered by AI

Add your answer

Q4. Some question about os,dbms

Add your answer

Q5. Find pair which have a given sum in a given array

Ans.

Finding pairs in an array with a given sum.

Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.
Use a hash table to store the elements of the array and their indices for faster lookup.
If there are multiple pairs with the same sum, return any one of them.
If no pair is found, return null or an empty array.

Answered by AI

Add your answer

Q6. Find total number of k element which have a given avg in a given array in minimum time complexity

Ans.

Find total number of k element with given avg in an array in minimum time complexity.

Use sliding window technique to traverse the array in O(n) time complexity.
Maintain a sum variable to keep track of the sum of elements in the window.
If the sum of elements in the window is equal to k times the given avg, increment the count.
Move the window by subtracting the first element and adding the next element in the array.

Answered by AI

Add your answer

Q7. Print all elements which in not boundary element in a given binary tree

Ans.

Printing non-boundary elements of a binary tree

Traverse the tree in any order (preorder, inorder, postorder)
Check if the current node is not a boundary node (not the first or last node in its level)
If it is not a boundary node, print its value
Recursively traverse its left and right subtrees

Answered by AI

Add your answer

Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Add your answer

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal