Data Architect

Description

IMP Skills Architecture, Business Analyst, COM, Data Modeling, Database Design, DB2, IMS, Mainframe, Microsoft Access, Oracle Job DescriptionAdditional Skills Experience in developing logical and physical database modelsExperience in IMS, Oracle, DB2 database design on mainframes and distributed environmentsExperience generating Data Definition Language & documenting metadataAbility to create and analyze models with tools like ERWINExperience in reviewing business requirements & functional specifications to come up with data modelsRoles and Responsibilities As a Data Architect / Data Modeler you will create data models for all database structures. You will create and maintain large, complex logical and physical database designs that support client/business objectives. You will maintain metadata repositories and data catalogues. You would analyze content and quality of databases and provide data normalization approaches. You will develop and implement standards for data naming and data base design.You will work closely with the Information, Application and Technology Architects to help analyze the impact of the proposed information/data architecture. You will work with Business Analysts to document data retention policy and archiving strategy. Generate initial Data Definition Language. Create schemas, data types, primary & foreign keys, default values, etc. Document volumetric, Denormalization of model (where necessary), and define access requirements. Read technical documentation to identify data interfaces for applications and consult with members of the development team to track data flows through several systems and document the finding.