Name a time when you helped someone, what did you do? How did you do it? Who was involved? What was the outcome? And what did you learn from that outcome that caused you to grow as an individual.
Treasury Analyst Ii Interview Questions
7 treasury analyst ii interview questions shared by candidates
Tell me about Yourself. What’s your understanding of SLR? What’s the resolution and recovery process like?
BQ, Tech, go through resume
What make you a good fit for this role? What are your expectations from this job?
Question 1: What is the of sum of Amount for each BankDate, Account, and TransactionName in dbo.DailyBankData? Please order results by Account. Question 2: The ACH Credit records on 3/3/2025 and 3/4/2025 represent funding coming in from our customers to make payments on their behalf – multiple payment records are included a single ACH Credit and based on the designated “SourceAccount” field on dbo.Payments. The funding in this exercise will appear in the dbo.DailyBankData table on the following date from the PaymentDate in dbo.Payments. What records from the dbo.Payments table were part of the ACH Credit with TransactionId = 21117008? Please show the PaymentDate, PaymentNumber, Type, and PaymentAmount in your results. Question 3: The ReferenceNumber field on dbo.DailyBankData represents the check number, if applicable, for the clearing event. Which payments with a Type of Check, based on the dbo.DailyBankData table are still outstanding and have not cleared? Please show the following fields in your results: PaymentDate, PaymentNumber, CheckNumber, PaymentAmount, SourceAccount. Question 4: Which payments share the same CheckNumber in the dbo.Payments table? In your results, please show PaymentDate, PaymentNumber, Type, SourceAccount, PaymentAmount, and CheckNumber Question 5: Using your query from Question 4, please build upon it to answer the following question. What date did these checks for these payments clear in dbo.DailyBankData? In your results, please show PaymentDate, PaymentNumber, Type, SourceAccount, PaymentAmount, CheckNumber, and BankDate. Question 6: In this exercise VCC payments funded to 3 rd 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
UNEXPECTED QUESTION: The interviewer was continuously asking for my travel experience (how much travel I do) with the current job, however in their JD it was clearly mentioned that the job requires travel "rarely".
Not applicable since recruiter never joined call.
Viewing 1 - 10 interview questions
See interview questions for similar jobs
Senior Treasury AnalystTreasury AnalystTransfer AgentTreasury Sales AnalystTreasury Management Sales AnalystSenior Manager TreasuryTreasury Services AnalystTreasury Sales OfficerHead Of TreasuryManager, TreasuryInternational Treasury ManagerManager Treasury OperationsTreasury Risk AnalystTreasury Management Sales OfficerTreasury SpecialistTreasury AssociateTreasury VpSr. Treasury Analyst