Job Description :
Title: Senior Programmer Analyst ETL ODI Toad Oracle PL/SQL
Client: State of Nevada
Agency: Department of Transportation
Length: 12 months (possibility of extension)
Types: USC, GC, H1B, EAD
Interview: Phone or WebEx
Prime scope:
Analyze the current Nevada Citation and Accident Tracking System (NCATS) model, re-design, and implement an updated model with improvements to data collection and data management, database and data mart design, and the associated system and application interfaces. There will be approximately 70% development and 30% data modeling. The 70% comes from the re-engineering/discovery/redesign that needs to be done. The agency uses Oracle Data Integrator (aka ODI) for ETL purposes. The agency uses Toad and SQL Developer for data modeling purposes.
Special considerations: Candidates with experience in Department of Transportation and any similar Accident Tracking System
Strong knowledge with five (5) years’ experience using Oracle 11g with PL/SQL in a Windows based environment and strong knowledge with experience using SQL Server 2014
Three (3) years’ experience in business and technical requirements gathering and translating those requirements into effective data design
Five (5) years’ experience in the implementation of data marts, data mart lifecycles, and systems using data marts is essential
Three (3) years knowledge of Oracle Business Intelligence Enterprise Edition Suite (OBIEE, 11g); Oracle Data Integrator (ODI), TOAD is essential
Five (5) years knowledge of PC-based data tools (MS Excel, MS Access and XML file formats); and
Excellent English written and verbal communication skills.
Desirable knowledge with experience using Oracle 12c
Ensure a data model that services appropriate application interfaces (both read and write)
Ensure a data model that services appropriate reporting interfaces (read)
Ensure data model that secures Personal Identifying Information (PII)
Database correctly loaded with appropriate data
Data mart or data warehouse designed per standards of OBIEE and ODI
Extract Load, Transform (ELT) and business rules via Oracle Data Integrator (ODI)
Supporting Oracle Business Intelligence Enterprise Edition, 11g (OBIEE, 11g
Supporting Microsoft Power BI

Client : U