Senior Data Engineer, Data Platform, OAL

Oracle

Given an unsorted array of integers, find the length of the longest increasing subsequence. For example: Input:** [10, 9, 2, 5, 3, 7, 101, 18] Output:** 4 Explanation:** The longest increasing subsequence is [2, 3, 7, 101], therefore the length is 4. Another example: Input:** [0, 1, 0, 3, 2, 3] Output:** 4 Explanation:** One longest increasing subsequence is [0, 1, 2, 3]. Constraints: The array can contain duplicate numbers. The numbers are not necessarily positive. They can be negative or zero. Your solution should be as efficient as possible. Could you describe your approach and implement the solution? Consider the time and space complexity of your solution. In the first example, [10, 9, 2, 5, 3, 7, 101, 18], a longest increasing subsequence is [2, 3, 7, 18]. Note that subsequences are not required to be contiguous. Another longest increasing subsequence is [2, 5, 7, 101]. It is important to understand what increasing means. The numbers must be strictly increasing (e.g., 2, 3, 7 is increasing, but 2, 2, 7 is not). Another important point to note is that there may be multiple longest increasing subsequences, but your function should return the length of such a subsequence, not the subsequence itself.

Oracle

Let's design a URL shortening service like bit.ly. Consider the following: Functional Requirements: The service should accept a long URL and generate a unique short URL. Users should be able to access the original URL by visiting the shortened URL. The service should track click statistics for each shortened URL. Non-Functional Requirements: The service should be highly available and scalable to handle a large number of URL shortening and redirection requests. Shortened URLs should be generated quickly. The system should be fault-tolerant. Considerations: How would you handle URL collisions (when the same short URL is generated for different long URLs)? How would you design the data storage? How would you optimize the system for read-heavy traffic (redirections)? How would you implement analytics and track clicks? Explain the architectural components, data model, algorithms, and scaling strategies you would use to build such a system. Provide specific examples for URL encoding and decoding. For example, how would you encode https://www.example.com/very/long/url/path into something like bit.ly/xyz123?

Oracle

Okay, let's imagine we're at a career fair, and you have about two minutes to introduce yourself to a recruiter. Keeping that timeframe in mind, could you provide a concise overview of your background, skills, and career aspirations? Think of it as your elevator pitch. For example, you might highlight your key accomplishments from previous roles, discuss your proficiency in specific programming languages or technologies relevant to the target position, and briefly touch upon your career goals and what you're hoping to achieve in your next role. What makes you a great candidate?