Senior Oracle PL/SQL Developer
Core
Designing data models and developing optimized Oracle PL/SQL code for analytics and data warehousing pipelines.
Role type
Senior IC Oracle PL/SQL Developer (Data Warehousing)
Builds
Data models, PL/SQL procedures/packages, and optimized data movement pipelines
Domain
Data Warehousing / Analytics
Required skills
Oracle PL/SQL, Oracle SQL, Data Modeling, Data Warehousing Architecture, Performance Tuning, Data Analysis, ETL Process Improvement
Preferred skills
ETL tools (DataStage, Informatica, Alteryx), BI tools (Tableau, MicroStrategy), Job Scheduling (Autosys, Shell Scripting), Excel
Technologies
Oracle, SQL, PL/SQL, Alteryx, Informatica, Tableau, Autosys, Excel
Responsibilities
Design conceptual, logical, and physical data models for analytics and data warehousing. Develop and optimize Oracle PL/SQL code, including procedures and packages, and tune performance. Coordinate with upstream systems of record and downstream users to align data models and flows. Improve data movement, quality, and integrity across pipelines and processes. Independently analyze large datasets, identify patterns, and present findings. Improve legacy processes and establish standards that support scalability and reliability.
