Contract TypeFull-time
Workplace typeOn-site
LocationRiyadh

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