*Hi,*
*Please reply to ,* *vin...@1pointsys.com <vin...@1pointsys.com>* *Title: Data Architect* *Location: Chicago, IL* *Duration: 6+ months* *Local: Highly preferred* *Skills Needed: Data Architect in Oracle environments with strong Oracle, SQL, data flow from Cognos, Schema, etc.* *Finance background HIGHLY preferred.* *Need USC/GC/GC EAD/TN/E3/H4 Candidate Only* *JD below:* Senior Data Architect: * Must be able to navigate in Oracle, beyond basic SQL skills - analytic functions (lead, lag, dense rank, and other windowing functions) and hierarchical queries. * Must be able to read and understand Oracle Query Plans and implement the correct choices for performance * Must know most of the views (V$*, X$*) of the Oracle data dictionary, to get information on the fly about relationships, and mutual-dependencies among database objects * Must speak the dialect of Oracle DBAs with ease, and take on Oracle DBA role if ever needed. * Must be able to visualize data as a table, a tree(balanced, ragged) or a graph and perform operations with ease to pivot the shape of data when needed * Must understand multiple hierarchies in trees and how to maintain them via ETL or other, with minimal intrusion * Must know when to use a snowflake versus a star and not quote some esoteric line from latest Ralph Kimballs blog. * Must understand layered reusable structures in the database * Must be able to analyze data and their relationships in a foreign EIS system, understand the grain of data and which attributes they hang of, and then correctly define the grain in the target data mart * Be able to effortlessly design data-level security that may (or may not) reflect the integrating source systems. * Understand how to design extensible Multi-dimension security which could use any combination of union or intersection, if needed * Must be able to visualize a target data mart once presented with data from source systems. *Vineet Mishra* *Technical Recruiter* 1 Point System LLC Unit 103, 206 N College St, Pineville, North Carolina, 28134 *P*: *803-317-2541* *E* : vin...@1pointsys.com -- You received this message because you are subscribed to the Google Groups "Exact Match" group. To unsubscribe from this group and stop receiving emails from it, send an email to exact-match+unsubscr...@googlegroups.com. To post to this group, send email to exact-match@googlegroups.com. Visit this group at https://groups.google.com/group/exact-match. For more options, visit https://groups.google.com/d/optout.
