Data Warehouse
CapB InfoteK
- Whippany, NJ
- Permanent
- Full-time
- Solid understanding of data warehouse modern design methodologies
- Solid understanding of best practices for SQL Server, the SQL Server Storage Engine and RDBMS
- Experience in SQL (MS SQL Server 2005/2008) technology is a must.
- Experience in very large database, data warehouse and high-volume ETL process
- Degree in engineering, computing or other numerate discipline
- 7+ years of development experience in IT
o 5+ years of T-SQL/procedure/view/function/trigger development and performance tuning
o 5+ years of SSIS development and management
o 1 + years of Oracle PL/SQL development
o 1+ years of data modeling
o 1+ years of VB script
o 1+ years of SSRS or other reporting tool experience
Preferred Qualifications-
- Previous experience in SQL Server administration and management is a big plus
- Understand OLAP and data warehouse is a big plus
- Experience with SQL Server Business Intelligence(SSAS) and .Net development is a plus
- Experience with Information 8.X for ETL development is a plus
- Knowledge of all phases of Software Development Life Cycle (SDLC)
- Knowledge of Identity Management and App Security is a plus
- Ability to develop strong client relationships
- Excellent written and verbal communication skills