Our client is seeking a motivated and detail-oriented Junior/Intermediate ETL & Database Developer to join their team. This role involves building, maintaining, and optimizing ETL workflows and working with databases to ensure efficient data management and transformation. The ideal candidate is eager to learn, has a solid foundation in ETL and database development, and is enthusiastic about working with modern tools and technologies.
Responsibilities:
- Design, develop, and maintain ETL workflows using NiFi or similar tools.
- Write and optimize scripts for data transformation and automation using Python, JavaScript, or Groovy.
- Work with databases such as PostgreSQL or other SQL databases to manage data storage and retrieval.
- Collaborate with team members to understand data requirements and implement solutions.
- Experience working with RESTful API or gRPC.
- Ensure ETL processes are efficient, reliable, and scalable.
- Debug and resolve issues in ETL workflows and database queries.
- Document workflows, scripts, and database structures for maintainability and knowledge sharing.
Required Skills:
- Hands-on experience with NiFi or similar ETL tools (e.g., Talend, Informatica, Apache Hop).
- Proficiency in scripting languages such as Python, JavaScript, or Groovy.
- Solid understanding of relational databases, SQL, and database optimization techniques.
- Basic knowledge of flow-based programming concepts and practices.
- Strong problem-solving and analytical skills.
Nice-to-Have Skills:
- Experience with Linux systems and shell scripting.
- Familiarity with data warehousing concepts and best practices.
- Exposure to modern data pipelines and real-time data streaming tools.
- Knowledge of version control systems like Git.
- NoSQL databases (e.g., Elastic, Accumullo, Redis, Hazelcast)
Desired Skills:
- SQL
- ETL
- NiFi
- Python
- Javascript
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Grade 12 / Matric