About the role
Responsibilities
- Contribute to the design and development of a Data Warehouse based on Oracle Database 19c Enterprise Edition.
- Develop scalable, efficient, and maintainable PL/SQL code for data movement, transformation, and reporting.
- Implement complex reporting solutions in areas such as Risk, Finance, and Regulatory reporting.
- Collaborate with business users to understand requirements, workflows, and data needs.
- Refactor and enhance legacy systems to improve scalability, performance, and maintainability.
- Write clean, reliable code following company's best practices and development standards.
- Optimize SQL and PL/SQL code, leveraging advanced Oracle features like parallel queries, partitioning, compression, and analytical functions.
- Tune database/query performance using tools such as ASH and Real-Time SQL Monitoring.
- Support data modeling activities using techniques such as Kimball, Data Vault, or 3NF.
- Work in an agile, collaborative environment, contributing to design reviews and mentoring junior developers.
Requirements
- 5+ years of experience in Oracle SQL and PL/SQL development.
- Strong understanding of data modeling for data warehouses, including dimensional modeling and normalization techniques.
- Deep knowledge of advanced SQL concepts, including analytical functions, hierarchical queries, complex joins, partitioning, and parallel execution.
- Hands-on experience in performance tuning and troubleshooting using Oracle diagnostic tools (e.g., ASH, AWR).
- Strong problem-solving skills with the ability to develop creative and scalable solutions.
- Proactive and independent working style with high attention to detail.
- Fluency in English with excellent communication and collaboration skills.
- Experience in the financial or insurance industry is a strong advantage.
- Working knowledge of Git version control systems is a plus.
- Proficiency in Python programming language is a plus.
- Developing web-applications using Oracle Application Express considered a plus.
- Solution-driven mindset and interest in investment banking and derivative financial products.
About the company
Our client is fintech company with a leading marketplace for structured investment solutions.
Your recruiter
Aline, Senior Talent Acquisition Specialist @ Effitalents.
Feel free to contact her for more information!