RSS  | The Last 15 Posts  | The Complete Entry List

SQL Developer (6 month contract with a possibility to go perm, in Charlotte, NC) General Job Description (specifics):
       Obtain clear requirements before commencing development''
      ask questions of the Business Analyst/Subject Matter Expert (BA/SME) until the requirements are clear
      identify alternatives t requirements that could reduce the development time
      ''Assess the data required''
      available in existing data marts?
      calculations and business rules clear?
      * ''Design application data layer''
      use relational design for interactive transactional applications
      *** enforce integrity
      use dimensional design for reporting applications
      *** application metric tables (implementing application specific business rules/filtering)
      *** process for loading application metric tables (stored procedures, DTS, etc.)
      API's for delivering resultsets t presentation layer
      *** performance is //critical// - report API's should return data in < 2 seconds
      API's for INSERT, UPDATE t relational application database
      ensure designs conforms consistently t team standards (or propose new standard) evaluate prospective data sources:
      When building data mart objects:
      identify measures (distinguish appropriate grain for our fact tables)
      identify dimensions
      assess data quality existing at the source
      prepare a summary (diagram, Word document, etc.) for discussion with project team
      design data mart and load processes
      stage, work, fact and dimension tables
      ETL (DTS, stored procedures, etc.)
      source t stage
      stage t dimension
      stage t fact
      fact t base metric (if appropriate)
      performance is critical - many concurrent processes run daily
      ensure designs conforms consistently t team standards (or propose new standard)
      learn our team standards
      n silos/lone wolf development
      communicate ideas for improving/enhancing/extending the standards
      discuss deviations with team lead before implementing
      prepare accurate and complete design documentation (during the development cycle - not as an afterthought at the end)
      keep team lead apprised of progress and issues on development projects
      break development tasks down int key steps and sequence those steps
      create database objects and write code t implement development projects
      unit test your own code
      review peers' code for correctness, performance, clarity, and technique - provide written feedback
      support production data marts
      respond t data loading issues
      implement enhancements
      learn the processes for those data marts not assigned t you s that you can cover support when other team members are unavailable
      provide honest, critical, constructive feedback t peers, team leads, and me

Business Need driving this open position:
Development projects: additional data marts in their data warehouse, additional business reporting application needs.

Looking for 3-5 yrs+ of experience w/ the following.