Role: Senior PL/SQL ETL Developer
Location: Whippany NJ (Hybrid)
Duration : Long-term
Job Description:
Senior PL/SQL ETL Developer:
A 12+ years data professional responsible for designing, building, and optimizing Extract, Transform, and Load (ETL) workflows.
Operating primarily within Oracle Database environments, leverage Oracle's proprietary PL/SQL (Procedural Language/Structured Query Language) to move massive datasets from transactional systems (OLTP) into analytical data warehouses (OLAP).
Core Responsibilities and Skills:
Data Extraction & Ingestion: Pulling raw data from diverse sources including flat files, APIs, external cloud architectures, and legacy databases.
Data Transformation: Writing sophisticated stored procedures, functions, packages, and database triggers to clean, aggregate, format, and validate business data.
Data Loading: Efficiently inserting the transformed data into data warehouses using bulk processing techniques like FORALL statements, bulk collections, and Oracle's BULK COLLECT architecture to minimize context switching between the SQL and PL/SQL engines.
Performance Tuning: Analyzing execution plans, optimizing slow-running queries, configuring proper indexing strategies (B-Tree, Bitmap), partitioning tables, and rewriting code to manage enterprise-scale workloads.
Oracle Database & PL/SQL: Mastery of relational database management systems (RDBMS), database design, explicit/implicit cursors, collection types, exception handling, and analytical SQL window functions. [1, 2, 3]
Dedicated ETL Tools: While PL/SQL itself acts as a native programmatic ETL engine, professionals frequently collaborate with enterprise ETL suites such as Informatica PowerCenter, Oracle Data Integrator (ODI), or Talend.
Scripting & Automation: Creating Linux/Unix shell scripts and utilizing scheduling engines (such as Control-M, Autosys, or cron jobs) to automate nightly or streaming batch pipelines.
Tools & Utilities: Deep familiarity with development tools (TOAD, SQL Developer, SQL Navigator) and shell scripting (Unix/Linux) for batch automation.
Data Warehousing Concepts: Deep understanding of dimensional modeling, specifically Star Schemas, Snowflake Schemas, and Slowing Changing Dimensions (SCD Types 1, 2, and 3)
Cemetery Caretaker The Cemetery Caretaker performs jobs requiring mainly manual skills and physical strength. Performs a variety of tasks, such as operating small tractors and riding lawn mowers; transplanting shrubs; digging graves to the proper level; cutting and ...
...Anticipated period of employment: 12/07/2026 to 04/17/2027 No experience required. Workers will perform assigned duties as instructed by... ...pruning trees, and the cleaning and maintenance of fields. Use of hand tools including but not limited to: pruners, shovels, hoes,...
UCHealth is seeking a RN Traveler for Night Shift Labor & Delivery. In this role, youll provide expert, compassionate care to mothers and newborns through all phases of labor, delivery, and immediate postpartum recovery. Working within an academic, high-acuity setting...
...Job Description Job Description The Pin Setter Mechanic/Pin Chaser supports the reliable operation of Brunswick pinsetter machines through equipment inspections, preventive maintenance, repairs, and on-call floor coverage. Reporting to operations management, this...
...measures.Responding to on site emergencies by calling local law enforcement or other first responders.Conducting pat down and metal detecting... ....Minimum RequirementsExperienced Off Duty Police Officer or Retired Police OfficerValid Government ID and Social Security...