Sr.Data Architect
Previous Job
Previous
Sr.Data Architect
Ref No.: 18-23696
Location: Baltimore, Maryland
Position Type:Full Time/Contract
Start Date: 04/09/2018
Position: Sr.Data Architect Location: Baltimore, MD Duration: Full time Experience Required Sybase, Oracle PL SQL • Experience in Financial Services, preferably Wealth Management • Social skills, persistence and backbone to work with difficult stakeholders • 10 to 12 years of relevant work experience: experience in large/complex IT architecture environments and experience as a solution or application architect on large-scale development projects and data model. • Need to have: Data Modelling tool - Sybase Power Designer experience, • working knowledge on Oracle SQL Developer client • Multiple database experience (Sybase, sql server, db2) • Asset management domain experience, " "strong IT back ground in Financial Applications " " • Strong experience writing stored procedures, functions, triggers, and ad hoc queries using PL/SQL • Experience with using XML data type, XQuery, and XSLT • Experience writing stored procedures, functions, triggers, and ad hoc queries using Microsoft Transact-SQL • Ability to present the pros and cons of various design and SQL coding techniques • Understanding of star-schema data warehousing concepts and implementations • Experience with performance tuning of complicated queries and procedures • Familiarity with Oracle execution plans and statistics • Experience with Oracle SQL Developer client • Experience with Sybase a plus • Experience with Informatica a plus • 7 to 8 years of relevant work experience: • experience in large/complex IT architecture environments and experience as a solution or application architect on large-scale development projects • experience working on database technology stack. • experience on Data Modelling and Designing - creating conceptual ,logical and physical data model • experience working with Oracle, SQL, and PL/SQL • experience writing stored procedures, functions, packages and other PLSQL components, and ad-hoc queries using SQL • experience presenting various design and SQL coding techniques to technical teams and business users • experience modelling and designing data warehouse • experience working with star-schema data warehousing concepts and implementations • experience working on performance tuning of queries and procedures, working with Oracle execution plans and statistics • experience working on Informatica as a ETL tool.