Home > Everett jobs > Everett computer/technical

Posted: Wednesday, August 23, 2017 7:57 PM

Database:Great knowledge:- T-SQL- Stored procedure- Functions- Performance tuning- PartitioningSome basic DBA skill (backup/restore, setting up replication, security etc) ETL Design & Development:Able to design & Develop a common framework for ETL that can be leveraged as a common pattern for new data sourceso Some top features | Have a consistent approach for any data source with steps like pre-process, process, post-process. And those steps can be driven by stored procedures.| Should support structured Logging of execution step details, failures, success audit in tables.| Should be metadata driven as much as possible so that we can turn a table on or off if needed from load.| Able to restart from the last step executed| Able to do Delta or Full load Data Modeling design & Development:Great understanding and execution ofo Data modeling in terms of both relational and dimensional modelingo Identifying right granularity from business requirement and model it in Dimensions and Factso Star and snowflakes schemao Conformed dimensions, slowly changing dimensions etco Fact tables Cube development:Great understanding and execution ofo Multidimensional cube and Tabular Modelo Knowledge of MDX, DAXo Relationships - provided by DiceT-SQL, Stored procedure, Functions, Performance tuning, Partitioning, Cube development


• Location: Everett

• Post ID: 54064233 everett is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2017