Description

Lead database development and ETL activities within an Oracle-based environment, owning the full lifecycle from design to incident resolution.

This role is on-site.

Responsibilities

• Develop, test, and implement ETL scripts, jobs, and data pipelines.
• Design physical data models and recommend architectural improvements for existing systems.
• Monitor the Enterprise Data Warehouse (EDW), respond to incidents, and resolve data quality issues.
• Document ETL processes, data mappings, lineage, and Kimball dimensional modeling frameworks.
• Lead technical efforts, mentor team members, and conduct code reviews.

Required Skills

• Minimum 10 years of professional experience.
• At least 7 years of verifiable experience in database design, development, and warehouse architecture.
• 5 years of development experience in Oracle data warehouses.
• 2 years of ETL development experience specifically in Oracle Autonomous Data Warehouse.
• Proficiency in Oracle Database, PL/SQL, and SQL.
• Experience with Oracle Data Integrator (ODI) or Oracle GoldenGate.
• Strong understanding of data warehousing concepts and dimensional modeling.
• Ability to provide technical leadership for an Oracle data warehouse team.

Preferred Skills

• Experience with Oracle Business Intelligence Enterprise Edition (OBIEE).

Key Skills

Education

Any Gradute