Description

You will lead database development and ETL activities within an Oracle-based environment.

Responsibilities

• Develop, test, and implement ETL scripts, jobs, and data pipelines.
• Design physical data models and provide recommendations for existing architecture.
• Monitor the 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 participate in 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 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.

Key Skills

Education

Any Gradute