ETL Developer

Job Description - Overview:

The ETL (Extract, Transform, Load) Developer designs, develops and supports ETL processes and tools. The ETL Developer is responsible for data loading and manipulation to ensure that the data sources are efficiently and effectively loaded into the data warehouse or data lake. The ETL Developer is responsible for determining the data storage needs of the Department and ensure that the specific business needs are represented. The ETL Developer will have a deep and knowledge of data gathering, analysis, mapping, extraction, transformation and manipulation, cleansing, execution, and loading including experience in data validation by collaboration with clients and in-house Departments.

Key Job Functions and Duties:

· Establish and enforce data warehousing standards to meet requirements and business needs

· Evaluate existing subject areas stored in the data warehouse and determines where data should be stored

· Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts

· Perform quality assurance testing of data integration and report development and monitor data load operations to ensure accuracy

· Analyze data and processes to create automated solution using ETL.

· Develop ETL packages that will read data from different sources which will then be processed

General skills:

· SQL Oracle development experience

· Hands-on experience with NoSQL databases