Data Warehousing Business Intelligence ETL Processes Oracle Database 11G And Prior   Requirement id 107036 Job title Specialist Job location in Sacramento, CA Skills required Data Integration, Data Warehousing, Data Processing Systems, Business Intelligence ETL Processes Orac Open Date 29-May-2020 Close Date Job type Not specified Duration 12 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Specialist: Data Integration, Data Warehousing, Data Processing Systems, Business Intelligence ETL Processes Orac 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 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. Minimum Qualifications 1 Vendor must have participated in at least two (2) successful Business Intelligence and/or Analytics projects, one of which with a budget of at least $1 million 2 Must have a minimum of five (5) years experience in electronic data processing systems study, design, and programming; at least three (3) years of said experience shall have included responsibility on a project basis for analyzing operational methods and developing computer programs to meet desired results, at least two (2) years of said experience must have been at a high level both technically and in measure of responsibility. 3 Must have knowledge of electronic computer programming; electronic data processing equipment and its capabilities; principles and techniques of studying work processes for new or revised electronic computer applications; principles of designing methods of processing data; technical report writing; statistical methods. 4 Must have the ability to write complex programs and develop detailed program specifications. 5 Individuals must have participated in at least two (2) successful Business Intelligence and/or Analytics projects, one of which with a budget of at least $1 million 6 At least five (5) years of experience in some or all areas of Pension, Investments/Investment Management or Financial Services 7 At least three (3) years of experience performing tasks pertaining to data integration (ETL) processes to transform disp   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 107036 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 EMR Dvlmt And Support 2-Data Integrator/Developer-SP Create date: 04-May-2020 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 Clien.... (This job is for - Data Warehousing Metadata Jobs in CA Sacramento Developer - (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)) (Specialist: Data Integration, Data Warehousing, Data Processing Systems, Business Intelligence ETL Processes Orac 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)