Dofactory.com
Dofactory.com

Data Engineer

Company
Micro-Data Systems Inc.
Location
NY
Job Type
Fulltime
Level
Mid level
Skills

Job Description

Seeking an Oracle Developer/Data Engineer with excellent skills and no less than 10 years of experience in all Oracle PL/SQL advanced aspects.

Responsibilities:

  • Developing complicated Oracle views, stored procedures, functions, materialized views, and packages
  • Understanding and reverse engineering existing views and stored procedure logic into process flow diagrams using Visio
  • Analyzing existing schemas and intuitively identifying relationships from data when constraint objects are not available to build Conceptual, Logical, and, Physical Data models
  • Creating efficient and normalized database models, and schemas, defining relationships between tables
  • Translating change requests (written and verbal) into written requirements, components diagrams (view, stored procedures, flows), development, and execution plans.
  • SQL performance tuning

Skills Required (must have):

  • Basic ANSI and Oracle SQL: select, update, insert, deletes, joins (all types), subqueries and indexing
  • Advanced Oracle SQL: Range Windows, Rollups, Merge, Partitioning, Ranking, Json (tables, queries and transforms)
  • PL/SQL: Cursors, Exception Handling, Functions, Variables, Nested Tables, Collection methods, Varrays, debugging and profiling
  • Practical experience in data integration, warehousing (facts and dims), ELT, ETL, data cleansing, transformation
  • Tools: Visio, Oracle SQL Developer, SQL*Loader (import and export data)


#CB

About the Company:
Micro-Data Systems Inc.



 
Ref #
2760919
Posted
26 days ago
  •  
Last updated 24 days ago


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.