الوصف الوظيفي
The main responsibilities are ETL design and development for the Data Warehouse and Business Intelligence Solutions.
Handle areas related to Metadata/Repository creation and management, Internal database administrator (DBA), Technical/Data architecture, Oracle Business Intelligence, BI client/servers related configuration.
Reports to DWH/BI Technical Lead, interacts with Modeler, QA, IT, Data Analysis, BI Developer, and DWH/BI technical lead and all members of DWH/BI technical and functional teams.
Design ETL processes; Develop default strategies for extracting data, archiving extracted data, policing data quality, dimension change management.
Design strategy to meet availability requirements, Design data auditing subsystem, Design the structure of the ETL staging area.
Develop plan for maintaining dimension hierarchies.
Build dimension table surrogate key management system and the Audit system.
Develop ETL subsystems as architected.
Test historic load and primary dataset for incremental load.
Conduct live tests with real data.
Test all over process, system integration and month-end or unusual conditions.
Inventory metadata elements, locations and relationships.
Educate team on metadata situation and responsibilities.
Identify key elements to manage.
Create systems to capture additional metadata.
Create tools to synchronize metadata.
Design and implement metadata delivery system and Document metadata strategy.
Ongoing metadata management and monitoring.
Inventory metadata elements, locations and relationships.
Populate BI tool metadata; Create business metadata.
Test BI tools, Setup user security and report process metadata system.
Test monitor and tune query performance.
المهارات
Candidates should hold B. Sc. Degree in Computer Science, IT, or Computer Engineering.
7+ years of solid experience in field of Data Warehouse ETL Architect and ETL Development.
Involved in various projects related to reflecting repositories from data modeling and dimensional design, Star Schema.
Linux, Windows, Microsoft SQL Server, Oracle BI technologies, SQL, and PL/SQL.
Dimensional modeling extensive background. ODI (Oracle data integrator) and BI Administrator RPD.
4+ years of solid relevant experience in the field of data warehouse metadata implementation and management.
Database Administrator experience and previous experience in manual ETL/ELT.
Integration and transformation professionalism.
Advance logical, reasoning and conceptual capacity, multi-tasking and overload tolerance.
تفاصيل الوظيفة
منطقة الوظيفة ينبع, المملكة العربية السعودية
قطاع الشركة خدمات الاستشارات التجارية
طبيعة عمل الشركة صاحب عمل (القطاع الخاص)
الدور الوظيفي تكنولوجيا المعلومات
نوع التوظيف دوام كامل
الراتب الشهري غير محدد
عدد الوظائف الشاغرة غير محدد
المرشح المفضل
المستوى المهني متوسط الخبرة
https://www.bayt.com/ar/saudi-arabia/jobs/data-warehouse-etl-architect-developer-3867001/
نسخة للطباعة 
ابلغ عن اعلان مخالف