- Gathering requirements and analyzing business analyst's needs- Data Lake development over YT (Yandex' in-house BigData Hadoop + Hive + HBase solution) using Map Reduce and Spark transformations- Data Warehouse development (Greenplum)- Data modelling (Data Vault/Anchor)- Integration of Data Warehouses- Performance analysis of queries- Harmonization of requirements (both of technical and business)

- Development and maintenance of corporate data warehouses (Oracle DBMS, Informatica Power Center, ~40TB)- Project planning, including estimating project timelines and risks, and organization of the efficient development process- Communicated with clients on technical aspects of the project- Supporting technical documentation for the project- Complex SQL queries optimizing- Procedures and functions using PL/SQL- Designed and implemented ETL processes using the Informatica Power Center - Developing and refined architectural solutions for new data sources in the data warehouse

- Databases development for new projects and services for the call center(Oracle DBMS)- Gathering regular reports for business- Creating new and modifying existing PL/SQL procedures