Performance Tuning Data Warehouse Development Data IntegrationETL Software ToolS D   Requirement id 47415 Job title Developer Job location in Harrisburg, PA Skills required Oracle Development, Complex SQL, PL/SQL, Performance Tuning Data Warehouse Develo Open Date 20-Jul-2015 Close Date Job type Not specified Duration 2 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Developer: Oracle Development, Complex SQL, PL/SQL, Performance Tuning Data Warehouse Develo Description: ** [ Note: Either Go To Meeting Web Cam or In Person interview] The position serves as a senior data warehouse developer in clients Bureau of Business Solutions & Services. Position Description: The position serves as a senior data warehouse developer in clients Bureau of Business Solutions & Services. The incumbent will perform new development and maintenance for an enterprise data warehouse built on an Oracle 11g platform. This individual will also do analysis, design, and development of ETL using Oracle PL/SQL and Informatica PowerCenter 9.5. The incumbent will develop and maintain tables, create views, write queries, build PL/SQL packages, write stored procedures, triggers and functions, and design and develop complex ETL processes. Responsibilities also include data modeling, primarily dimensional modeling. Technologies leveraged include Oracle 11g, PL/SQL, Informatica PowerCenter 9.5, and Erwin 7.3 Specific Duties: 1. Meet with end users and technical staff to gather data requirements 2. Perform intensive data analysis on source system data bases. Analyze and understand source system database, find required data, and profile the data. 3. Review and create dimensional and normalized data models. 4. Develop Oracle SQL and PL/SQL code, including packages, procedures, functions, views and complex analytical queries. 5. Develop complex ETL using Oracle PL/SQL and Informatica PowerCenter 6. Diagnose, analyze, troubleshoot and choose appropriate solution to fix data related issues. Required Skills and Experience 1. Required: 7+ years Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning 2. Required: 5+ years data warehouse development experience 3. Required: 5+ years of data modeling experience 4. Required: 2+ years dimensional modeling experience 5. Required: 3+ years experience using data integration/ETL software tool(s) 6. Required: Strong oral and written communication skills 7. Desired: 2 years Informatica PowerCenter ETL development experience 8. Desired: 2 years MS SQL Server and/or DB2 experience 9. Desired: 1 year experience with Business Objects BI Tool suite or comparable BI tool suite Required Skills: * Oracle development experience that includes writing complex SQL and PL/SQL, and doing performance tuning * Data warehouse development experience * Review and create dimensional and normalized data models * Experience using data integration/ETL software tool(s) * Dimensional modeling experience * MS SQL Server and/or DB2 experience * Strong oral and written communication skills Desired Skills: * Informatica PowerCenter ETL development experience * Experience with Business Objects BI Tool suite or comparable BI tool suite   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 47415 while calling.   Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),    Oracle Development job openings in other states Jobs List Application Architect II -104922 -SP Create date: 26-May-2022 Start date :7/1/2022 End Date : 12/31/2022 Submission deadline :5/30/2022 4:00PM CST Client Info : Note : * Interview Process: N/A * Duration: Dec 31, 2022 * Onsite or Remote? Local candidates. Hybrid of both onsite and remote. Description : POSITION DESCRIPTION.... (This job is for - job Jobs in WI Madison Architect - (in Madison, WI)) Expert Software Developer- 6116 Create date: 02-Mar-2022 Description: Day-to-Day Tasks include, but not limited to: Assist with maintenance of expanding vendor- Secure Scans current access to our Disability Systems and folders to allow them to receive all incoming documents in reference to Disability Claims and to begin basic data entry for DB and PFL Claims Intake, thus increas.... (This job is for - job Jobs in NY Albany Developer - (in Albany, NY)) Oracle Developer - 4313 Create date: 06-Nov-2020 start date:12/21/2020 End date:12/21/2021 client info : NYS Office of the Attorney General Description: Analyze user requirements, design, and develop solution. Maintain existing business process flow using Oracle BPM, SOA, ADF. .... (This job is for - job Jobs in NY Troy Developer - (in TROY, NY)) PL SQL Developer - Create date: 16-Jan-2020 Job Description : 5+ years pl/sql oracle development Experience with 11G is a must, but 12c or exidata is preferred Ability to create complex queeries Ability to understand large data sets and create report Day to Day Responsibilities/project specifics: This is for the onboarding initiative. .... (This job is for - job Jobs in NC Charlotte Developer - (in Charlotte, NC)) Oracle PL/SQL Developer - NTTJP00021489 Create date: 30-May-2019 start date:7/5/2019 End date: 04/03/2020 submission deadline:6/10/2019 Description: we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees are key factors in our companys growth, market presence and our abi.... (This job is for - job Jobs in NY Albany Developer - (in Albany, NY))     (Developer: Oracle Development, Complex SQL, PL/SQL, Performance Tuning Data Warehouse Develo in Harrisburg, PA)

Featured Jobs DHCP LANWAN Analyst (Jobs in Atlanta, Georgia) JavaScript Communication Analyst (Jobs in Richmond, Virginia) Agile SCRUM Manager (Jobs in Madison, Wisconsin) Cisco LAN Manager (Jobs in Stafford, Virginia) Dataverse SQL Developer (Jobs in Raleigh, North Carolina) Data Developer (Jobs in Durham, North Carolina) SOAP JavaScript JSON SQL Administrator (Jobs in Salem, Oregon) MicrosoftOffice Consultant (Jobs in Golden, Colorado) GIT Automation Ansible Engineer (Jobs in Raleigh, North Carolina) SCRUM Azure Analyst (Jobs in Lansing, Michigan)