JOB DESCRIPTIONS
๐ฅ๐ฒ๐พ๐๐ถ๐ฟ๐ฒ๐บ๐ฒ๐ป๐๐
- Design, develop, and implement ETL processes to extract data from diverse sources, transform it according to business requirements, and load it into databases.
- Collaborate with Project Managers to understand data requirements and design the procedures.
- Execute data assessments and migrations for customers assigned to you.
- Write complex SQL queries, stored procedures, and scripts to manipulate and cleanse data during the ETL process per client's expectations.
- Optimize ETL workflows for performance, scalability, and reliability, ensuring efficient data extraction, transformation, and loading.
- Conduct thorough testing and validation of ETL processes to ensure accuracy, completeness, and data integrity.
- Troubleshoot and resolve issues related to data quality, performance, and ETL failures in a timely manner.
- Document ETL processes, data mappings, and technical specifications to facilitate knowledge sharing and ensure maintainability.
๐๐ฒ๐๐ถ๐ฟ๐ฒ๐ฑ ๐ฆ๐ธ๐ถ๐น๐น๐ ๐ฎ๐ป๐ฑ ๐๐ ๐ฝ๐ฒ๐ฟ๐ถ๐ฒ๐ป๐ฐ๐ฒ
- Strong experience with ETL and database technologies
- In depth experience with MS SQL Server, incl. SQL Server Management Studio Superior SQL knowledge (stored procedures, user defined functions, etc.) as well as an intimate understanding of database structure
- Familiarity with an IDE and a version control management tool, preferably Visual Studio, Azure DevOps and Git
- Knowledge of various SQL/NoSQL data storage mechanisms
- Nice to have knowledge with scripting and programming, including SQL, shell scripting, or Python
- Ability to adapt to a rapidly changing product and respond strategically to customer needs, and work in a fast-paced environment
Salary
Competitive
Monthly based
Location
, East Gonja Municipal District, Savannah Region, Ghana, Savannah Region, Ghana
Job Overview
Location
, East Gonja Municipal District, Savannah Region, Ghana, Savannah Region, Ghana