Data Warehouse

CapB InfoteK

  • Whippany, NJ
  • Permanent
  • Full-time
  • 1 month ago
CapB is a global leader on IT Solutions and Managed Services. Our R&D is focused on providing cutting edge products and solutions across Digital Transformations from Cloud, AI/ML, IOT, Blockchain to MDM/PIM, Supply chain, ERP, CRM, HRMS and Integration solutions. For our growing needs we need consultants who can work with us on salaried or contract basis. We provide industry standard benefits, and an environment for LEARNING & Growth. Positions are based across geographies. Consultants for some positions MAY opt for remote work depending on the criticality of the work we are doing.For one of our ongoing Project we are looking for a Data Warehouse Developer with Microsoft SSIS, SQL, Oracle, ETL.Person Requirements:
  • 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 ETL and data warehouse development using SQL Server 2005/2008 database
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

CapB InfoteK