CrawlJobs Logo
Beacon Hill Logo Beacon Hill · IT - Software Development

Oracle Data Engineer

United States, Philadelphia 55.00 - 64.00 USD / Hour · Job Posted March 26, 2026
Apply Position
Job Link Share

Job Description

We are seeking a Senior Oracle Data Engineer to lead foundational data model and ETL enhancements for a large‑scale enterprise data platform. This role owns Oracle‑side design and delivery of new data attributes, including complex historical backfills, to support downstream data processing and file‑based integrations.

Job Responsibility

  • Design and implement Oracle ETL enhancements to support new and evolving data attributes across both daily processing and multi‑year historical datasets
  • Extend and maintain Oracle data models and curated tables to reliably support downstream analytics and extract‑driven consumers
  • Analyze and implement identifier normalization and cross‑reference strategies, assessing downstream impacts and data lineage
  • Build and automate historical extraction and backfill processes, ensuring alignment with go‑forward incremental loads
  • Produce data extracts and placeholder artifacts required for parallel development across multiple downstream teams
  • Partner closely with QA and downstream engineering to support integration testing, defect resolution, and production readiness

Requirements

  • 6+ years of experience in Oracle‑based data engineering, including advanced SQL and PL/SQL
  • Proven experience delivering large historical backfills alongside ongoing incremental loads
  • Strong data modeling skills and experience supporting extract‑heavy data platforms
  • Experience working with high‑volume, regulated, or compliance‑sensitive data domains
Beacon Hill - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Oracle Data Engineer

8 matching positions

Oracle PLSQL Database Data Engineer – Assistant Vice President

Oracle PLSQL Database Data Engineer – Assistant Vice President is an intermediat...
Location
Location
India , Pune, Maharashtra, India, Chennai, Tamil Nadu, India
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 8+ years of relevant experience
  • Very good understanding in Oracle architecture
  • Strong exposure to Python, Spark, Agentic workflows - Devin, Copilot
  • Extensively worked on PL/SQL Packages, Procedures, Functions, Triggers, Views, MViews, External tables, partitions and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle
  • Must have experience in advance PL/SQL, Hints, Cursors to process huge volumes of data, bulk collect for performance improvement process
  • Must have experience Data Modeling and Warehousing concepts such as Star Schema, OLAP, OLTP, Snowflake schema, Fact Tables for Measurements, Dimension Tables for Descriptive Context, Periodic Snapshot Fact Tables, Junk Dimensions etc.
  • Hands on experience on SCD Type 1,Type 2,Type 3,Type 4,Type 5,Type 6
  • Must have very good understanding of Snapshot tables, staging tables, History tables, Audit tables, Granularity, Single Granularity for Facts, Dimension Granularity and Hierarchies, Date Dimension, Degenerate Dimensions, Surrogate Keys, Generalization and Normalization of data, Ragged Hierarchies etc.
  • Highly proficient in writing complex yet efficient SQL
  • Knowledge of any data modeling tool
Job Responsibility
Job Responsibility
  • Participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team
  • Contribute to applications systems analysis and programming activities
  • Fulltime
Read More
Arrow Right

Oracle Golden Gate Administrator / Data Engineer

Location
Location
United States , Seattle
Salary
Salary:
140000.00 USD / Year
realign-llc.com Logo
Realign
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Oracle Golden Gate Classic architecture(text based) and administration – Mandatory
  • Oracle Golden Gate New architecture(GUI based) - Plus
  • Data extract/transfer experience from Non-Oracle Databases (Teradata, Amazon S3,SQL. Azure, GCP etc.)
  • HVR(High Value Replicator),FiveTran product administration and Data Engineering – is a Plus
  • Linux skill, PL/SQL , Jenkins job execution & Java awareness
  • Familiarity with couple of database systems
Job Responsibility
Job Responsibility
  • Extract data and data replication in Oracle GG product
  • Building and maintaining ETL pipelines with Oracle Goldengate ( HVR also is a plus)
  • System administration and Tuning
  • Daily Systems Monitoring
  • Patching and software upgrades for product and servers
  • Break fix all production issues
  • Incident management and service requests
  • Upgrades/migrations/customizations
  • On-call Support
  • Fulltime
Read More
Arrow Right

