OLAP, DWH Oracle Developer. in 4Team

Direct message the member who posted the job with 4TEAM Inna Zatieeva Inna Zatieeva IT Recruiter/HR Manager A company specializing in the development of a crypto-algorithmic trading platform and one of the top 50 Binance traders on futures instruments is looking for a DWH Oracle Developer to join its professional team. Required skills: Strong knowledge of denormalized data models Organization and support of DWH, understanding of segmentation Understanding of relational databases , normalization, package integrity, etc. Oracle Advanced Queuing debugging All kinds of application skills connections and deep knowledge of PL/SQL. Accuracy in writing code in accordance with Company standards. Application of various approaches to code optimization, working with a query plan. Basic DBA skills. Experience in building OLAP systems will be a plus. Main tasks: Work with SQL, Oracle PL/SQLETL of stock data, Writing SQL scripts of varying degrees of complexity Designing denormalized data models Work with large volumes of data (billion records) Construction of data showcases, materialized representations, etc. Optimization of requests and their adaptation to the load Data migration, work with the MQ transport layer Development and support of reporting systems Show more Show less Position level Basic level Type of employment Full time Job duties Information technologies Industries Human resources