Job Description
Location: Remote with some travel to California (California candidates preferred)
Work Hours: 9-5pm PST
Duration: 12 months
Requirements:
Stack used:
First Project - OBI Metadata Improvement:
Phase 1
Phase 2
Second Project - ED PI Data Quality Improvement:
Qualifications
Location: Remote with some travel to California (California candidates preferred)
Work Hours: 9-5pm PST
Duration: 12 months
Requirements:
Deep experience with large data sets and managing deltas
Experience across multiple big data platforms (Hadoop, Hortonworks, MapR, Cloudera, AWS, GCP, etc.)
5+ years of experience
Develop database solutions to store and retrieve company information
Install and configure information systems to ensure functionality
Analyze structural requirements for new software and applications
Migrate data from legacy systems to new solutions
Design conceptual and logical data models and flowcharts
Improve system performance by conducting tests, troubleshooting and integrating new elements
Stack used:
DW – Oracle 19C
ODI – Oracle Data Integrator
SSIS to push data into Oracle DW
OSI PI
First Project - OBI Metadata Improvement:
Phase 1
Currently the tables have not details/definitions about the table, columns etc.
Oracle Database
Identify tool where to save the details/definitions.
Populate the details for all databases with relevant details.
Phase 2
Application Component Dependency Mapping
Identify which applications are accessing which data from which databases and the data flow.
Identify tool/system to capture this information
Populate this data in the identified system/tool.
Second Project - ED PI Data Quality Improvement:
This team is expected to help build Data Quality detection algorithms
Original they used SQL Server environment but is now all in Oracle.
Optimize new and current database systems
Define security and backup procedures
Provide operational support for Management Information Systems (MIS)
Additional Information
All your information will be kept confidential according to EEO guidelines.