Description

You will design and implement enterprise data warehouse solutions and dimensional database models.

Responsibilities

• Translate business requirements into technical data-aspect documentation and mapping.
• Design logical and physical data models for analytics and reporting following enterprise standards.
• Develop source, target, and output mapping documents to ensure data lineage and integration.
• Collaborate with developers and DBAs to identify and resolve performance bottlenecks in queries and data models.
• Architect, build, and deploy end-to-end BI solutions.

Required Skills

• 10+ years of experience with Oracle database technologies, SQL, PL/SQL, Stored Procedures, and Triggers.
• 8+ years of experience in database design, architecture, data modeling, and performance tuning.
• 8+ years of experience developing enterprise Data Warehouse solutions.
• Proven ability to design and implement dimensional database models.
• Strong SQL development expertise.
• Experience with Oracle RAC, Oracle Exadata, and Oracle Golden Gate.
• Bachelor's degree in Computer Science or equivalent technical experience.
• Ability to architect complex data warehouse environments.

Preferred Skills

• Extensive experience on the Oracle platform.
• Experience with ERWIN data modeller.
• Experience with banking and financial industry reporting.

Key Skills

Education

Bachelor's degree in Computer Science