Hi
Loc :.North Carolina *Description:* The Common Education Data Analysis and Reporting System (CEDARS) will be the first state level education data warehouse in North Carolina. It will collect data from roughly 23 systems of original entry and feed them into databases designed for both Operational and Longitudinal analysis. The position will be the primary Database Reports Developer for the CEDARS Reports Project and will require strong analysis with report writing DBA skills. As such, the candidate will be charged with understanding how data is mapped from source systems, through the Extraction Transform Load (ETL) process, to the data warehouse. Additionally, the candidate is expected to understand how data maps from source systems to the various DPI reports that are generated from the data warehouse. The candidate will be the key resource that DPI will depend upon to coordinate data structural changes with the CEDARS data warehouse vendor, including but not limited to the addition of new data fields from existing and new source systems, deletion of data fields from the data warehouse, and changes to the format of data fields in the data warehouse. Finally, this candidate will support the modification of existing CEDARS reports and the creation of new reports to meet end user business needs. *Knowledge, Skills, and Abilities Requirements:* Minimum 3 years skills/knowledge/experience with the following: • Report Writing, with experience using Oracle Business Intelligence Enterprise Edition (OBIEE) tools. • Data Warehousing schema and concepts • Extraction Transform Load (ETL) processing • Database-to-Enterprise Service Bus (ESB) integration • Database design and Database modeling • Creation of data marts • Connectivity of database infrastructure to other system components & applications • Database Performance Analysis and database performance tuning, particularly for Data Warehouse database configurations. • SQL tuning • Ability to effectively provide technical documentation • Ability to work independently • Possess good organization and communication skills. Must possess traits that are critical for successful performance in this position: Reliability, initiative, attention to detail and professionalism. Preferred: • Prior use of automated software/bug-tracking software • Ability to use defect and change tracking software tools. • Excels in documenting code. *Resumes with the following information will be given preference.* * * *Full Name:* *Current Location:* *Relocation:* *Availability:* *Work Authorization in US:* *Contact Number:* *Email:* *Rate on C2C:* * * *Please ensure all candidates have all skills listed under "Required Skills" in their resume.* *Reply - pa...@everestcom <[email protected]>.com* -- You received this message because you are subscribed to the Google Groups "OracleD2K" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/oracled2k?hl=en.
