Write a SQL query to get top N results and window functions
Engineer Iii Interview Questions
2,122 engineer iii interview questions shared by candidates
1. First technical round 30 mins- Write Cucumber steps Gerkin scenario for Login functionality. I was told to write Gerkin in API style. asked If I know step definitions. SQL question- find the number of employees in each department along with the department code- used aggregate function and joins 2. Second Round Technical 45 mins- Inheritance, abstract vs interface, POST vs PUT, write test cases for registration/account creation- I wrote happy path with lot of different test cases but they said they don't want happy path, what was your test strategy, how did you select 500 counts in Linux from file?, any situation which was your mistake and how did you overcome, SQL question using LIKE operator, Java program where you enter password as string and it should return ***** string.
No arbitrary coding challenges. A couple of in depth technical interviews covering their full tech stack and a couple of behavioral/culture fit typed interviews.
Code Pair: Refactor a python script that uploads blob storage to Azure for AWS. Then refactor a terraform snippet to also include AWS resources.
how would you size a pump. what is your experience in design. what industrial projects have you worked on.
Questions were related to my education, and experience in the resume
write code for fibonacci numbers .
Scenario #2 Email ticket: chat from an email address not listed as the customer’s billing or administrator contact; however, comes from the same domain as all other administrators. marco@acmebilling.com: What the heck... I just received a copy of the last invoice and there was an extra line item on there in the amount of $62.87 for “usage”. We never agreed to pay any more than our $50.00 monthly plan. We never go over our storage quota because our customers upload a bunch of videos each day and then I delete them the next business day. I need to find out why your system incorrectly billed this charge and get a refund for this overpayment. Hint: Check out our Terms of Service to determine our policies regarding providing specific account information versus answering with general information not related to a specific account.
This exercise is scripting/programming language agnostic, you can use any language or method you wish to accomplish the task (even command line curl calls). Please use the following URL to access our older documentation site for more direct guidance on completing the necessary API requests: https://jonroth.hosted-by- files.com/test-documentation/ API Requirements: API Key #1: 37a09903437add1b26a48ad57a84a4965a946ef3813e60a74fc1c86507c75642 API Key #2: ac4446cdf81331341e11478f1566b64c03fbf2de1d846d730c2d0fef41eb4337 Site Subdomain: jonroth Top-Level Folder: cs-test Submission/Upload Folder: cs-test-results Use key #1 to answer these questions: 1. How many items are in the folder, including all items in all subfolders? 2. What is the name and size of the largest subfolder in the top level of the folder the key can access? 3. What is the name and size of the largest file in the subfolder identified in the question above? 4. What is the name of the User who most recently downloaded the file identified in the question above, and when did that user download the file? 5. BONUS QUESTION: What region is the sub-folder found in question number 3 located? Write the answers to these questions in a file named as <yourfirstname- yourlastname>.txt Use key #2 to upload your answer file. Bonus Points: Upload a copy of the script(s) or pseudo code that you used to accomplish this task. This is not to demonstrate coding style, extensive grasp of the programming language, or most efficient use of resources. Rather, this will just allow us to see the approach the applicant took to solving the problem and their default “go-to language” used for testing. Please remember that this is completely language agnostic. Want to use a modern language? Go for it. Want to curl or bash it? No problem. Want to code in Turbo Pascal? Go ahead, and we will bow support@files.com 800.286.8372 in reverence :) Please upload this as a separate file and be sure to include your first and last name as shown in the instructions in the filename for your submission.
¿Cómo podrías optimizar esto para que sea más eficiente?
Viewing 551 - 560 interview questions