Reports developer vs data warehouse developer

Differences between reports developer and data warehouse developer duties and responsibilities

Reports developer example responsibilities.

• Work with dynamic T-SQL queries, DDL, DML statements for creating objects, making updates and managing user permissions.
• Used Java script to perform checking and validations in the JSP pages.
• Create different types of reports including: standard, cross-tab, conditional, dynamic, and integrate sub-reports.
• Involve in writing database scripts, SQL, PL/SQL, store procedures, packages, triggers and testing them.
• Work closely with customer/end users to design table relationships and metadata models.
• Define and document business logic and develop custom SQL for ETL source-to-target mappings.
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