Senior ETL Developer
-
Software Development
Job Description & How to Apply Below
Design, develop, test, and maintain ETL workflows and mappings using Informatica Power Center.
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
Position Requirements
10+ Years work experience(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction