Data Architect ---------------- Chicago, IL

Hi,

Please reply to ,

 

Vineet@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 : vineet@1pointsys.com

--
You received this message because you are subscribed to the Google Groups "Entry level IT Jobs in US + H1B visa sponsor" group.
To unsubscribe from this group and stop receiving emails from it, send an email to entry-level-it-jobs-in-us-h1b-visa-sponsor+unsubscribe@googlegroups.com.
To post to this group, send email to entry-level-it-jobs-in-us-h1b-visa-sponsor@googlegroups.com.
Visit this group at https://groups.google.com/group/entry-level-it-jobs-in-us-h1b-visa-sponsor.
For more options, visit https://groups.google.com/d/optout.