Etl lead vs data warehouse developer

Differences between etl lead and data warehouse developer duties and responsibilities

Etl lead example responsibilities.

• Manage the issues raise from QA and assign work items to the team and take up critical work items.
• Lead defect review meetings with business team leads as well as QA lead and prioritize development tasks around project milestones.
• Involve in writing UNIX shell scripts and automate the sessions running processes and also write UNIX Perl scripts for business needs.
• Provide technical leadership and manage all aspects of the SDLC process-requirement analysis, design, development, testing, and support/maintenance.
• Administrate SharePoint database access; manage classified documents and applications.
• Involve in writing TeraData scripts.
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