Datastage developer vs data warehouse developer

Differences between datastage developer and data warehouse developer duties and responsibilities

Datastage developer example responsibilities.

• Create and manage multiple development and test database environments, often work as a backup DBA.
• Experience using peek stage by the means of outsourcing data to the job log which leads to debugging of jobs.
• Manage continuous integration, configure the servers using Jenkins.
• Involve in SQL & PL/SQL programming for procedures, functions, packages to extract data from various source systems.
• Identify business rules for data migration and perform data administration through data models and metadata.
• Involve in implementation of UNIX shell scripts to copy files among different servers and to invoke PL/SQL scripts, DataStage jobs.
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