Wipro

Senior ETL Developer

Riyadh, Saudi ArabiaPosted 4 days ago

Apply link checked 3 days ago

Salary
AED 9k–14k a month· est.
Job type
Full time
Level
Senior
Field
Data & Analytics
Work mode
On site

About the role

Job title: ETL Developer/Consultant Location: Riyadh, Saudi Arabia Experience: 7-10 Years ETL: Informatica Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter. Develop complex mappings using Source Qualifier, Lookup, Joiner, Aggregator, Expression, Router, Filter, and Update Strategy transformations. Develop reusable mapplets, workflows, worklets, and session Perform performance tuning of mappings, sessions, workflows, and SQL queries. Develop and maintain PL/SQL procedures, functions, and SQL scripts. Work with Unix shell scripting for ETL automation and file processing. Monitor scheduled workflows and troubleshoot ETL failures. Perform data validation, reconciliation, and data quality checks. Reporting: OBIEE Create complex analyses, dashboards, prompts, filters, and dashboard pages based on business requirements. Perform performance tuning of reports, dashboards, and RPD models. Perform repository development, including physical joins, logical joins, dimensions, hierarchies, and measures. Develop and maintain dashboard prompts, guided navigation, agents, and BI Publisher reports. Database: Oracle Sql Develop, write, and optimize complex SQL queries to extract, transform, and analyze 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, 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

Requirements

Experience: 7-10 Years

Responsibilities

Design, develop, test, and maintain ETL workflows and mappings using Informatica PowerCenter. Develop complex mappings using Source Qualifier, Lookup, Joiner, Aggregator, Expression, Router, Filter, and Update Strategy transformations. Develop reusable mapplets, workflows, worklets, and session. Perform performance tuning of mappings, sessions, workflows, and SQL queries. Develop and maintain PL/SQL procedures, functions, and SQL scripts. Work with Unix shell scripting for ETL automation and file processing. Monitor scheduled workflows and troubleshoot ETL failures. Perform data validation, reconciliation, and data quality checks. Create complex analyses, dashboards, prompts, filters, and dashboard pages based on business requirements. Perform performance tuning of reports, dashboards, and RPD models. Perform repository development, including physical joins, logical joins, dimensions, hierarchies, and measures. Develop and maintain dashboard prompts, guided navigation, agents, and BI Publisher reports. Develop, write, and optimize complex SQL queries to extract, transform, and analyze 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, 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.

Skills

  • Informatica PowerCenter
  • Oracle SQL
  • PL/SQL
  • UNIX shell scripting
  • OBIEE
  • BI Publisher
  • SQL optimization
  • data migration
  • data quality checks
  • data warehousing
  • SAP or ETL concepts (general)

Not sure you fit this role?

Upload your CV and see how you score against Wipro and every other live job. It's free.

Get my free matches
Data Engineer jobs in Riyadh25 live roles, top employers and pay.See all →

Similar jobs in Saudi Arabia