Data Developer (Snowflake), Stock Exchange

компания "dataart" client this europe-based client is one of the worldchr(39)s most established stock exchanges. this is a new project that just started last month and will last several years. project overview our scope of engagement includes a modern approach to soa, including aws and microservices stack, data warehousing, modern apis, frontend development and other areas. dataart’s specialists focus on data streaming and sourcing solutions to ensure data processing necessary for trading operations. dataart is also engaged in transforming business processes and migrating from on-premise hosting to cloud by re-platforming the entire system and using cloud native technologies. part of the work includes the integration of systems and data related to a new asset class into the customerchr(39)s existing it landscape. team we have several teams with about 100 people total operating from the eu with no overtime work expected. the work is split up into small parts based on priority; after a part is released, the team moves on to the next one. we are using scrum and scaled agile framework for the project. program management, solution architects, and business analysts are involved on the dataart side. technology stack java 1.7-1.8, maven, spring boot/security/data/etc git (bitbucket); database part: snowflake, aws, matillion, python; ui: angular 2+, jsp; aws: anthos/kubernetes, snowflake, matillion, s3, lambda. responsibilities build and maintain various etl processes for the corporate dwh take part in dwh migration from oracle db to snowflake improvement and performance tuning of the existing etl process help with the deployment and support of newly introduced features work with the qa team, bug fixing task estimation requirements 3+ years of experience with dwh strong knowledge of sql and pl/sql experience with snowflake sql queries optimization experience working with dataflows with heterogeneous data sources. solid experience with etl/elt tools or custom pipelines. data warehouse + data modelling principles knowledge is a must. good spoken english nice to have knowledge of aws knowledge of bash scripts experience with matillion, or willingness to learn and work with ability to reverse engineer complex systems ability to work with documentation ability to work with versioning tools (git)