Lead ETL Designer/Developer
Posted on Jun 29, 2021 by Base 3
This role is inside IR35 for UK applicants.
As Lead Designer-developer, you will:
Lead, draft and document design on Hadoop based on requirements from the business
Need to be able to think of generic ways to build queries, reporting requests to avoid rework in the future
Design dimensional models to meet the business reporting needs
Design the technical ETL solution (define the technical interface, specs for the source systems, the ETL processes from landing zone till storage) and develop the solution with IBM DataStage
Design the physical relational data model in collaboration with the database administrator
Define the scheduling requirements for ETL processes in the data warehouse
Develop & test (unit test, functional test and data profiling) the ETL processes
Prepare the releases & installation instructions
Provide documentation and support the developers
Create best practices
Handle hotline by solving the problems linked to ETL raised by the end users
Find the right balance between cost and quality/completeness while always considering the clients as our priority.
Provides application software development services or technical support typically in a defined project
Develops program logic for new applications or analyses and modifies logic in existing applications
Codes, tests, debugs, documents, implements and maintains software applications
Analyses requirements, and maintains, tests and integrates application components
Undertakes functional and/or technical application designs in the context of projects and/or system maintenance activities. Any designs for particularly critical parts of systems are often submitted to an Application Architect.