This role designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support IIG’s Full service and Investments only business with data analytics, reporting, business intelligence, machine learning, data science, and other business interests.Qualifications:
Erwin
SQL
Experience on working with relational and other databases.
Documentation using Confluence, Sharepoint
Collibra
Deep understanding of Datawarehouse, Datamart and Data lake
Good Data Profiling skills
Hands on experience with AWS databases – such as HIVE, Redshift, and Aurora.
Deep understanding of OLTP and OLAP system
Deep understanding of Dimensional Modelling , Star schemas , Snowflake schemas