Oracle Data Engineer

Position detailsJob Title: Oracle Data EngineerLocation: Jersey City, New Jersey (Remote) Duration: 12 Months Experience: 16+ YearsJob 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.NotesBest 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.