Senior ETL Developer
📣 Job Ad| Contract Type | Full-time | |
| Workplace type | On-site | |
| Location | Riyadh |
Job Description
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.
Requirements
- Requires 2-5 Years experience
Similar Jobs
You may also like
- Related Senior ETL Developer Opportunities
- Seller Jobs in Makkah
- Data Entry Agent Jobs in Makkah
- Marketing Manager Jobs in Makkah
- General Services Controller Jobs in Makkah
- Cleaning and Housekeeping Supervisor Jobs in Makkah
- Other Job Fields in Riyadh
- Seller Jobs in Riyadh
- Human Resources Officer Jobs in Riyadh
- Data Entry Agent Jobs in Riyadh
- Clinical Nutritionist Jobs in Riyadh
- Legal Specialist Jobs in Riyadh
- Marketing Manager Jobs in Riyadh
- Operations Director Jobs in Riyadh
- HSE Manager Jobs in Riyadh
- Electronics Engineer Jobs in Riyadh
- General Services Controller Jobs in Riyadh
- Explore Jobs Across Saudi Arabia
- Quality Controller Jobs in Dammam
- Lifeguard Jobs in Medina
- Sales Representative Jobs in Muhayil
- Brand Manager Jobs in Makkah
- General Services Controller Jobs in Sharurah
- Electrical Engineer Jobs in Al Hafuf
- Radiology Technician Jobs in Jeddah
- Machine Learning Engineer Jobs in Riyadh
- Logistics Services Manager Jobs in Riyadh
- Executive Secretary Jobs in Al Lith