Data Engineer (Big Data, Cloud - AWS, Databricks) - Assistant Vice President

Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Scala, Spark/Pyspark is must, Hadoop ( BIG Data ), + AWS,Databricks
  • 8 to 11 years’ experience implementing data-intensive solutions using agile methodologies
  • Experience of relational databases and using SQL for data querying, transformation and manipulation
  • Experience of modelling data for analytical consumers
  • Ability to automate and streamline the build, test and deployment of data pipelines
  • Experience in cloud native technologies and patterns
  • A passion for learning new technologies, and a desire for personal growth, through self-study, formal classes, or on-the-job training
  • Excellent communication and problem-solving skills
  • An inclination to mentor
  • an ability to lead and deliver medium sized components independently
Job Responsibility
Job Responsibility
  • Developing and supporting scalable, extensible, and highly available data solutions
  • Deliver on critical business priorities while ensuring alignment with the wider architectural vision
  • Identify and help address potential risks in the data supply chain
  • Follow and contribute to technical standards
  • Design and develop analytical data models
  • Fulltime
Read More
Arrow Right

Data Engineer Big Data Technology

The Applications Development Intermediate Programmer Analyst is an intermediate ...
Location
Location
Singapore , Singapore
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 4-6 years of hands-on experience in Hadoop, Scala, Java, Spark, Hive, Kafka, Impala, Unix Scripting and other Big data frameworks
  • 4+ years of experience with relational SQL and NoSQL databases: Oracle, MongoDB, HBase
  • Strong proficiency in Python and Spark Java with knowledge of core spark concepts (RDDs, Dataframes, Spark Streaming, etc) and Scala and SQL
  • Data Integration, Migration & Large Scale ETL experience (Common ETL platforms such as PySpark/DataStage/)
  • 4-6 years of relevant experience in the Financial Service industry
  • Experienced in working with large and multiple datasets and data warehouses
  • Experience building and optimizing ‘big data’ data pipelines, architectures, and datasets
  • Strong analytic skills and experience working with unstructured datasets
  • Ability to effectively use complex analytical, interpretive, and problem-solving techniques
  • Experience with Confluent Kafka, Redhat JBPM, CI/CD build pipelines and toolchain – Git, BitBucket, Jira
Job Responsibility
Job Responsibility
  • Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
  • Apply fundamental knowledge of programming languages for design specifications
  • Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
  • Serve as advisor or coach to new or lower level analysts
  • Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
  • Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
  • Has the ability to operate with a limited level of direct supervision
  • Can exercise independence of judgement and autonomy
  • Acts as SME to senior stakeholders and /or other team members
  • Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency
  • Fulltime
Read More
Arrow Right

Staff Engineer - Finance Data Engineer

