Data Engineer

Micro-Data Systems Inc.
Job Type
Mid level

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.


  • 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)


About the Company:
Micro-Data Systems Inc.

Ref #
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.