- Design, build and enhance the SQL projection broker in DAL(data access layer) for Leto deposits with good performance and scalability
- Design, build and enhance the real-time reporting infrastructure which captures the upstream messages, persists onto NFS storage, and shred attributes into database tables for reporting purpose.
- Enhance and support multiple regulatory/business reports for Leto deposits
- Translate business requirement into queries against a set of relational tables and produce reporting based on the requirements.
- Database and ETL development, including stored procedures, queries, performance tuning etc, using SQL and ETL tools such as Informatica or Python Pandas.
- Create efficient testing automation for Java/Scala/Python processes.
The current global team members are all very skilled in domain modeling, database design, big data, Java and messaging so this is an excellent opportunity to play a key role in the growing team.
- Strong in Java/Scala or other programming languages with 7y+ relevant experience
- Strong with scripting language such as Python and Unix / K-Shell
- Familiar with lifecycle of a trade and flows of data in an investment banking operation is a plus.
- Experienced in Agile development process
- Knowledge on relational databases is a big plus
#J-18808-Ljbffr