Data Analytics Engineering
- Strong knowledge of SQL, PL/SQL, PostgreSQL, Microsoft SQL Server- Experience in constructing DWH both 3NF and Star / Snowflake (cleansing and normalizing source data, transformation and loading with PL/SQL.
- Working with business requirements and their clarification
- DB modeling (database model for layer 3 Normal Form, "Star" and Data Marts)
- Building hybrid dwh (by Inmon and Kimball)
- Dashboard and ETL Result testing and verification (Manual and automation testing, preparing checklists, bug reports, data mapping, data profiling, test strategy)
- Developing Reports and Dashboards in Power BI Desktop