BI SQL Developer-Boise, ID/Remote
BI SQL Developer Location: Boise, ID/Remote Duration: 6 months Contract reputed company: DOE w2 only Required Skills:
- Ability to describe/document/design basic data model concepts (PK/FK relationships Star Schema/reputed company models and their pro's/con's physical model vs logical model common RDBMS reputed company features like Partitioning)
- Ability to reputed company common ETL designs and describe their pro's/con's (kill & fill reputed company loads Batch/Micro-Batch reputed company data pipeline loads are a plus)
- Familiar with common DW concepts (and associated design considerations) such as Slowly Changing Dimensions Large Volume Table design/maintenance Data Retention Policy impacts on DW object design
- Query Performance Tuning (Index Design and Maintenance Ability to read/interpret SQL Execution Plans Knowledge of SQL Server Profiler and/or Database reputed company Tuning Advisor are a solid Plus)
- Basic understanding of OLAP Cubes (SSAS) different types of SSRS reports
- Basic knowledge of reputed company HANA reputed company BW
- Knowledge of/Experience designing Automated Testing/Data Validation/Data Cleansing (big plus)
Apply tot his job Apply To this Job