Tech Evaluation Login
Tech Evaluation Signup
PasswordReset
Unsubscribe
PasswordReset
PasswordReset
PasswordReset
Register for Webinar
Register for Event
Job Channels
Skill Score
About Us
Contact Us
Our Blog
Toggle navigation
Home
Skill Score
DemandIndex
Jobs
FETCH Jobs
Java J2EE
Dot Net, C#
DBA
SAP
Admin, Networking
Datawarehousing
QA
Demo
Candidate
Recruiter
Services
Job Posting & Resume Access
Integrated Talent Sourcing
Sub Contractor Supply Chain
Merger & Acquisition
Candidate
Post Resume
Login
Create Job Alert
Recruiter
Login
Free Trial
Signup
Pricing
| Pricing
Dashboard
My Resumes
Resume List
Add Resume
Edit / Update Resume
My Jobs
Fetch Jobs
Matched Jobs
Applied Jobs
Senior Programmer Analyst ETL ODI Toad Oracle PL/SQL
Carson City, NV
Carson City
NV
89721
Date
: Sep-22-17
2017-09-22
2018-09-22
Senior Programmer Analyst ETL ODI Toad Oracle PL/SQL
Carson City, NV
Sep-22-17
Work Authorization
US Citizen
GC
H1B
GC EAD
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect, Senior, Midlevel, Junior
Rate/Salary ($)
:
DOE
Duration
:
12
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Data Modeler
Permanent Direct Hire
Consulting / Contract
Third Party OK
FULL_TIME, CONTRACTOR
Required Skills
:
ETL, EDI, PL/SQL
Preferred Skills
:
data modeler
Domain
:
IT/Software, Financial, Government, HealthCare, Retail, Insurance, Pharmaceuticals, Manufacturing, Telecom
Work Authorization
US Citizen
GC
GC EAD
H1B
Preferred Employment
Corp-Corp
W2-Permanent
W2-Contract
1099-Contract
Contract to Hire
Job Details
Experience
:
Architect, Senior, Midlevel, Junior
Rate/Salary ($)
:
DOE
Duration
:
12
Sp. Area
:
Data Warehousing/ETL
Sp. Skills
:
Data Modeler
Permanent Direct Hire
Consulting / Contract
Third Party OK
FULL_TIME, CONTRACTOR
Required Skills
:
ETL, EDI, PL/SQL
Preferred Skills
:
data modeler
Domain
:
IT/Software, Financial, Government, HealthCare, Retail, Insurance, Pharmaceuticals, Manufacturing, Telecom
Ace Technologies
San Jose, CA
Post Resume to
View Contact Details &
Apply for Job
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
Requirements:
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
Turn OFF keyword highlights