Fidelity National Financial Senior Engineer Interview Questions and Answers

Q1. Project related
Add your answer

Q1. Scenario based question on kafka
Add your answer

Some basic aptitube and reasoning problems were asked. Easily solvable.

They asked multiple choice questions on oracle sql and pl/sql emphasizing more on reading a code block ask output questions. These were of medium hardness.

Q1. They asked what you do on daily basis in your work. What is most complex thing you have implemented and some complex questions on multilevel plsql collection module. It lasted for 1.5 hrs
Add your answer

Q1. Questions regarding Oracle architecture and its component
Add your answer
Q2. Question on live implementation of multilevel collection, bulk collect and record limiting and bulk exception handleing.
Add your answer
Q3. Dml error logging functionality
Ans. 
DML error logging functionality allows for capturing errors during data manipulation language operations.
• DML error logging can be enabled at the table level using the LOG ERRORS clause in DML statements.

• It helps in identifying and resolving data issues without causing the entire transaction to fail.

• Errors are logged in a separate error table, allowing the main operation to continue processing.

• Example: INSERT INTO table...read more
Answered by AI
Add your answer
Q4. Query and join optimization
Add your answer

Q1. Related to salary and what benefits they provide.
Add your answer

Q1. Hadoop basics on computing
Add your answer
Q2. Distribution basics for processing the data
Add your answer

Q1. Architecture of bigdata systems
Ans. 
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
• Utilize distributed file systems like HDFS for storage

• Use parallel processing frameworks like Apache Spark or Hadoop for data processing

• Implement data pipelines for ETL processes

• Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying

• Consider data partitioning and replication for fault tole
Answered by AI
Add your answer
Q2. How will the bigdata system distribution for storage andcompute happen
Ans. 
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
• Data is partitioned across multiple nodes to distribute storage and processing load.

• Hadoop Distributed File System (HDFS) is commonly used for storage distribution.

• Apache Spark utilizes a cluster computing framework for distributed computing.

• Data locality is important to minimize data transfer ...read more
Answered by AI
Add your answer

Q1. 1. Tell me about Python OS module. 2. What is Anachron? 3. What is the difference between Dynamic and Static website? 4. How will you clone a particular branch? 5. How will you handle exceptions in Ansible...read more
Ans. 
Technical interview questions for Senior Engineer position
• Python OS module provides a way of interacting with the operating system

• Anachron is a tool for scheduling periodic jobs

• Dynamic websites generate content on the fly while static websites serve pre-built content

• To clone a particular branch, use the git clone command followed by the branch name

• Exceptions in Ansible can be handled via the 'ignore_errors' parameter i...read more
Answered by AI
Add your answer

Medium leetcode question on array list

Q1. Core java and collections, exceptions and threading
Add your answer
Q2. Core java collections
Add your answer
Q3. Multi threading
Add your answer
Q4. Executor framework
Add your answer

Q1. Threading related questions
Add your answer

1 coding question based on DP for 25 minutes and 30 MCQs on Java , OOPS and code snippet questions also some basic questions based on trees like number of leaf nodes in a complete binary tree with n nodes.

Q1. Write code for finding palindrome of a string
Ans. 
Code to find palindrome of a string
• Iterate through the string from both ends and compare characters

• Use two pointers, one starting from the beginning and one from the end

• If characters at both pointers match, continue checking until they meet in the middle

• If all characters match, the string is a palindrome
Answered by AI
Add your answer
Q2. What is dynamic memory allocation in Java
Ans. 
Dynamic memory allocation in Java refers to the process of allocating memory for objects at runtime.
• Dynamic memory allocation allows for objects to be created and destroyed during program execution.

• The 'new' keyword is used to dynamically allocate memory for objects in Java.

• Dynamic memory allocation helps in managing memory efficiently by allocating memory only when needed.

• Example: int[] arr = new int[5]; dynamically a
Answered by AI
Add your answer
Q3. You are designing an e commerce website which database will you choose and what will you use for authentication given that you can't use JWT or even third party like Google authentication
Ans. 
I would choose a relational database like MySQL and implement a custom authentication system using session management.
• Choose a relational database like MySQL for storing user data, product information, and orders.

• Implement a custom authentication system using session management to securely authenticate users without JWT or third-party services.

• Use encryption techniques to store and validate user passwords securely.

• Util...read more
Answered by AI
Add your answer

Q1. What is the difference between normal and arrow functions
Ans. 
Arrow functions are more concise and have a lexical 'this' binding compared to normal functions.
• Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.

• Arrow functions do not have their own 'arguments' object.

• Arrow functions cannot be used as constructors with 'new'.

• Arrow functions are more concise and have implicit return when no curly braces are used.
Answered by AI
Add your answer
Q2. All basic JS Questions to cover Hoisting closure
Add your answer
Q3. They asked to show me an example using the API call
Add your answer
Q4. Difference between forEach and Map
Ans. 
forEach is used to iterate over an array and perform a function on each element, while map creates a new array by applying a function to each element.
• forEach does not return a new array, while map does

• forEach does not modify the original array, while map creates a new array

• forEach is used for side effects, while map is used for transformation

• Example: forEach - array.forEach(item => console.log(item)), map - const newAr
Answered by AI
Add your answer

Q1. Find the character with the maximum frequency
Ans. 
Iterate through each character in the array of strings and keep track of the frequency of each character. Return the character with the maximum frequency.
• Create a dictionary to store the frequency of each character

• Iterate through each string in the array and then through each character in the string

• Update the frequency count of each character in the dictionary

• Return the character with the maximum frequency
Answered by AI
Add your answer
Q2. Valid parenthesis
Add your answer

Q1. Have you used Junit? What is the difference between SQl and NoSQl Databases? have you worked with Kafka? Kafka based questions. explain dockerization/ containerization. which java8 feature did you work wit...read more
Ans. 
Yes, I have experience with Junit, SQL and NoSQL databases, Kafka, Dockerization, Java 8 features, stream() operations, and shell scripting in Unix.
• I have used Junit for unit testing in Java projects.

• SQL databases are relational databases that use structured query language for data manipulation, while NoSQL databases are non-relational databases that provide flexible schema design and horizontal scalability.

• I have work...read more
Answered by AI
Add your answer

Q1. What is the most complex sql query you have written till date. Why did you use nested query to achieve your goal? explain the query. which join did you use in the query. have you implemented hashset? how w...read more
Ans. 
The most complex SQL query involved nested queries for data manipulation. Used inner join. Implemented hashset and avoided trees due to their drawbacks.
• Nested SQL query used for complex data manipulation

• Inner join used for combining data from multiple tables

• Implemented hashset for efficient data storage and retrieval

• Avoided trees due to their drawbacks such as unbalanced structure and slower traversal times
Answered by AI
Add your answer
Q2. Find and replace words in a file using shell scripting. add an index in the beginning of each line in a file using shell scripting. what is multithreading? difference between single threaded and multithrea...read more
Ans. 
Shell scripting for find and replace, adding index to lines, multithreading, hashmap vs hashtable, stack vs queue
• Use sed command for find and replace in shell scripting

• Use awk command to add an index at the beginning of each line in a file

• Multithreading is the ability of a CPU to execute multiple threads concurrently

• Single threaded means only one thread is executed at a time, while multithreaded allows multiple threads...read more
Answered by AI
Add your answer

Q1. Behavioral questions- tell me about yourself. do you have any questions for us?
Add your answer