Description

You will design and implement data warehouse subject areas using PL/SQL on a Linux-based Oracle 11g RAC environment.

This role is on-site.

Responsibilities

• Design and implement data warehouse subject areas using hands-on PL/SQL.
• Develop high-performing ETL routines to load data from production databases into the warehouse.
• Write scalable PL/SQL code that performs efficiently with large datasets and adheres to business rules.
• Integrate new lines of business by adding new data sources into existing tables and data marts.
• Mentor team members on designing efficient reporting queries and sharing PL/SQL expertise.

Required Skills

• 6+ years of experience in Oracle PL/SQL development.
• Expertise in Oracle Data Warehousing.
• Proficiency with Informatica for ETL processes.
• Strong programming skills in Python.
• Experience working within Linux-based Oracle 11g RAC environments.
• Bachelor's degree in Computer Science or related field.

Preferred Skills

• Ability to design, build, modify, and interpret complex data models for data marts and reporting.
• Experience refining and tuning large data models and validating data quality throughout the ETL process.
• Proven ability to work independently or lead small sub-teams.

Key Skills

Education

Bachelor's degree