Data Warehouse Architect

US IT Solutions Inc; Richmond (VA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT solutions provider is looking for a PL/SQL and SQL developer with strong Oracle experience. The candidate should have skills in data warehouse design, ETL script development, and SQL performance tuning. The role demands familiarity with Unix Shell Scripting and experience in developing report specifications from business requirements. Join this dynamic team in Richmond, Virginia and contribute to innovative IT solutions for various government clients.

Qualifications

• Experience developing report specifications from business requirements.
• Familiarity with ETL script development and execution.
• Understanding of data warehouse design and Star Schema.

Responsibilities

• PL/SQL and SQL development with Oracle experience.
• Performance tuning and reconciliation of SQL query execution.
• ETL script development and automation in a Linux/Oracle environment.

Skills

PL/SQL development

SQL execution

Unix Shell Scripting

Tools

Oracle 12

ERWIN

Job 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 experience
• Understanding of Star Schema data warehouses and data warehouse design
• ETL script development and execution, including automation in a Linux / Oracle environment
• Performance tuning and reconciliation of SQL query execution
• Familiar with Unix Shell Scripting

Qualifications

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

Additional Information

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