Role: Senior PL/SQL ETL Developer
\nLocation: Whippany NJ (Hybrid)
\nType: Long Term Contract
\n \nJob Description:
\n· A 12+ years data professional responsible for designing, building, and optimizing Extract, Transform, and Load (ETL) workflows.
\n· 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).
\nCore Responsibilities and Skills:
\n· Data Extraction & Ingestion: Pulling raw data from diverse sources including flat files, APIs, external cloud architectures, and legacy databases.
\n· Data Transformation: Writing sophisticated stored procedures, functions, packages, and database triggers to clean, aggregate, format, and validate business data.
\n· 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.
\n· 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.
\n...management, and ability to meet established deadlines. Excellent communication and interpersonal skills to effectively interface with others. Ability to work independently and problem-solve. Ability to provide leadership for the CRO statisticians and statistical programmers.
...POSITIONMDH Office of the Chief Medical Examiner (OCME)900 W. Baltimore StreetBaltimore, MD 21223MAIN PURPOSE OF JOBA Forensic Investigator is full performance level work that conducts investigation of cases that are referred to the Office of the Chief Medical Examiner...
...We are immediately hiring a Behavior Interventionist in the Dedham, MA and surrounding areas to provide play-based ABA therapy to our families in the home, community, school, or clinic.At Cortica, our mission is to design and deliver life-changing care one child, one...
Shepherd of the Lake Lutheran Church, Prior Lake, MN | Part-Time We are hiring a choir director at Shepherd of the Lake Lutheran Church in Prior Lake! This is for three choir projects during the program year: Christmas Eve, Good Friday/Easter, and Pentecost/end of the ...
The Thacher School Part Time Psychology - Faculty Member Department: Faculty Position: Science (Psychology) Status: Part... ...powerful character. Thacher seeks a part-time experienced teacher of psychology for a long-term substitute position beginning...