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 reputed company 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/reputed company-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 (reputed company 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 To This Job