Data Warehousing Metadata Oracle 11g Developer (Jobs in Sacramento, CA)   Requirement id 106338 Job title Developer Job location in Sacramento, CA Skills required Data Integration, Data Warehousing, Metadata, Oracle 11g Open Date 04-May-2020 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Data Integration, Data Warehousing, Metadata, Oracle 11g Note: Email Submission Note: Vertical: 4.0 Information Services Project Role: Data Integrator/Developer Consultant(s) needed for the Letter of Engagement: One (1) consultant Number of Hours: 2012 hours Submission Deadline: 5/11/2020 5:00 PM PST Start Date: 7/1/2020 End Date: 6/30/2021 Client: California Public Employees Retirement System (CalPERS) Description: Project Scope/Tasks The consultant will develop dimensional models, transformation solutions and provide data integration services. The data integrator role provides technical expertise to perform data integration services that support the data warehouse and reporting. These services include software changes and environment maintenance and operations. This consultant will assist staff with data architecture, modeling, data integration, and metadata modeling, dashboard development for the INVO Enhanced Management Reporting Solution. Reporting needs to be flexible to changes in the organizational structure of the Investment Office to react in a timely manner and to make sound business assumptions in real time. The solution is designed to leverage automation to prevent and limit the amount of manual data manipulation. Specific project releases of the INVO Enhanced Management Reporting development and support that will be developed by the consultant are (a) allocation of branch expenses to assets under management, (b) allocation of external management fees to functional groups, (c) allocation of branch expenses to positions, (d) data quality validation of external billing feeds, (e) data quality validation of State Controllers Office payroll data feeds and the reconciliation of said data with the accounting data feeds, (f) Cost Effectiveness Measurement (CEM) reporting support, (g) FITS integration and (g) maintenance of functionality and features released previously. The software to be used is Oracle Data Integrator 11g. The solution involves multiple external data feeds, rule-based data quality validation checks, master data management and machine learning. The consultant will be required to work under the direction of the CalPERS Enterprise Analytics and Data Services Manager, work closely with ITSB staff and the Investment Finance Services team. The consultant(s) will also maintain technical documentation and provide knowledge transfer to CalPERS technical staff. Additional Tasks: • Work on other projects (i.e., data marts, data warehouse, data platform maintenance) in addition to the INVO Enhanced Management Reporting Development and Support project. The purpose of this role is to provide necessary support to meet CalPERS business data objectives. • Translate data requirements into technical specifications, development of dimensional models and validate the data warehouse meets specified requirements. • Improve the long-term ability to provide increasing complex analytics in support of the INVO management team. • Attend project, staff, and management meetings as required. • Record work hours daily in required time tracking tools. • Submit monthly status report with invoices.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 106338 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2), Data Integration job openings in Sacramento, CA Jobs List CalPERS 2019-0151 INVO EMRDS 2 -Sr Technical Specialist -SP Create date: 29-May-2020 Note: Email Submission Note: Vertical: 5.0 Application Development Project Role: Senior Technical Specialist Consultant(s) needed for the Letter of Engagement: One (1) consultant Number of Hours: 2012 hours Submission Deadline: 6/5/2020 5:00 PM PST Start Date: 7/1/2020 End Date: 6/30/2021 .... (This job is for - Data Warehousing Jobs in CA Sacramento Specialist - (in Sacramento, CA))    Data Integration job openings in other states Jobs List Data Warehouse Developer III - 138298 Create date: 18-Dec-2024 No of Submissions : 2 Start date : 01/20/2025 End Date : 06/30/2025 Submission deadline : 12/27/2024 4:00:00 PM Client Info : UW - Madison Note: * Interview Process: First round spark hire video questions (online video answer interview program), final round full committee. job Jobs in WI Nashville Developer - (in Nashville, WI)) VDOT Business Analyst 4 (742717) Create date: 23-Jul-2024 * Hybrid No of Submissions : 2 Start date : 07/29/2024 End Date : 06/30/2025 Submission deadline : 7/26/2024 Client Info : VDOT Note: * Agency Interview Type : Both Phone and In Person * This position requires onsite 3 days a week with 2 remote * Lo.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) NCDST - Developer/Programmer- Senior (737625) Create date: 31-May-2024 Onsite No of submissions : 2 Start date :06/24/2024 End date :06/30/2025 Submission deadline : 06/06/2024 Client info : NCDST Note : * This is an onsite position. Description : The NC State Treasurer, Stat.... (This job is for - Dataverse Jobs in NC Raleigh Developer - (in Raleigh, NC)) AGE - Integration Engineer (737151) Create date: 16-May-2024 No of Submissions : 3 start date : 05/27/2024 End date : 06/30/2024 submission deadline : 05/20/2024 client info : AGE Description : All contractor roles at ODA are hybrid and require 2 days inthe office (Downtown Columbus Oh.... (This job is for - job Jobs in OH Columbus Engineer - (in Columbus, OH)) VDOT Sr Oracle Database Developer (725963) Create date: 03-Jan-2024 Hybrid start date :01/16/2024 End date :06/30/2024 submission deadline : 1/9/2024 client info : VDOT Description : *Local Richmond candidates due to onsite work requirement *ONSITE interviews only *Candidates must be willing an.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA))    Data Integration job openings in CA Jobs List Data Analyst - 40609 Create date: 19-Nov-2018 Candidate must be our own W2 Employee We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : Our large eCommerce client is looking for a Data Analyst to join their Ad Operations Team in San Bruno! Workload includes managing 80-100 campaigns, and data analysis to execute su.... (This job is for - job Jobs in CA SanBruno Analyst - (in San Bruno, CA)) Sr ETL Developer (4) - ASE6 - 33378 Create date: 05-Apr-2018 Client Info : Wells Fargo Wholesale - CA Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems Job Description : Client: (Financial Services Industry) Location: San Francisco Duration: 2 Years Rate: DOE Summary: .... (This job is for - job Jobs in CA SanFrancisco Developer - (in San Francisco, CA)) Sr ETL Developer (2) - 32166 Create date: 21-Feb-2018 Client Info : Wells Fargo Wholesale - CA Candidate must be our W2 Employee Candidates RTR form should be only on the name of APEX Systems Job Description : Top 3 Requirements: 1. 6+ years of Informatica PowerCenter 2. Data integration using PowerCenter 3. Oracle .... (This job is for - job Jobs in CA SanFrancisco Developer - (in San Francisco, CA)) Architect / Sr. Engineers - 27348 Create date: 05-Sep-2017 Candidate must be our W2 Employee Job Description : Technologies Utilized: Oracle OFSAA FSDF, Ab Initio, Informatica, Hadoop/MapR Architects that exhibit competency in designing, creating, deploying and managing the go-forward data architecture, with focus on data solution adoption effort for modernization and data .... (This job is for - OFSAA Jobs in CA SanFrancisco Engineer - (in San Francisco, CA)) (Developer: Data Integration, Data Warehousing, Metadata, Oracle 11g in Sacramento, CA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)