-
The ETL Developer is responsible for performing system development work around ETL, which can include both the development of new function and facilities and the on-going systems support of live systems. There are a number of job functions within the role and the job holder may specialize in a single function or alternatively a combination of functions.
-
The role involves taking instructions, usually in written or diagrammatic form, and translating them into a code.
-
Determine the optimal approach for obtaining data from diverse systems and moving it to the BI.
-
Prepare all ETL processes according to business requirements.Responsible for creating functional and/or technical design solutions and ensuring those requirements are documented.
-
Diagnose ETL and database related issues, perform root cause analysis and recommend corrective actions to management. Responsible to perform tests and validate the data flow
-
Manage current and future needs of the data design and content.
-
Consults with users to resolve issues with programs. Contributes to the development of project plans and timelines, provide estimates for planned work.
-
Work with a project team to support the design, development, implementation, monitoring, and maintenance of new ETL programs.
-
Responsible for the documentation, coding and maintenance of new and existing Extract, Transform, and Load (ETL) processes within the Enterprise Data Warehouse.
-
Investigate live systems faults, diagnose problems and propose and provide solutions
-
Report progress as required and advise of problems in good time
-
Convert requirements into sustainable technical solution through coding best practices.
-
Write, analyze, review, and rewrite programs to departmental and Group standards
-
Compile and write documentation of program development and subsequent revisions, inserting comments in the coded instructions so others can understand the program
-
Update programs to increase operating efficiency or adapt to new requirements
-
Review code and documentation to ensure code meets the design criteria and work is of an acceptable quality
-
Review code from team members Analyst/Developers as part of the quality assurance process
-
Produce unit test plans with detailed expected results to fully exercise the code
-
Correct errors by making appropriate changes and then rechecking the program to ensure that the desired results are produced
-
Conduct unit testing of programs and software applications to be sure they will produce the desired information and that the instructions are correct
