Skip to contentSkip to footer

Treasury Analyst Interview Questions

Salaries
Interviews

2,053 treasury analyst interview questions shared by candidates

Question 6: In this exercise VCC payments funded to 3rd party who then processes those payments. The funding happens via an Outgoing Wire transaction from the same account as the SourceAccount for each payment on dbo.Payments. The Outgoing Wire in dbo.DailyBankData will be an aggregated amount of the PaymentAmount by SourceAccount and PaymentDate. How many payments from dbo.Payments were included in each Outgoing Wire, and how many unique OriginatingPaymentNumber records were included in each Outgoing Wire? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), Payments (number of payments), OriginatingPayments (number of unique Originating Payment Numbers Question 7: Using your query from Question 6, please build upon it to answer the following question. What are the PaymentNumbers and PaymentAmounts for the Outgoing Wire that cleared the bank on 3/5/2025? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), PaymentNumber, PaymentAmount
avatar

Treasury operations business analyst

Interviewed at AvidXchange

2.9★
Oct 23, 2023

Question 6: In this exercise VCC payments funded to 3rd party who then processes those payments. The funding happens via an Outgoing Wire transaction from the same account as the SourceAccount for each payment on dbo.Payments. The Outgoing Wire in dbo.DailyBankData will be an aggregated amount of the PaymentAmount by SourceAccount and PaymentDate. How many payments from dbo.Payments were included in each Outgoing Wire, and how many unique OriginatingPaymentNumber records were included in each Outgoing Wire? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), Payments (number of payments), OriginatingPayments (number of unique Originating Payment Numbers Question 7: Using your query from Question 6, please build upon it to answer the following question. What are the PaymentNumbers and PaymentAmounts for the Outgoing Wire that cleared the bank on 3/5/2025? Please include the following fields: BankDate, TransactionId, Account (DailyBankData), Amount (DailyBankData), PaymentNumber, PaymentAmount

Viewing 1871 - 1880 interview questions

Glassdoor has 2,053 interview questions and reports from Treasury analyst interviews. Prepare for your interview. Get hired. Love your job.