Skip to contentSkip to footer

Treasury Coordinator Interview Questions

Salaries
Interviews

1,632 treasury coordinator 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 1451 - 1460 interview questions

Glassdoor has 1,632 interview questions and reports from Treasury coordinator interviews. Prepare for your interview. Get hired. Love your job.