Data / ETL Engineer

The hiring company is confidential. The mid-level Data / ETL Engineer contributes to building a modern Oracle Autonomous Data Warehouse platform by developing SQL-driven ELT pipelines, curated datasets, and data models, while supporting replication, data quality, and iterative project delivery.

Responsibilities:

• Develop, enhance, and optimize SQL/PLSQL based ELT pipelines for loading and transforming data into ADW
• Build new curated datasets, including:
• Materialized views for analytical consumption
• Star schemas (fact and dimension tables)
• Summary, snapshot, and conformed data structures
• Conduct performance tuning across queries, transformations, and materialized views
• Implement data quality checks, automated validations, and reconciliation logic as part of each pipeline
• Assist in configuring and updating GoldenGate replication flows for new data sources and schema changes
• Validate replicated data and troubleshoot replication delays, failures, or out of sync conditions
• Work with the Data Architect to translate business requirements into logical and physical data models
• Support data modeling activities such as partitioning strategies, indexing, and schema design
• Produce documentation, data dictionaries, technical flows, and runbooks to support long term maintainability
• Participate in sprint ceremonies, provide task estimates, and deliver iterative improvements
• Work closely with OAC developers to ensure datasets support semantic layer and reporting requirements
• Collaborate with QA, platform engineering, and analysts to validate data outputs

Requirements:

• 3–5+ years of experience as a Data Engineer, ETL/ELT Developer, or similar role
• Advanced SQL proficiency including complex joins, window functions, query optimization, and performance tuning
• Hands-on experience with Oracle ADW, Oracle Database, or similar cloud data warehouse technologies
• Experience designing and building star schemas, materialized views, and analytical data models
• Familiarity with data replication concepts (GoldenGate preferred)
• Strong understanding of relational and dimensional modeling
• Experience with automated data quality frameworks or test-driven data development
• Exposure to Oracle Data Integration tools (ODI, ODI C) or other ETL/ELT platforms (Informatica, Talend, DataStage)
• Experience building cloud-based data platforms or pipelines (OCI preferred)
• Background in agile delivery, DevOps for data, or ELT orchestration frameworks
• Ability to profile data, assess data quality, and recommend structural improvements