Should have experience with an ETL tool, preferably Microsoft SSISĮxperience with SQL create/modify/test scripts to test data model and confirm viability against report specifications Skilled in data base design in a large data base environment (1 TB )Įxperience with Microsoft SQL Server 2008 R2 or higherįamiliarity with the procedures and issues of implementing ETL routines Knowledge of data architecture concepts such as data cubes and OLAP multidimensional systems, data marts, data mining systems, operational data stores, data warehouses, staging databases and data servicing layers Minimum five years of experience in gathering database mapping requirements and creating mapping documentation in detail preferably using ERwin
Minimum five years of experience in relational database design & tuning, use of tools to diagnose database performance issues, create reporting index strategies and improve database designs based on SQL execution Minimum five years of experience in the design and building of data models
Strong verbal and written communication, with an ability to present and discuss technical information in a way that establishes rapport, persuades others, and gains understandingĪbility to exercise independent judgment and creative problem-solving techniques in a highly complex environment using technology and/or integrating diverse user systems Ability to work in a fast paced environmentģ-5 years demonstrated expertise in logical and physical data modeling (ER)ģ-5 years of experience in developing operational environmentsģ-5 years demonstrated proficiency using Data Modeling tools such as: ERwinģ-5 years working experience of large scale computing environmentģ years of working experience in ANSI standard SQL a mustģ years of experience with change management procedures and SDLC is a mustģ years of experience with deployment of database changesģ years of demonstrated ability to investigate and learn new technologies and products is preferred
0 kommentar(er)
