Responsibilities:
• 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.
Must have skills:
• Erwin
• SQL
• Experience on working with relational and other databases.
• Documentation using Confluence and SharePoint
• Collibra
• Deep understanding of Data warehouse, 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
• Good understanding of ETL VS ELT
Any Graduate