Fractal Analytics Interview Questions, Process, and Tips

Q1. Tell me about your self
Add your answer
Q2. Tell me about family
Add your answer

Q1. Tell me accounts payable process?
Ans. 
Accounts payable process involves receiving, verifying, and processing invoices for payment.
• Receive invoices from vendors

• Verify the accuracy of invoices against purchase orders and receipts

• Code and enter invoices into accounting system

• Obtain approval for payment

• Schedule payments and issue checks or electronic payments

• Reconcile vendor statements

• Maintain accurate records and files
Answered by AI
Add your answer
Q2. Explain Invoices and its process.
Ans. 
Invoices are bills sent by a vendor to a customer for goods or services provided.
• Invoices include details such as the vendor's name and address, the customer's name and address, the date of the invoice, a description of the goods or services provided, and the amount due.

• The process of invoicing involves creating and sending the invoice to the customer, tracking the payment status, and following up on any overdue paymen...read more
Answered by AI
Add your answer

Q1. Explain prepaid expenses
Ans. 
Prepaid expenses are payments made in advance for goods or services that will be received in the future.
• Prepaid expenses are recorded as assets on the balance sheet

• They are gradually expensed over time as the goods or services are received

• Examples include prepaid rent, insurance premiums, and subscriptions

• Prepaid expenses are commonly used in accounting to ensure accurate financial reporting
Answered by AI
Add your answer
Q2. Journal entries for transactions
Add your answer
Q3. Documents for foreign remittance
Ans. 
Documents required for foreign remittance include invoices, purchase orders, and wire transfer instructions.
• Invoices for goods or services being paid for

• Purchase orders to verify the transaction

• Wire transfer instructions to ensure proper routing of funds

• Proof of identification for both parties involved

• Any necessary customs or tax documents

• Documentation of any applicable fees or charges
Answered by AI
Add your answer
Q4. Elaborate Cash flow statement.
Ans. 
Cash flow statement is a financial report that shows the inflow and outflow of cash in a business over a period of time.
• It shows the sources of cash inflow and the uses of cash outflow.

• It is divided into three sections: operating activities, investing activities, and financing activities.

• Operating activities include cash transactions related to the day-to-day business operations.

• Investing activities include cash transa...read more
Answered by AI
View 1 more amswer

They give you SQL assignment to complete based on that select for technical interview

Q1. What are window functions in SQL
Ans. 
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
• Window functions are used to calculate values based on a set of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Answered by AI
Add your answer
Q2. Difference between group by and distinct
Ans. 
Group by is used to group rows that have the same values into summary rows, while distinct is used to remove duplicate rows from a result set.
• Group by is used with aggregate functions like COUNT, SUM, AVG, etc.

• Distinct is used to retrieve unique values from a column or set of columns.

• Group by is used to perform operations on groups of rows, while distinct is used to filter out duplicate rows.

• Group by is used in conjunc...read more
Answered by AI
Add your answer

Medium to difficult level

Q1. -----------SQL BASED
Add your answer
Q2. ------EXPERIENCE BASED
Add your answer

Q1. Culture fit check
Add your answer
Q2. Behavioral questions
Add your answer

Q1. Interviews question about adf adls gen2 ,databricks and experience
Ans. One might ask you on how can one configure these
Answered Anonymously
Add your answer
Q2. Transformations in databricks
Ans. 
Transformations in Databricks involve manipulating data using functions like map, filter, reduce, etc.
• Transformations are operations that are applied to RDDs in Databricks

• Common transformations include map, filter, reduce, flatMap, etc.

• Transformations are lazy evaluated and create a new RDD

• Example: map transformation to convert each element in an RDD to uppercase
Answered by AI
Add your answer
Q3. Concepts in spark
Ans. 
Spark is a distributed computing framework for processing big data.
• Spark is built around the concept of Resilient Distributed Datasets (RDDs)

• It supports various programming languages like Scala, Java, Python, and R

• Spark provides high-level APIs like DataFrames and Datasets for structured data processing

• It includes libraries for SQL, streaming, machine learning, and graph processing

• Spark can run on various cluster manag
Answered by AI
Add your answer

Q1. In depth discussion on projects
Add your answer
Q2. Performance enhancemnets in pyspark
Ans. 
Performance enhancements in PySpark involve optimizing code, tuning configurations, and utilizing efficient data structures.
• Use partitioning to distribute data evenly across nodes

• Cache intermediate results to avoid recomputation

• Optimize joins by broadcasting smaller tables

• Use efficient data formats like Parquet or ORC

• Tune Spark configurations for memory and parallelism
Answered by AI
Add your answer
Q3. Data handling and data quality
Add your answer

It was through a link they share and you need to write and submit your code, no execution needed.

Q1. R1 was about 40 mins and was a bit tough. Asked more about ADF, ADB, SQL, SQL DW
Add your answer

Q1. R2: Was the toughest, asked for 40 mins and more than 30 questions were asked, lucky enough to answer all of them.
Add your answer

Q1. Some Managerial questions for 30mins, handling conflicts, leadership skills etc
Add your answer

Q1. Asked why I want to join fractal, why looking for other offer, biggest achievement etc
Add your answer

Aptitude is the most difficult test with questions in DI/LR section being on CAT level. Second section involved three python questions and three SQL questions which were not mandatory to solve.

Was asked about my Resume, some guesstimates, puzzles and case study based single question

Another similar around like Round 2

Q1. Top things you learnt during COVID times
Add your answer
Q2. How does your day-to-day life look like
Add your answer