PhiladelphiaRecruiter
the smart solution for Philadelphia jobs

Oracle OBIEE Architect

Company: PSCI
Location: Lafayette Hill
Posted on: February 16, 2019

Job Description:

We have an Oracle ArchitectDatabase Engineer role for a client in Lafayette Hill, PA. They are open to contract, contract to hire or full-time (they will do H1 transfers). Our client is ideally looking for candidates with Oracle Cloud, OBIEE and BICS experience. The must haves are ETL, strong Oracle and ideally some SQL Server experience. Our client is working on a large-scale data project that is being populated by multiple ERP systems and Oracle HCM. The data is being extracted using SSIS but experience with other ETL tools is fine. The Database Architect is responsible for performing business intelligence functions related to data warehouse, ETL and reporting designs, business intelligence infrastructure and delivery of business intelligence service to end users, in accordance with company policies and procedures. Knowledge, Skills, and Abilities Understanding of relational database theory, principals and industry leading practices. Familiarity with data warehousing and relationaldimensional modeling. Mastery of ETL processes and concepts. Experience in database performance optimization. Expertise in MS SQL SSISSSAS Technologies as well as SSRS. Strong background in writing SQL scripts, complex queries and aggregate functions. Experience with Oracle BI or other reporting tools. Experience with cloud architecture and complex data structures. Design experience in data model, Star Schema and Oracle BI RPD is preferred. OBIEE, BICS or OACS interface experience is preferred. Experience with Kourier (Kore) ETL tool preferred. Strong knowledge in data analytics. Ability to quickly adapt and learn new technologies. Must be highly organized and detail-oriented. Excellent communication skills. Must be able to multi-task. Utilizes Vendors, Profit Centers and the Internet when additional information is needed. Job Duties Participate in the analysis and design of enterprise data warehouse andor databases by applying current data warehouse methodologies and data modeling techniques. Design, develop, optimize, maintain and support ETL processes using Stored Procedures and data integration tools such as Microsoft SSIS. Develop the ETL andor reporting application code based on documented requirements Create, execute, and document unit test plans for ETL and data integration processes and programs. Design and implement the data loading (ETL) and publishing processes within the databaseData warehouseBusiness Intelligence environment. Maintain and ensure integrity of data through SQL transformations, cleansing and constraints Routinely propose improvements to database processes andor structures to improve supportability or usability and system performance. Responsible for on-call rotation to monitor alerts and re-mediate any occurrence of database or data system outage. Work with business users for continuous improvement of existing reporting and analytics to drive effective business improvement. Provide end-user support, including direct interaction with users, service desk support, and development of documentation, job aids and training guides. Translate business requirements and any changes or additions to business intelligence framework into technical design specifications for implementation and documentation purposes. Develop Oracle BI Repository (RPD) ndash logical columns, hierarchies, subject areas. Develop and configuration of Kourier server for importing data from our ERP into data warehouse. Knowledge, Skills, and Abilities Understanding of relational database theory, principals and industry leading practices. Familiarity with data warehousing and relationaldimensional modeling. Mastery of ETL processes and concepts. Experience in database performance optimization. Experience in writing SQL scripts, complex queries and aggregate functions. Experience with Oracle BI or other reporting tools. Experience with cloud architecture and complex data structures. Design experience in data model, Star Schema and Oracle BI RPD is preferred. OBIEE, BICS or OACS interface experience is preferred. Experience with Kourier (Kore) ETL tool preferred. Strong knowledge in data analytics. Ability to quickly adapt and learn new technologies. Must be highly organized and detail-oriented. Excellent communication skills. Must be able to multi-task. Utilizes Vendors, Profit Centers and the Internet when additional information is needed. Education, Training, Experience Required Bachelorrsquos Degree in Information Technology or related field and 3-5 years of experience in ETL development, or an equivalent combination of education and experience. 5+ yearsrsquo experience PLSQL, MS SQL SSIS , T-SQL. 2+ years in data warehouse conceptsarchitecture in high volume, real-time transactions and batch ETL jobs. Experience working with high volume data exchange and integrating large structured and unstructured data in multiple formats, character sets, and delivery methods. Experience working with a relational database using SQL (MS SQL or Oracle preferred). Preferred College degree or equivalent Experience with Oracle ERP cloud, OBIEE, RPD, OACS BICS

Keywords: PSCI, Philadelphia , Oracle OBIEE Architect, IT / Software / Systems , Lafayette Hill, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Entry Level Software Engineer - New Brunswick
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: New Brunswick
Posted on: 02/16/2019

Java Developer (OPT & H4 EAD only)
Description: Java Lead Developer position in Harrisburg, PA. Duration: 12 monthsInterview: Face to Face Must have excellent communication skills . Java Enterprise Technical LeadCLIENT is seeking an enterprise level (more...)
Company: Manu MediSoft Inc
Location: Harrisburg
Posted on: 02/16/2019

Senior Java Developer
Description: br br br Want to see your ideas in action br br We do too.Senior Java Developer br br Wilmington, DE br br If you like building innovative solutions, you'll fit in perfectly at CSC (more...)
Company: CSC
Location: Wilmington
Posted on: 02/16/2019


Genesys Developer
Description: Genesys Developer ul li Extensive hands
Company: Nityo Infotech Corporation
Location: Wilmington
Posted on: 02/16/2019

.Net Developer
Description: Title: .Net DeveloperLocation: Wilmington ,DEDuration:6 monthsTechnical Skills:Must have ul li Must have at least 6 to
Company: Futran Solutions
Location: Wilmington
Posted on: 02/16/2019

Sr. Java Developer / JAVA Lead(9+ years)
Description: Hi, Trust you are doing great This is regarding a job opportunity with our client. Below is the
Company: ITBMS Inc.
Location: Camden
Posted on: 02/16/2019

Unix Administrator
Description: Job Overview PHEAA is seeking a UNIX Administrator to join their team. This position is responsible for the day-to-day support and administration of virtualized Unix environments in both on-prem and Cloud/AWS (more...)
Company: PHEAA
Location: Harrisburg
Posted on: 02/16/2019

12368 : Java Full stack developer (Programmer Analyst)
Description: Java Full stack Developer-- Programmer Analyst Location:-- Wilmington Delaware Rate: Open Visa: Open Experience preferred - Senior
Company: NAM Info Inc
Location: Wilmington
Posted on: 02/16/2019

Talend Developer
Description: Title: Talend Developer Location: Reading, PA Duration: Contract/
Company: keylent inc
Location: Reading
Posted on: 02/16/2019

Current College Students - University Programs: Software Engineering Intern
Description: Great opportunity for current college students entering their Junior or Senior year by Fall 2019 or college graduate students entering or currently enrolled in a graduate program by Fall 2019. If (more...)
Company: Raytheon
Location: Harrisburg
Posted on: 02/16/2019

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Philadelphia RSS job feeds