Data Analytics Engineer

- 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)
- SQL and PL/pgSQL query optimization
- Dashboard and ETL Result testing and verification (Manual and automation
testing using Apache JMeter, preparing checklists, bug reports, data
mapping, data profiling, test strategy)
- Developing Reports and Dashboards in Power BI Desktop

• Strong knowledge, excellent experience of Creating SSRS /Power BI reports,
excellent DAX language skills such as logic, arithmetic calculations etc.
• Create Airflow ETL DAGs to automate data movement between on-premise
SQL databases into AWS S3 Buckets and Azure Blob Storage.
• Actively participated in interacted with users, team lead, DBAs and technical
manager to fully understand the requirements of the system.