Senior PL/SQL ETL Developer Job at Cbase Inc, Whippany, NJ

  • Cbase Inc
  • Whippany, NJ

Job Description

He/she needs to work in a hybrid model, at least 3 days from the Whippany, NJ office.

Need Only Locals to NJ

F2F Interview is MUST

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. [ , , ]
  • 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)

Job Tags

Work at office, Local area, Night shift

Similar Jobs

No Place Like Home Health LLC

🏡 Home Health RN - Great Pay, Flexible Schedule Meaningful Work! Job at No Place Like Home Health LLC

 ...autonomy in your workday ~ Supportive, locally owned company ~ Great opportunity for PRN or additional income ~ Make a meaningful...  ...Patients Stay Home. If you#39;re looking for great per-visit pay, flexibility, independence, and meaningful patient relationships... 

DaBella

Subcontractor (Bend, OR) Job at DaBella

 ...Join DaBella Subcontractors wanted! Join DaBella - the fastest growing home remodeler in the USA! We are seeking experienced and dependable general contractors or construction professionals who want to grow their company and get paid! Join us as a business partner and... 

Postal Jobs Source

Postal Mail Handler - Potter County Job at Postal Jobs Source

Postal Mail Handler Job Overview and Description The Postal Service is the largest government-related agency employing nearly 1 million people and is currently hiring nationwide, there are MANY positions available! The job openings range in starting salary from ...

SteadPoint

Lost-Time Claims Adjuster Job at SteadPoint

 ...AL, TN, GA, NC, and SC. POSITION AVAILABLE - LOST-TIME CLAIMS ADJUSTER The Claims Adjuster with SteadPoint Risk Management...  ...The Claims Adjuster must possess a thorough understanding of insurance coverage, claims administration practices, medical terminology... 

City of Conroe

Assistant City Attorney Job at City of Conroe

 ...Assistant City Attorney The City of Conroe seeks an experienced attorney representing governmental entities concerning municipal procurement,...  ...Possession of or ability to obtain license for practice before U.S. District Court. Knowledge, Skills and Abilities Knowledge...