Database and ETL Developer
Role Overview
Responsible for development, design, maintenance of new and existing databases, data streaming solutions and ETL processes. Creates stable and reliable systems and management methods to efficiently access information stored in databases. Work as consultants for other members in the company to improve processes and deliver efficient access to data. Creates data ingestion jobs as well as prepares data layer for analytical purposes.
Primary Objectives
·Design stable, reliable and effective relational and non-relational databases, ETL processes and data streaming solutions
·Performance tuning, optimization and maintenance of data systems
·Modify databases and streaming systems according to specifications and perform tests
·Solve database usage issues and malfunctions
·Liaise with other developers to improve applications and establish best practices
·Gather user requirements and identify new features
·Develop technical and training manuals
·Provide data management support to users
·Ensure all database programs meet company and performance requirements
·Research and suggest new database products, services and protocols
Knowledge & Skills
·Minimum 4 years’ experience in a similar position within a dynamic and fast paced environment
·Proven work experience as a Database and ETL developer
·In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
·Knowledge of software development and user interface web applications
·Hands on experience with SQL
·Familiarity working with Oracle, Big Data tools like Kafka, Hive, Impala, MongoDB, Spark
·Working experience with ETL tools preferably Oracle Data Integrator
·Excellent analytical and organization skills
·An ability to understand front-end users requirements and a problem-solving attitude
·Excellent verbal and written communication skills
·Very good command of English