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.