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 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)) NCDWS Business Analyst- Expert (716437) Create date: 04-Aug-2023 Hybrid Start date :08/18/2023 End Date :08/17/2024 Submission deadline :08/04/2023 Client Info :NCDWS Description : ------------------------------------------------------ The RESEA/EAI Business Analyst will take the lead in working with our partner agency to restart our process that r.... (This job is for - job Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Data Warehouse Developer III -118230-SP Create date: 17-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline :May 19th at 4:00PM CST Client Info : Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortly after .... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Developer III -118228-SP Create date: 17-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline :May 19th at 4:00PM CST. Client Info : Note : INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortly after.... (This job is for - Jobs in WI Madison Developer - (in Madison, WI)) Business Intel Technical Lead IV - 111390 - SP Create date: 09-Nov-2022 start date:11/21/2022 End date:06/30/2023 submission deadline:11/11/22 at 4:00PM CST client info : UW - Madison Note: * Interview Process: Remote, Microsoft Teams * Duration: 2 year contract with possible renewal of 1 year. * Onsite or Remote: Fully remote * Addit.... (This job is for - Business IntelligenceAWS Jobs in WI Madison TechLead - (in Madison, WI))    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 SDLC Developer (Jobs in Denver, Colorado) Help Desk Detail Engineer (Jobs in Columbus, Ohio) Groovy CI/CD Critical Developer (Jobs in Des Moines, Iowa) Oral Manager (Jobs in Raleigh, North Carolina) Auditing Testing Written Analyst (Jobs in Madison, Wisconsin) Supervision Consultant (Jobs in Nashville, Tennessee) TOGAF REST Architect (Jobs in Denver, Colorado) Hipaa Communication Architect (Jobs in Chesterfield, Virginia) Help Consultant (Jobs in Madison, Wisconsin) Kanban WIP Problem Consultant (Jobs in Cincinnati, Ohio)