Oracle BI OBIEE Star Schemas Dimensional Data Modelling SQL Server 20082012 Oracle   Requirement id 18537 Job title Developer Job location in ATL, GA Skills required PL/SQL, SQL * Plus, IT Development, Oracle BI OBIEE Star Schemas Dimensional Open Date 01-May-2014 Close Date Job type Contract Duration 11 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: PL/SQL, SQL * Plus, IT Development, Oracle BI OBIEE Star Schemas Dimensional Our client is seeking a Senior Reporting and Analytics Developer with solid experience and knowledge pertaining to designing and implementing enterprise level reports, with experience using Microsoft (SSRS), SAP (BO/WI, Crystal Reports) and Oracle(BI Publisher, Answers and Dashboard) . Candidate must be able to apply system solutions to business problems. The Enterprise Reporting and Analytics Team is composed of 3 report developers and a team leader. The team retires Microsoft SSRS reports, develops/modifies SAP Business Objects (v. 4)/Crystal Reports, and will be implementing Oracle BI Publisher/Answers & Dashboards (OBIEE with Exalytics) as a replacement. Approximately 30 SSRS reports need to be retired. Over 1000+ SAP reports are currently supported and will be assessed for retirement/replacement using Oracle technologies. Current reports utilize the enterprise data warehouse (Oracle Exadata) and connections to SQL Server and Oracle databases. The team develops enterprise reports within IT applications (internal/external) and on the web. Reports serve all facets of the transportation enterprise from financials, programs/projects, human resources, to federally required reporting. The team provides enterprise ad hoc access through SAP Business Objects Launch Pad. The team coordinates with client, server, network, and database/data warehouse personnel to integrate supporting IT architecture. Moving forward, ad hoc analytics/dashboards, geospatial (Esri) integration, and Microsoft Office add-in integration will also be implemented. The position end date is set for the end of the Georgia DOT fiscal year. Georgia DOT may exercise the option to renew contracts in one year increments. Several successful developers have continued working for several years with contract extensions. However, Georgia DOT is under no obligation to extend contracts and may terminate employment at any time. Responsibilities: Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP) Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques Design, develop, and document OBIEE repository/metadata Configures Ad Hoc query and Reporting environments Building geospatial reports/dashboards Developing MS Office based content using Oracle Office tools Assists in OBIEE administration, system maintenance, and upgrades Troubleshooting and resolving technical issues with minimal user disruption Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project Works with business users to gather reporting/analytics requirements Perform unit, system and integration testing Manage capacity and performance requirements Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams in collaborative design Provide design and development mentorship/cross-training with fellow team members Deliver solid, scalable, robust BI reporting/analytic solutions Assists in the administration and implementation of BI system/system security Prepare estimates of time for design and development Required Skills: 8+ years of IT development experience 5+ years of experience in writing PL/SQL, SQL*Plus, etc. 5+ years of experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development 4 year Bachelors degree with preferred concentration in IT, data science, or business 2+ years of experience with star-schema, snowflake, FACT, and dimensional data modeling 2+ years of experience with   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 18537 while calling.   Other jobs in GA: Alpharetta (12), Atlanta (37), Conyers (2), Downtown Atlanta (1), Dublin (1), Duluth (5), Dunwoody (4), Lawrenceville (2), Norcross (4), PL/SQL job openings in ATL, GA Jobs List Senior ETL Developer - J-10-851-462 Create date: 12-Dec-2013 Client seeks an experienced professional for the position of Senior ETL Developer to support the Data Warehouse Project. This incumbent to this position will work with the business analyst to design and implement processes for sourcing data from various internal as well as external sources leveraging Operational Data Store and Data Mart concepts to.... (This job is for - OWB Jobs in GA ATL Developer - (in ATL, GA))    PL/SQL job openings in other states Jobs List VDOT Programmer Analyst 4/Datawarehouse (747993) Create date: 23-Oct-2024 **Hybrid Max Submittals by Vendor : 2 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 10/28/2024 Client Info : VDOT Description : ------------------------------------------------------ Data architect to provide data intake, data governance, data transfor.... (This job is for - datawarehouseSQL Jobs in VA Richmond Analyst - (in Richmond, VA)) NC FAST Senior Data Engineer (743008) Create date: 30-Jul-2024 Hybrid No of Submissions : 1 start date :08/12/2024 End date :08/08/2025 submission deadline : 08/06/2024 client info : NCDHHS-NCFAST Note: * Agency Interview Type: Either Webcam Interview or In Person * DHHS-ITD requires the services of Specialists in the ro.... (This job is for - job Jobs in NC Durham Engineer - (in Durham, NC)) NC FAST Data Engineer (735339) Create date: 28-May-2024 Hybrid No of Submissions : 1 start date :06/17/2024 End date :06/20/2025 submission deadline : 06/03/2024 client info : NCDHHS-NCFAST Description : The Department of Health and Human Services (DHHS) requires the a.... (This job is for - Oracle Jobs in NC Durham Engineer - (in Durham, NC)) VDOT System Analyst 2 (734662) Create date: 01-May-2024 No of Submissions : 2 Start date : 05/20/2024 End date : 06/30/2024 Submission deadline : 5/6/2024 Client info : VDOT Note : * Hybrid * Please submit candidates who already live in Richmond, VA * Long-Term position requires onsite 3 days a week at 1401 East Br.... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) NCDPI - Developer/Programmer- Senior (729402) Create date: 13-Mar-2024 Onsite start date :03/04/2024 End date :08/02/2024 submission deadline : 03/19/2024 client info : NCDPI Description : Full Stack .NET Developer to help Migrate legacy Applications. You will work on a small team to migrate lega.... (This job is for - ADONET Jobs in NC Raleigh Developer - (in Raleigh, NC))    PL/SQL job openings in GA Jobs List GDOT Esri ArcGIS Developer 2 (740541) Create date: 26-Jul-2024 * Hybrid No of Submissions : 2 Start date : 08/26/2024 End Date : 06/30/2025 Submission deadline : 08/09/2024 Client Info : GDOT - IT App Note: * Agency Interview Type : Either Web Cam or In Person Description : The Georgia Dept. of Transportation (GD.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) GDOT Esri ArcGIS Developer 3 (740540) Create date: 26-Jul-2024 No of Submissions :2 Start date :08/26/2024 End Date :06/30/2025 Submission deadline :08/09/2024 Client Info :GDOT - IT App Note: * Agency Interview Type:Either Web Cam or In Person * Hybrid Description : The Georgia Dept. of Transportation (GDOT) is seeki.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) Developer - 62266 Create date: 21-Feb-2024 Start date : 03/13/2024 End date : 07/12/2024 Submission deadline : 03/13/2024 Client info : ATL - AIM General Note : * Position Location : Hybrid Description : The City of Atlanta stands at the forefront of innovation and.... (This job is for - job Jobs in GA Atlanta Developer - (in Atlanta, GA)) GDOT - OBIEE Developer (678600) Create date: 28-Mar-2022 Start Date : 05/02/2022 End Date : 06/30/2022 Submission Deadline : 04/01/2022 Client Info: GDOT - IT App Note: * Agency Interview Type: Either Web Cam or In Person Description: The Georgia Department of Transportation is seeking an Oracle Business.... (This job is for - Obiee Jobs in GA Atlanta Developer - (in Atlanta, GA)) GDOT Database Developer (676744) Create date: 25-Feb-2022 Start Date :03/28/2022 End Date :06/30/2022 Submission Deadline: :03/2/2022 Client Info: GDOT - IT App Note : * Agency Interview Type: Either Web Cam or In Person Description: Job Summary: Under direct supervision, provides assistance in monitor.... (This job is for - ETL Jobs in GA Atlanta Developer - (in Atlanta, GA)) (Developer: PL/SQL, SQL * Plus, IT Development, Oracle BI OBIEE Star Schemas Dimensional in ATL, GA)

Featured Jobs Z/Os Specialist (Jobs in Raleigh, North Carolina) Problem Analyst (Jobs in Chelsea, Massachusetts) SQL PostgreSQL Analyst (Jobs in Atlanta, Georgia) PEOPLESOFT Customer Analyst (Jobs in Atlanta, Georgia) TCL Consultant (Jobs in Jackson, Mississippi) Email Supervision Administrator (Jobs in Nashville, Tennessee) LMS MS Developer (Jobs in Durham, North Carolina) Communication Process Manager (Jobs in Lincoln, Nebraska) Healthcare Specialist (Jobs in Raleigh, North Carolina) Application Developer (Jobs in Richmond, Virginia)