Job Description-
Key responsibilities include:
· Work with business and system analysts to analyze business requirements into data-aspect CSD
· Develop source, target, and output mapping technical documents as required for data lineage and transformation and integration
· Design logical and physical data models for analytics and reporting in compliance with the Enterprise Data Model standards Performance
· Work with developers and DBA to identify performance bottlenecks in the data models and the queries, and to implement solutions
Qualifications for your role would include:
· Bachelor's degree in Computer Science or related technical field, or equivalent experience
· Minimum 8 years’ experience with database design and architecture, data modeling, performance tuning, and mainstream business intelligence applications
· Minimum 8 years’ experience developing enterprise Data Warehouse solutions
· Minimum 10 years’ experience with Oracle database technologies, SQL, PL/SQL, Stored Procedures, Triggers, etc.
· Experience with design and implementation of the dimensional database model
· Ability to architect data warehouse environments
· Ability to work with many different technical tools
· Ability to design, model, build, and deploy BI solutions
· Possessing good analytical and problem-solving abilities
· Strong understanding of how data schemas/structures satisfy and relate to business functions.
· Strong SQL development experience
· Excellent verbal, written and interpersonal communication skills
· A good team player – one who appreciate the value of a good team player to the success of the organization
· Experience with Oracle RAC , Oracle Exadata and Oracle Golden Gate
Nice to have:
· Extensive experience on Oracle platform
· Experience with banking and financial industry reporting
· Experience working with ERWIN data modeler
Bachelor's degree in Computer Science