EDW Data Architect - Skills and responsibilities –
- Responsible for the conception, design, development, and deployment of data architecture and data models in Enterprise Data Warehouse
- Hand on experience on Erwin
- Responsible for the development of physical and logical data models
- Expert in Oracle and PL/SQL
- Strong knowledge in writing complex queries for validation of ETL process
- Identify the bottleneck and modify code for performance improvement
- Having working knowledge of Python
- Familiarity with agile development using JIRA, Bitbucket
- Provide leadership for the architectural direction, and provide consultation to agile teams
- Work together with various business units (BI, Product, Reporting) to develop data warehouse platform vision, strategy, and roadmap
- Follow various ETL Processes to prepare design for all metadata
- Have knowledge of Informatica
- Experience in waterfall and agile testing methodologies
- Experience in working with diverse team: Onsite – offshore model
Must possess excellent written and verbal communication skills