Etl architect vs data warehouse developer

Differences between etl architect and data warehouse developer duties and responsibilities

Etl architect example responsibilities.

• Manage and execute various BO reporting projects within organization.
• Create a JAVA application to handle the Informatica workflow restart-ability.
• Support migration of ETL code from development to QA and then from QA to production.
• Perform unit testing, negative testing and then hand over the data to QA team.
• Conduct code and performance tuning reviews for AbInitio graphs, UNIX/Perl scripts and PL/SQL store procedures.
• Create PL/SQL packages, procedures and functions to implement the business logic and for history fix.
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