Data Warehouse Architect

  • Full-time

Company Description

We are from US IT Solutions, an ISO Certified, E-Verify, WMBE Certified organization established in 2005 in CA. Our company is serving various State, Local and County Departments for over 10 years. USITSOL has been helping clients innovate across all phases of the application lifecycle for over a decade. Some of our prestigious clients are State of CA, State of OR, State of FL, State of NC, State of GA, State of CO, State of VA, State of AR, State of MI, State of OH, State of IL, State of MO, State of MS, California State University, Sacramento Area Sanitation Department, SMUD, Sound Transit, LA Superior Courts, District of Columbia, UMAS, University of Central Florida and Hennepin County and many more.

Job Description

  • PL/SQL and SQL developer with Oracle expereince 5
  • Understanding of Start Schema ata warehouses and data warehouse design 5
  • ETL script development and execution, including automation in a Linux / Oracle environment 5
  • Performance tuning and reconciliation of SQL quey execution 5
  • Familiar with Unix Shell Scripting 5

Qualifications

  • Experience developing report specifications from business requirements and executing the build to design 5
  • Experience with a mature data modelling tool such as ERWIN (preferred) 5
  • Experience with Oracle 12 enviornments 3

Additional Information

All your information will be kept confidential according to EEO guidelines.