Data warehouse specialist vs data warehouse developer

Differences between data warehouse specialist and data warehouse developer duties and responsibilities

Data warehouse specialist example responsibilities.

• Lead system maintenance, upgrade, ETL, scheduling, and installation of client software, holding accountability for performance.
• Report procedures against SSAS are constructed and ExcelWriter templates are developed to automate and replace existing manually generate, client-contract reports.
• Determine data extraction and transformation require to support reporting requirements.
• Develop ETL documentation including data flow diagrams, process diagrams, data transformation mapping documentation and business rules.
• Create SSIS packages to upload data to SQL server.
• Design, implement, modify and schedule SSIS packages in SSMS.
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