GEICO is seeking Finance Data specialists to support the build out of a Finance ...
Location
Location
United States , Palo Alto
Salary
Salary:
110000.00 - 260000.00 USD / Year
geico.com Logo
Geico
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 15+ years of Finance Systems experience with industry leading ERP solutions (e.g. implementing and supporting Oracle
  • Workday
  • SAP or PeopleSoft)
  • 3+ years of experience in implementing and supporting FP&A applications (Preferred)
  • 3+ years working with or supporting a Finance Data Lake/Warehouse/Mart along with various Financial Reporting tools
  • Good understanding of Dimensional Data Modeling
  • Strong working knowledge of Data processing/data transformation using ETL/ELT tools such as Informatica, DBT, etc.
  • Strong working knowledge of SQL and the ability to write, debug and optimize SQL queries and ETL jobs
  • Experience working with Financials via the major vendors (e.g. PeopleSoft
  • Oracle EBS
Job Responsibility
Job Responsibility
  • Leverage your strong Functional and Technical systems expertise to drive towards the right solution to support the department and GEICO’s current and future needs
  • Engage in cross-functional collaboration throughout the entire software lifecycle
  • Support design sessions with peers to ensure systems are well designed, efficient, and meet Business expectations
  • Collaborate with Finance Leaders within the FP&A, Controllers, Financial Reporting, and Finance QA & Systems team along with the Data Engineering and Finance Technology leaders to ensure organizational goals are met
  • Have a deep understanding of a few Finance functions to support the establishment of a vision and technology roadmap to build out a Finance Data Lake/Warehouse
  • Have a good understanding of finance data lake/mart with Data processing/data transformation using ETL/ELT tools such as Informatica, DBT, etc.
  • Experience with designing, developing, implementing, and maintaining solutions for data ingestion and transformation projects
  • Experience working with cloud data solutions (Delta Lake, Iceberg, Hudi, Snowflake, Redshift or equivalent)
  • Support the development of a roadmap and then work towards implementing Revenue and Expense Analytical solutions
  • Support and try to influence customers and stakeholders, and work through divergent expectations
What we offer
What we offer
  • Comprehensive Total Rewards program that offers personalized coverage tailor-made for you and your family’s overall well-being
  • Financial benefits including market-competitive compensation
  • a 401K savings plan vested from day one that offers a 6% match
  • performance and recognition-based incentives
  • and tuition assistance
  • Access to additional benefits like mental healthcare as well as fertility and adoption assistance
  • Supports flexibility- We provide workplace flexibility as well as our GEICO Flex program, which offers the ability to work from anywhere in the US for up to four weeks per year
  • Fulltime
Read More
Arrow Right

Forward Deployed Engineer - Data Migration & Data Consolidation Platforms

As a Forward Deployed Engineer (FDE) for Data Migration & Data Consolidation Pla...
Location
Location
United States
Salary
Salary:
Not provided
rackspace.com Logo
Rackspace
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 7-10+ years of progressive experience in enterprise data engineering, data migration, or large-scale system integration roles within complex, multi-platform environments
  • 3-5+ years directly leading end-to-end data migration or multi-system consolidation programs for Global Enterprises and Industry Leaders, with full ownership of technical delivery and client outcomes
  • Demonstrated client-facing experience serving as a trusted technical advisor to C-level executives, enterprise architecture teams, and cross-functional business stakeholders
  • Proven industry depth in at least two of the following verticals: Healthcare, Financial Services, Manufacturing, Retail, Energy & Utilities, or Public Sector
  • Hands-on migration complexity: successfully delivered programs involving at least 3+ heterogeneous source systems, 100M+ records, complex master data harmonization, and multi-phase cutover execution
  • Advanced proficiency in Python and SQL with working experience in PySpark and TypeScript/JavaScript
  • Hands-on expertise with modern ETL/ELT and data integration platforms (Informatica, Talend, Matillion, Fivetran, AWS Glue, Azure Data Factory)
  • Proven ability to build scalable, version-controlled data pipelines with error handling, incremental loading, and Change Data Capture (CDC)
  • Strong working knowledge of at least one major cloud provider (AWS, Azure, or GCP), including core infrastructure, managed data services, and security configurations
  • Experience with enterprise data warehouse and lakehouse platforms (Snowflake, Databricks, BigQuery, Redshift, Synapse Analytics, Delta Lake)
Job Responsibility
Job Responsibility
  • Migration Execution & Cloud Architecture: Lead end-to-end delivery of enterprise data migrations from corporate systems (SAP, Oracle, Epic ERP) to target cloud data platforms, including the design of cloud landing zones, data governance frameworks, and system rationalization strategies. Establish migration compliance controls, automated rollback procedures, and operational readiness gates while owning full technical accountability for 12–18+ month migration roadmaps
  • Data Pipeline Engineering & Transformation: Build production-grade data connectors to SAP (RFC, IDoc, BAPI, OData), Oracle (AQ, GoldenGate, APIs), and SQL/non-relational sources. Develop ETL/ELT pipelines with LLM-enabled transformation logic, multi-layer validation and reconciliation frameworks, and optimized throughput for datasets scaling from tens of millions to billions of records with built-in CDC and incremental loading
  • Ontology Layer Development & Schema Automation: Construct semantic ontology layers translating raw ERP structures into business-consumable objects (Customer, Order, Invoice, Product, Vendor, Asset). Deploy automated schema mapping agents for source-to-target analysis and transformation logic generation. Build unified master data models with row/column-level security, cross-system lineage tracking, and AI-ready semantic structures
  • Application & Workflow Delivery: Build operational dashboards, migration control centers, and agent-driven workflows for automated validation, exception handling, and anomaly detection using low-code platform tools. Generate TypeScript/Python SDKs for custom integrations and deliver real-time monitoring and self-service interfaces for migration progress, data quality KPIs, and compliance tracking
  • Multi-System Consolidation & Master Data Management: Lead consolidation of 5–15+ fragmented ERP instances into standardized master data models. Resolve complex entity resolution challenges including customer matching, product harmonization, and chart of accounts unification. Establish golden record frameworks, data quality scorecards, survivorship rules, and data stewardship workflows for post-migration governance
  • Client Engagement, Discovery & Modernization Advisory: Serve as primary technical advisor to C-suite and enterprise architecture stakeholders across all engagement phases. Deploy discovery agents to analyze legacy data estates, conduct assessment workshops, facilitate solution design sessions, and deliver executive briefings, go/no-go readiness assessments, and prioritized modernization roadmaps
  • Knowledge Transfer, Enablement & IP Development: Build reusable migration accelerators, playbooks, and reference architectures that scale across engagements. Lead knowledge transfer to upskill client teams for post-migration ownership and collaborate with internal product and sales engineering teams to feed field insights back into platform development and delivery methodology
  • Leadership & Executive Engagement: Operate autonomously in ambiguous, high-stakes client environments, driving outcomes with minimal oversight
  • translate deeply technical concepts into clear, business-level narratives for C-suite audiences through executive briefings and stakeholder communications
  • navigate organizational complexity, competing stakeholder priorities, and enterprise change management dynamics to maintain momentum across multi-workstream engagements
Read More
Arrow Right

Technical Support Engineer - Azure Data Factory / Data Integration

Within CE&S, the Customer Service & Support (CSS) organization builds trust and ...
Location
Location
Malaysia , Kuala Lumpur
Salary
Salary:
Not provided
https://www.microsoft.com/ Logo
Microsoft Corporation
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Information Technology (IT), or related field AND 1+ years of technical support, technical consulting experience, or information technology experience
  • OR 3+ years of technical support, technical consulting experience, or information technology experience
  • OR equivalent experience
  • Azure Data Factory (ADF)
  • Azure Synapse Analytics / Microsoft Fabric Pipeline
  • Data Lake
  • Relational Database Management System (Microsoft SQL Server / Oracle Database / MySQL / IBM Db2 / SAP)
  • Big Data or Analytics Products (Spark / Azure HDInsight / Azure Data Lake Analytics / Azure Synapse Analytics / Databricks / Google BigQuery)
  • Pipeline and ETL/ELT Skills
  • Building and orchestrating pipelines (ADF / Synapse / Fabric)
Job Responsibility
Job Responsibility
  • Response and Resolution: You own, investigate and solve customer technical issues. You collaborate within and across teams, leveraging troubleshooting tools and practices
  • Readiness: You lead or participate in building communities with peer delivery roles and, where appropriate, share your knowledge
  • You develop specific technical and professional proficiency to enable you to resolve customer issues, through training and readiness
  • Product/Process Improvement: You identify potential product defects and escalate appropriately to resolve, contributing to Microsoft product improvements
  • Fulltime
Read More
Arrow Right

Data Engineer (GCP & ETL) - VOIS

We are seeking a Data Engineer with hands-on experience in Google Cloud Platform...
Location
Location
India , Pune
Salary
Salary:
Not provided
vodafone.com Logo
Vodafone
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 4–7 years of experience in data engineering or a closely related role
  • Strong proficiency in GCP services, including BigQuery, Dataproc, Data Fusion, and Cloud SQL
  • Hands-on experience with enterprise ETL tools such as Ab Initio or ODI
  • Solid knowledge of Unix and SQL, with exposure to Teradata environments
  • Working knowledge of Python is an advantage
Job Responsibility
Job Responsibility
  • Design, develop, test, and maintain scalable and reliable data pipelines and software systems
  • Collaborate with cross-functional stakeholders to gather, analyse, and understand data requirements
  • Implement and manage ETL processes using tools such as Ab Initio or Oracle Data Integrator (ODI)
  • Work extensively with GCP services including BigQuery, Dataproc, Data Fusion, and Cloud SQL
  • Write, optimise, and maintain SQL queries for efficient data extraction and transformation
  • Ensure data quality, consistency, integrity, and performance across data platforms
  • Monitor, troubleshoot, and resolve data workflow and system issues to maintain operational stability
What we offer
What we offer
  • Opportunity to work on enterprise-scale data platforms within a global organisation
  • Exposure to modern cloud-based data engineering solutions and large, complex datasets
  • A collaborative, inclusive, and learning-focused work environment
  • The chance to contribute directly to data-driven transformation initiatives across Vodafone markets
  • Fulltime
Read More
Arrow Right