Data modeling—star schema data modeling- build out data lakes
Gathering requirements from customers- person is going to need to know functionally how the system works and then the role is working with SMEs on where to pull information from
Need to know – mix of SQL and Oracle – some T-SQL, Oracle Syntax (no PL/SQL)SQL
Familiar with other languages can help
SQL server database understanding
Hands on code development with Python for notebooks