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
- وظائف بائع في الدمام
- وظائف فني تبريد وتكييف في الدمام
- وظائف مدير مالي في الدمام
- وظائف مندوب مبيعات في الدمام
- وظائف Receptionist في الدمام
- مجالات وظيفية أخرى في الرياض
- وظائف بائع في الرياض
- وظائف Electrical Engineer في الرياض
- وظائف مضيف (هوست) في الرياض
- وظائف Marketing Manager في الرياض
- وظائف فني تبريد وتكييف في الرياض
- وظائف مدير مالي في الرياض
- وظائف مندوب مبيعات في الرياض
- وظائف AI Engineer في الرياض
- وظائف Receptionist في الرياض
- وظائف Call Center Representative في الرياض
- استكشف الوظائف في أنحاء المملكة
- وظائف أخصائي علوم أحياء دقيقة في حفر الباطن
- وظائف أمين مستودع فني في الدمام
- وظائف عامل نظافة في الدمام
- وظائف Marketing Executive في المدينة المنورة
- وظائف مهندس طرق في تبوك
- وظائف Medical Representative في مكة المكرمة
- وظائف أخصائي تمريض في وادي الدواسر
- وظائف اخصائي نطق وتخاطب في جازان
- وظائف بائع في خميس مشيط
- وظائف مدير أشغال ومرافق عامة في جدة