Business intelligence developer vs data warehouse developer

Differences between business intelligence developer and data warehouse developer duties and responsibilities

Business intelligence developer example responsibilities.

• Used TFS for managing versions of the code with in the development team.
• Develop VBA base application to automate testing of report output and test scenarios.
• Manage security privileges for each subject area and dashboards according to user requirements.
• Develop various T-SQL store procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
• Develop QlikView dashboards using drill down and cyclic grouping and also using input field, table box, list boxes etc.
• Introduce use of statistics, regression, supervise and unsupervise predictive analytics and visualization.
Show more

Data warehouse developer example responsibilities.

• Help in set up the SharePoint server, deploy reports and create, manage subscriptions and data driven subscriptions.
• Achieve significant performance improvement in reducing response time of queries by rewriting and tuning SQL statements embed in PhP code.
• Develop MapReduce jobs in Java API to parse the raw data and store the refined data.
• Shell scripting, Linux administration, and Perl language support.
• Develop, modify and execute Perl and MySQL scripts from Linux command line.
• Liaise with QA in deploying ETL flows and reports into their environments and attend defect calls.
Show more