Job Overview

Company:
NexAge Technologies USA, Inc.
Title:
MS SQL DWH Architect
Skills:
Microsoft SQL, data warehouse, architect, Data Modeling, OLAP, OLTP, SQL Queries, SSIS, SSAS, SSRS, ETL
Date Posted:
9-11-2014
Location:
Sherman Oaks, CA
Area Code:
213
Employ. Type:
CON_CORP CON_IND CON_W2
Pay Rate:
DOE
Job Length:
Long term
Position ID:
733926
Dice ID:
RTL56721
Travel Required:
none
Telecommute:
no

Contact Information

Contact:
Usha Agarwal
Address:
75 Lincoln Hwy
 
#101
 
Iselin, NJ 08830
Phone:
(732) 494-4944 ext: 305
Save this job
Click Here to Apply
Printer-Friendly

Job Description

  • MS SQL DWH Architect
  • Sherman Oaks, CA

 

 

Hi,

We have an urgent requirement from our client for the below position.Please see the below job description.


Designation: DataWareHouse (DWH) Architect in Microsoft SQL (pref ver 2013)

Location: Sherman Oaks, California

Years of Prof. Experience: 8 to 9 Years at the least

Min. relevant experience: 5 years or more

Mandatory: Must have completed at least 2 DWH full project lifecycles
 

Job Description
 
1.Extensive experience with end-to-end DWH implementations    
2.Data Modeling, OLAP, OLTP, etc.     
3.SSIS, SSAS, SSRS    
4.ETL    
5.Extensive experience with transforming business rules to metadata definitions    
6.Expert in best practices for data marts and enterprise DWHs     
7.DWH industry expert with knowledge of best practices in key DWH/BI and Reporting technologies, techniques and components     
8.Deep knowledge of all DWH-related components (Sourcing, ETL, Data Modeling, Infrastructure, BI, Reporting)    
9.Expert level knowledge of multiple tools supporting those DWH components      
10.Expert knowledge of data quality and cleansing tools and techniques     
11.Expert knowledge of metadata management and data governance    
12.Deep knowledge of data modeling techniques and tools     
13.Ability to take the lead, work independently and work within a team     
14.Excellent written and oral communication skills
    
Remarks:

•    Person should be able to converse with CXO level personnel  
•    Position is highly critical and highly “visible”

Mandatory Skills
 
1. Strong SQL skills -    8+    Intense hands-on
2. Strong DWH Architecture skills     5+ Yrs    Intense hands-on
3.Experience using bulking techniques, data collections     5+ Yrs    Intense hands-on
4.Performance & SQL tuning of large database environment    5+ Yrs    Intense hands-on
5.Experience with SSIS, SSAS, SSRS, ETL    5+ Yrs    Intense hands-on
6.App. development using SQL, Forms & Reporting tools     5+ Yrs    Intense hands-on
7.Good coding practices, in terms of readability, consistency, adherence to standards, and performance     8+    Intense hands-on

Soft Skills
 
1.Must be able to pass a full criminal background check    
2 .Ability to adapt quickly to an existing work & tech. environment    10 or more    
3.Candidate should be a self-motivated, detail oriented, responsible team-player     10 or more    
4.Passionate about building high-quality systems with software implementation best practices    10 or more    
5.Analytical skills including requirements gathering / understanding from end users when required     10 or more     
 
Nice to Have Candidate Skills / Aspects

1.DWH / MS-SQL Certified -    Within last two years certification or renewal
2.Worked in Mortgage domain     
3.Worked in large-scale SQL database     
4.Worked in large-scale SQL multi-user applications



Please revert back to me asap with the updated resume and contact details to reshma@nexageusa.com/732-703-9634

Thanks

Reshma'

Nexage Technologies    

Save this job
Click Here to Apply