Oracle Data Engineer

Position details Job Title: Oracle Data Engineer Location: Jersey City, New Jersey (Remote) Duration: 12 Months Experience: 16+ Years Job Description: Develop Oracle-heavy data engineering solutions across ETL, data loading, data modeling, analytics, and performance tuning. Support batch ETL and real-time stream processing, including ability to assist with QA tasks where needed. Understand the flow end to end from UI to database to support issue identification and remediation. Hard skills / core responsibilities • Create Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g and Oracle 12. • ETL processing with Python, Oracle, and Unix across batch ETL and real-time stream processing. • Ability to do QA for some tasks, including validation, issue investigation, and support for delivery signoff where needed. • Load huge data sets from multiple vendors and perform data cleansing, data transformations, and data loading involving data modeling and data analytics. • Work on performance tuning for existing SQL and PL/SQL objects and build optimized objects. • Create complex Unix shell scripts to automate batch job processing and create reports on real-time, daily, and weekly basis. • Perform logical and physical design of databases, data modeling, and design specifications to analyze dependencies and perform risk analysis. • Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests that are performed. • Write complex queries to identify potential issues when interfaces fail and remediate them. • Automate flat file loading to Oracle using SQL Loader and create control files for that activity. • Able to understand the flow end to end from UI to DB. Technologies / tools • Oracle 11g and Oracle 12 advanced database capabilities. • Oracle PL/SQL objects, materialized views, functions, triggers, packages, and views. • Python, Oracle, and Unix for ETL processing. • Unix shell scripting for batch automation and reporting. • SQL Loader and control files for automated flat-file ingestion. • GitHub Copilot or other Dev Assist tools and capabilities. Frameworks / delivery methods • Batch ETL and real-time stream processing. • Data cleansing, transformation, loading, modeling, analytics, and dependency / risk analysis. • Change request documentation, data mapping, program logic, and technical specification discipline. • QA support orientation for tasks requiring validation and handoff confidence. Soft skills / ways of working • Hands-on delivery orientation with strong analytical skills for interface issue diagnosis and remediation. • Ability to collaborate with architects, developers, QA, and business-facing teams across change requests and delivery cycles. • End-to-end thinking from UI to database, with practical comfort working across data, integration, and validation needs. Notes • Best fit: Oracle-centric data engineer with ETL, PL/SQL, Unix, performance tuning, and data loading depth, plus willingness to support QA activities. • Prioritize candidates who can handle high-volume vendor data, write complex queries, build optimized objects, and document mappings/specifications clearly.