Description
We are looking for a Java/Scala Developer to join a dynamic team at an investment bank. The successful candidate will be responsible for designing, developing, and improving various components of the data mart and reporting infrastructure.
The team is responsible for developing the firm's strategic data mart for ISG deposits, which involves sourcing data from the golden source and DAL, and feeding it into the data mart in real-time. The data will then be made available through a consolidated interface, allowing downstream systems to extract reports easily.
The ideal candidate will have strong skills in Java, Scala, or other programming languages, with at least 3-5 years of relevant experience. They should also have experience with scripting languages such as Python and Unix/K-Shell, as well as knowledge of relational databases and Agile development methodologies.
Responsibilities:
- Design, build, and enhance the SQL projection broker in DAL for Leto deposits with good performance and scalability.
- Design, build, and enhance the real-time reporting infrastructure which captures upstream messages, persists onto NFS storage, and shreds attributes into database tables for reporting purposes.
- Enhance and support multiple regulatory/business reports for Leto deposits.
- Translate business requirements into queries against a set of relational tables and produce reporting based on the requirements.
- Participate in 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 team uses an Agile methodology based on Scrum, Kanban Jira Boards, and XP best practices. The candidate should be able to work collaboratively within a larger team and have excellent communication skills.
At mthree, we value diversity and promote a strong culture of equality and inclusion. We offer a range of services, including consulting and advisory, managed services, and training programs.