Senior ETL Developer
📣 إعلان| نوع العقد | دوام كامل | |
| طبيعة الوظيفة | بالموقع | |
| الموقع | الرياض |
وصف الوظيفة
About the Role
Wipro is seeking a Senior ETL Developer to join their team in Riyadh, Saudi Arabia. This full-time role focuses on the design, development, testing, and maintenance of ETL workflows and mappings, with a primary emphasis on Informatica, OBIEE, and Oracle SQL technologies. The position requires 5-10 years of relevant experience.
Key Responsibilities
The Senior ETL Developer will be responsible for a range of tasks across ETL, reporting, and database management:
- Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter.
- Develop complex mappings utilizing various Informatica transformations such as Source Qualifier, Lookup, Joiner, Aggregator, Expression, Router, Filter, and Update Strategy.
- Create reusable mapplets, workflows, worklets, and sessions.
- Perform performance tuning for mappings, sessions, workflows, and SQL queries.
- Develop and maintain PL/SQL procedures, functions, and SQL scripts.
- Utilize Unix shell scripting for ETL automation and file processing.
- Monitor scheduled workflows and troubleshoot ETL failures.
- Conduct data validation, reconciliation, and data quality checks.
Reporting Responsibilities (OBIEE)
- Create complex analyses, dashboards, prompts, filters, and dashboard pages based on business requirements.
- Perform performance tuning of reports, dashboards, and RPD models.
- Execute repository development, including physical joins, logical joins, dimensions, hierarchies, and measures.
- Develop and maintain dashboard prompts, guided navigation, agents, and BI Publisher reports.
Database Responsibilities (Oracle SQL)
- Develop, write, and optimize complex SQL queries for extracting, transforming, and analyzing large volumes of data.
- Develop and maintain PL/SQL procedures, functions, packages, triggers, and cursors.
- Create and maintain database objects, including tables, views, materialized views, indexes, and sequences.
- Write complex SQL queries using joins, subqueries, analytical functions, and aggregate functions.
- Perform data migration, data transformation, and data validation activities.
- Develop SQL scripts for ETL processes and data warehouse applications.
- Work with large datasets and implement efficient data processing techniques.
Qualifications and Experience
- 5-10 years of experience in ETL development.
- Demonstrated expertise in Informatica PowerCenter.
- Proficiency in OBIEE for reporting and repository development.
- Strong skills in Oracle SQL, PL/SQL, and database object management.
- Experience with Unix shell scripting.
Work Environment
This is a full-time position based in Riyadh, Saudi Arabia. The role involves working within a team focused on data integration and business intelligence solutions.
متطلبات الوظيفة
- تتطلب ٢-٥ سنوات خبرة
وظائف مشابهة
قد يعجبك أيضاً
- وظائف ذات صلة بـ Senior ETL Developer
- وظائف Seller في مكة المكرمة
- وظائف مدخل بيانات في مكة المكرمة
- وظائف Marketing Manager في مكة المكرمة
- وظائف مراقب خدمات عامة في مكة المكرمة
- وظائف مشرف تنظيف وتدبير في مكة المكرمة
- مجالات وظيفية أخرى في الرياض
- وظائف Seller في الرياض
- وظائف مسؤول موارد بشرية في الرياض
- وظائف مدخل بيانات في الرياض
- وظائف أخصائي تغذية سريرية في الرياض
- وظائف Legal Specialist في الرياض
- وظائف Marketing Manager في الرياض
- وظائف Operations Director في الرياض
- وظائف HSE Manager في الرياض
- وظائف مهندس إلكترونيات في الرياض
- وظائف مراقب خدمات عامة في الرياض
- استكشف الوظائف في أنحاء المملكة
- وظائف سائق شاحنة صغيرة في ينبع
- وظائف حارس أمن (سكيورتي) في عفيف
- وظائف Personal Trainer في جدة
- وظائف فني كهربائي تمديدات كهربائية في القصيم
- وظائف موظف استقبال فندق في حائل
- وظائف طبيب أسنان عام في البكيرية
- وظائف مرشد طلابي في المدينة المنورة
- وظائف Legal Specialist في الرياض
- وظائف مراقب مخزون في الجبيل
- وظائف DevOps Engineer في الرياض