Ms sql developer vs data warehouse developer

Differences between ms sql developer and data warehouse developer duties and responsibilities

Ms sql developer example responsibilities.

• Design dynamic DTS packages to transfer data between servers, load data into database and achieve data file from different DBMS.
• Create reports using SSRS from OLTP and OLAP data sources and deploy on report server.
• Create reports from OLAP, sub reports, bar charts and matrix reports using SSRS.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also work on integration of SharePoint with SSRS.
• Extract, clean, and validate data from XML file into database using XML source.
• Post HTML files to server and update database and return the response back to ASP.NET.
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