Previous Job
Previous
Data Modeler/Senior Oracle Developer
Ref No.: 18-38725
Location: Baltimore, Maryland
Position Type:Contract
Experience Level: 7 Years
Start Date: 06/28/2018
 15 years of experience working on database and related technology stack.
Expertise on
               Concepts of modelling and designing data warehouse - creating conceptual ,logical and physical data model
               RDBMS and star-schema data warehousing concepts and implementations
               any data modelling tool (Erwin/Power Designer)
               Oracle, SQL and PL/SQL
               writing stored procedures, functions, packages and other PLSQL components, ad-hoc queries using SQL, Use of XMLType and XQuery
               performance tuning and optimization of queries and procedures, working with Oracle execution plans and statistics

               
Good to have :
Exposure to
               Informatica as a ETL tool
               multiple databases (sybase, sql server, db2)
               any reporting tool            
               Oracle SQL Developer client
Control M as Job Scheduling tool
               Asset management or Financial domain