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 matchesAED 9k–14k a month· est.
Similar jobs in Saudi Arabia
Senior Data Integration Developer (Informatica)
TAWANTECHRiyadh, Saudi Arabia
AED 25k–41k a month· est.
Talend Developer - SSRS & Power BI
Systems ArabiaRiyadh, Saudi Arabia
AED 10k–18k a month· est.
Oracle PL/SQL Developer (Saudi national)
PROVENRiyadh, Saudi Arabia
AED 14k–18k a month· est.
Data, Senior Engineer
Master WorksRiyadh, Saudi Arabia
AED 16k–22k a month· est.
Microsoft SSIS senior Developer
Tata Consultancy ServicesJeddah, Saudi Arabia
AED 12k–18k a month· est.
Oracle EPM Techno Functional Consultant || Saudi Arabia (Only local) || 7+ years
CognitudRiyadh, Saudi Arabia
AED 12k–18k a month· est.