What is BI and ETL programer responsibility in data wharehou

What is BI and ETL programer responsibility in data wharehouse project process?

Solution

The roles of BI in datawarehouse project would involve understanding of business requirements gather the information and pass on the information to the team. Involving interviewing task, documentation, assist the data analyst in order to help get the reports analysis done and identify matrix like business metrics. The role also includes determining the systems of record and help to find out potential sources of data for the system. It also includes being a consultant to ETL and front end programmers.

The roles of ETL programmer or developer includes designing, creating data warehouse and all related activities like extraction, transformation and load of data functions. Once the ground level work is done they need to test the designs to make sure that system will be up and running without any hassles. It also requires them having the level of maturity to understand a wider picture. The programmer should be able to analyse what business need we are fulfilling with the data and accordingly design best possible ETL process around those goals.