Senior ETL Developer
Role Overview
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 Skills for This Role
Full Job Posting
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.
About Wipro
Wipro is an Indian technology services and consulting company that helps organizations with digital transformation through offerings in cloud, cybersecurity, data and analytics, artificial intelligence, applications, and engineering.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Wipro
PRODUCTION SPECIALIST L3
Greater Noida, IND
ADMINISTRATOR L2(CONTRACT)
Gangtok, IND
APPLICATION ARCHITECT L1(CONTRACT)
Pune, IND
Client Services Executive (12 Months FTC)
Salisbury, GBR
SENIOR ARCHITECT L2
Bengaluru, IND
SuccessFactors COE: Solution Architecture Lead
Bengaluru, IND
DEVELOPER L4(CONTRACT)
, USA
Program Manager
Irving, USA
