PLSQL Data Structures OWB ERwin Developer (Jobs in BALTIMORE, MD)   Requirement id 15536 Job title Developer Job location in Baltimore, MD Skills required Data Warehouse, Oracle 10g And 11g, SQL, PLSQL Data Structures OWB ERwin Open Date 17-Sep-2013 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type Face to Face interview Apply    Email Recruiter: coolsoft Job Description Developer: Data Warehouse, Oracle 10g And 11g, SQL, PLSQL Data Structures OWB ERwin Oracle WareHouse Builder (OWB) Developer 6+ Month Contract Baltimore, MD Scope of Work: 1) Application Programmer with extensive 3N relational form, star schema, data modeling, and ETL development experience to help an inter-agency team define the operational data stores, star schemas, and ETL processes. Duties & Responsibilities: 1. Analyze complex education accountability and performance reporting requirements with end users 2. Prepare data models that support the creation of education data structures, KPI development, and ETL development in Informatica and Oracle 11g using ERWIN 3. Develop complex ETL workflows 4. Write ETL requirements and specifications documents 5. Develop, test, and install ETL programs to maintain and transform data between various systems 6. Develop Source To Target Mappings (STM) 7. Perform data profiling as inputs to the STM design 8. Develop Data Quality processes to improve data quality and provide Deterministic Identity Resolution 9. Design and implement cross reference and lookup tables 10. Develop data lineage reports from the repository 11. Transform unstructured and poorly structured data into 3rd Normal Form tables with referential constraints 12. Aggregate and transform 3rd Normal Form data into multi-dimensional STAR schema Dimension and Fact table structures Required Skills/Knowledge/Experience (from the Req): - Minimum of six (6) years of experience designing and developing data warehousing database star schemas, 3N data form databases using Oracle 10 g and 11g relational database management systems - Minimum of three (3) years of experience with the Oracle OWB- suite of tools, designing and implementing ETL workflows - Minimum of six (6) years of experience programming in SQL and PL/SQL - Minimum of four (4) years of experience analyzing user requirements and translating them into system data structure designs and Source-To Target-Mappings (STMs) - Minimum of two (2) years of experience installing and administrating an OWB-ETL application environment - Minimum of two (2) years of experience using ErWin design tools to create both logical and physical entity relationship (ER) diagrams - Minimum of one (1) year of experience working at a State or Local Education Agency   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 15536 while calling.   Other jobs in MD: Annapolis (1), Baltimore (34), Baltimore Maryland (1), Beltsville (3), Downtown Baltimore (1), Elkridge (1), Frederick (2), Hanover (1), North Baltimore (2), Owings Mills (1), Rockville (1), Sparks (2), Timonium (4), Woodlawn (7), Data Warehouse job openings in Baltimore, MD Jobs List BI Developer - J-11-051-418 Create date: 12-Nov-2015 NOTE : Start Date : 10/12/2015 End Date : 01/12/2016 Submission Deadline : 11/18/2015 Client Info : COMSYS Description: Canton area, MD (East side of Baltimores inner Harbor) Job Description: Responsibilities: * This resource will analyze and design informat.... (This job is for - SASProgrammer Jobs in MD BALTIMORE Developer - (in Baltimore, MD)) Solutions Analyst BI- Qlikview And Tableau - J-11-023-927 Create date: 25-Jun-2015 Note: Start Date : 07/13/2015 End Date : 01/15/2016 Submission Deadline : 07/01/2015 Client Info : COMSYS Description: Solutions Analyst II (Business Intelligence Developer, Qlik) The Equity Portfolio Management Business Intelligence and Analytics team i.... (This job is for - Business Intelligence Jobs in MD BALTIMORE Analyst - (in Baltimore, MD)) ETL SPECIALIST - OWB Developer - J-10-832-963 Create date: 09-Oct-2013 Oracle Warehouse Builder/ETL Developer Skype or face to face interview to hire Start Date (10/14 or ASAP) Should be well versed in design and development of ETL processes for large Data warehouse as well support production code base. Should be able to work independently with other IT support as well us users for ope.... (This job is for - OWB Jobs in MD BALTIMORE Developer - (in Baltimore, MD))    Data Warehouse job openings in other states Jobs List Data Warehouse Architect 5 - 144093 Create date: 27-Jun-2025 Start date : 07/28/2025 End Date : 09/30/2025 Submission deadline : 7/3/2025 10:00:00 AM Client Info : DHHS Note: * Interview Process: Virtual Interviews via MS Teams. A screenshot photo of candidate will be required for any interviews as well as a vendor present at beginning of virtual i.... (This job is for - job Jobs in MI Lansing Architect - (in Lansing, MI)) Data Warehouse Developer III - 143070 - Rebid Create date: 27-May-2025 Start date : 07/01/2025 End Date : 06/30/2026 Submission deadline : 5/29/2025 4:00:00 PM Client Info : DCF Note: * INTERVIEW NOTES: • Phone and web based interviews will be acceptable. • However, an in--person interview may be required. • Interviews will be set up shortl.... (This job is for - Architecture Jobs in WI Madison Developer - (in Madison, WI)) Data Warehouse Architect 5 - 139883 Create date: 07-Feb-2025 No of Submissions : 1 Start date : 03/10/2025 End Date : 09/30/2025 Submission deadline : 2/14/2025 10:00:00 AM Client Info : DHHS Note: * Will close submissions on: 2/14 at 10am EST. * Interview Process: Virtual interviews are anticipated for this position. A screen.... (This job is for - Teradata Jobs in MI Lansing Architect - (in Lansing, MI)) Certified Project Manager IV/Sr. -136881(REBID) Create date: 31-Oct-2024 No of Submissions : 1 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 11/4/2024 4:00:00 PM Client Info : ETF Note: * Interview Process: MS Teams * Duration of Contract: 6/30/2025, with potential for extension * Onsite or Remote: Candida.... (This job is for - BI Jobs in WI Madison Manager - (in Madison, WI)) GTRI Sr. Data Architect (748151) Create date: 01-Oct-2024 No of Submissions : 2 Start date : 11/04/2024 End Date : 06/30/2025 Submission deadline : 10/04/2024 Client Info : GTRI-Enterprise Systems Department Note: * Agency Interview Type : Either Web Cam or In Person * Hybrid * Plans and schedules team resources, sta.... (This job is for - ArchitectingAnalytics Jobs in GA Atlanta Architect - (in Atlanta, GA))    Data Warehouse job openings in MD Jobs List AWS Cloud Data Engineer - NTTJP00023737 Create date: 22-Jul-2019 start date:8/1/2019 End date:12/31/2019 submission deadline:7/29/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 ab.... (This job is for - Snowflake Jobs in MD HuntValley Engineer - (in HUNT VALLEY, MD)) Oracle Database Developer - 46278 Create date: 19-Apr-2019 Candidate must be your W2 Employee. We should submitt only GC, GC EAD, L2 EAD, H4 EAD and Citizen. Job Description : Client: DCCA Oracle Database Developer Columbia, MD Key Tasks (Major duties and responsibilities of the position). Implement logical data ba.... (This job is for - job Jobs in MD Columbia Developer - (in Columbia, MD)) SSIS Developer - J-11-293-150 Create date: 24-Jan-2018 SSIS Developer Experis IT has a contract-hire opportunity for a SSIS Developer to support a fast growing Health IT company based in Columbia, MD. Our client specializes in data system solutions for State and Local Governments. Our client offers a competitive base salary, medical, dental, generous PTO schedule, and 401K. If you are a exper.... (This job is for - SSISDeveloper Jobs in MD COLUMBIA Developer - (in Columbia, MD)) Sr. SSIS ETL DataWarehouse Developer - J-11-203-923 Create date: 07-Feb-2017 Start Date : 02/27/2017 End Date : 12/30/2017 Submission Dead Line : 02/13/2017 Description : Need experienced, senior level ETL developers who have designed and developed data warehouses/marts/ODS using SSIS. QA experience testing ETLs and data loaded into the DW against source systems and various s.... (This job is for - Niche Jobs in MD HANOVER Developer - (in Hanover, MD)) SSIS Developer - J-11-169-702 Create date: 05-Oct-2016 Start Date: 10/10/2016 End Date: 12/31/2016 Submission Dead Line: 10/11/2016 Description: What is the specific title of the position? SSIS Package Developer for SQL 2014 What Project/Projects will the candidate be working on while on assignment? Data Center Migration. HouseCalls is.... (This job is for - SAS Jobs in MD HANOVER Developer - (in Hanover, MD)) (Developer: Data Warehouse, Oracle 10g And 11g, SQL, PLSQL Data Structures OWB ERwin in Baltimore, MD)

Featured Jobs Web Analyst (Jobs in Lansing, Michigan) AgileScrum Analyst (Jobs in Lansing, Mississippi) Dataverse SharePoint SECURITY Analyst (Jobs in Richmond, Virginia) SDLC Developer (Jobs in Richmond, Virginia) - Consultant (Jobs in Austin, Texas) Team Consultant (Jobs in Wauwatosa, Wisconsin) MS Office SharePoint Stakeholders Analyst (Jobs in Columbia, South Carolin - Analyst (Jobs in Columbia, South Carolina) Java Hands Architect (Jobs in Madison, Wisconsin) Analysis Business Analyst (Jobs in Nashville, Tennessee)