Good understanding on conceptual, logical and physical data model Strong data warehousing concepts. Knowledge of working on relational and dimensional modeling. Hands on DM tool preferably ERwin Hands on with SQL and good experience on various DBs Knowledge on cloud preferably AWS Knowledge on modern DWH concepts such as Data lakes, Data vault is plus