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

[Vineet Mishra]

*Hi,*


*Please reply to ,*




*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 
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to usitcv+unsubscr...@googlegroups.com.
To post to this group, send email to usitcv@googlegroups.com.
Visit this group at https://groups.google.com/group/usitcv.
For more options, visit https://groups.google.com/d/optout.

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

[Vineet Mishra]

*Hi,*


*Please reply to ,*




*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 
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to usitcv+unsubscr...@googlegroups.com.
To post to this group, send email to usitcv@googlegroups.com.
Visit this group at https://groups.google.com/group/usitcv.
For more options, visit https://groups.google.com/d/optout.

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

[Vineet Mishra]

*Hi,*


*Please reply to ,*




* 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.*



*Don’t Need H1B /OPT candidate*



*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.

Know what the dimensions would be, what their attributes would be; what
hierarchies would they have? Would they ragged?

* Envision future directions of the mart - be able to foresee what types of
future trending and analytics might come in future phases and thereby
design correct locations for fast-changing versus slow-changing attributes

* Historical trending, time-series, restating history SCD types, NRT and
trickle feed integration are highly desirable.

* Must be able to have a cogent conversation with data analysts, ETL, data
architects and modelers if not do their job, if needed

* Must be able to design for data ingestion and outflow through a wide
variety of channels -- Flat files, XML, JSON via file ETLs; Trickle
consumption via Services, Oracle View remote links, Messaging if needed

* Must have an understanding of how to design real-time and near real-time
trickle feeds

* Must be able to write complex queries in SQL

* Must know which indexes to design (B-tree, Bitmap, Clustered join,
functional, etc.) and composite partitioning choices on Very Large Tables
based on the nature of data

* Must know all trade-offs in performance tuning between loads and reads.

* Must be able to tune SQL, apply hints, enforce other query plans by
changing session or memory parameters in Oracle

* Must be able to write code in PL/SQL (or Transact SQL if coming from MS
SQL Server background) for functions, stored procedures, packages and
triggers. Must be knowledgeable on cursor types and processing.

* Must know how use and invoke stored procedures from custom languages
(Java, .NET) as well as Cognos BI Framework Manager and Cognos TM1 TI.

* Must know when to use a materialized view versus a summary table and the
concept of query rewrites

* Must have client and stakeholder interaction abilities and working with
Cross functional teams.

* Desired experience with latest Business Intelligence and analytical
technologies (Ex: Analytics, Big Data, Statistics, Algorithms, and Cloud
computing etc...)





*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 
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to usitcv+unsubscr...@googlegroups.com.
To post to this group, send email to usitcv@googlegroups.com.
Visit this group at https://groups.google.com/group/usitcv.
For more options, visit https://groups.google.com/d/optout.

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

[Vineet Mishra]

*Hi,*


*Please reply to ,*




* 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.*



*Don’t Need H1B /OPT candidate*



*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.

Know what the dimensions would be, what their attributes would be; what
hierarchies would they have? Would they ragged?

* Envision future directions of the mart - be able to foresee what types of
future trending and analytics might come in future phases and thereby
design correct locations for fast-changing versus slow-changing attributes

* Historical trending, time-series, restating history SCD types, NRT and
trickle feed integration are highly desirable.

* Must be able to have a cogent conversation with data analysts, ETL, data
architects and modelers if not do their job, if needed

* Must be able to design for data ingestion and outflow through a wide
variety of channels -- Flat files, XML, JSON via file ETLs; Trickle
consumption via Services, Oracle View remote links, Messaging if needed

* Must have an understanding of how to design real-time and near real-time
trickle feeds

* Must be able to write complex queries in SQL

* Must know which indexes to design (B-tree, Bitmap, Clustered join,
functional, etc.) and composite partitioning choices on Very Large Tables
based on the nature of data

* Must know all trade-offs in performance tuning between loads and reads.

* Must be able to tune SQL, apply hints, enforce other query plans by
changing session or memory parameters in Oracle

* Must be able to write code in PL/SQL (or Transact SQL if coming from MS
SQL Server background) for functions, stored procedures, packages and
triggers. Must be knowledgeable on cursor types and processing.

* Must know how use and invoke stored procedures from custom languages
(Java, .NET) as well as Cognos BI Framework Manager and Cognos TM1 TI.

* Must know when to use a materialized view versus a summary table and the
concept of query rewrites

* Must have client and stakeholder interaction abilities and working with
Cross functional teams.

* Desired experience with latest Business Intelligence and analytical
technologies (Ex: Analytics, Big Data, Statistics, Algorithms, and Cloud
computing etc...)





*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

*Yahoo:* vineet1point...@yahoo.com  *Hangout: *vineet1po...@gmail.com

*W:* www.1pointsys.com

For Job Updates please add: *1 Point System-Jobs/Hotlist*



*[image: cid:image001.jpg@01D1C23B.DB35CC10]*

   *An E-Verified company | An Equal Opportunity Employer*



*Note: 1 Point System LLC works with Direct Clients and Preferred Vendors
Nationwide. *

*   Your confirmation would means that you understand the level of
1 Point System LLC association for the mentioned project and will not
approach 1 Point System LLC Client directly*

-- 
You received this message because you are subscribed to the Google Groups 
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to usitcv+unsubscr...@googlegroups.com.
To post to this group, send email to usitcv@googlegroups.com.
Visit this group at 

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

[Vineet Mishra]

*Hi,*


*Please reply to ,*




* 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.*



*Don’t Need H1B /OPT candidate*



*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.

Know what the dimensions would be, what their attributes would be; what
hierarchies would they have? Would they ragged?

* Envision future directions of the mart - be able to foresee what types of
future trending and analytics might come in future phases and thereby
design correct locations for fast-changing versus slow-changing attributes

* Historical trending, time-series, restating history SCD types, NRT and
trickle feed integration are highly desirable.

* Must be able to have a cogent conversation with data analysts, ETL, data
architects and modelers if not do their job, if needed

* Must be able to design for data ingestion and outflow through a wide
variety of channels -- Flat files, XML, JSON via file ETLs; Trickle
consumption via Services, Oracle View remote links, Messaging if needed

* Must have an understanding of how to design real-time and near real-time
trickle feeds

* Must be able to write complex queries in SQL

* Must know which indexes to design (B-tree, Bitmap, Clustered join,
functional, etc.) and composite partitioning choices on Very Large Tables
based on the nature of data

* Must know all trade-offs in performance tuning between loads and reads.

* Must be able to tune SQL, apply hints, enforce other query plans by
changing session or memory parameters in Oracle

* Must be able to write code in PL/SQL (or Transact SQL if coming from MS
SQL Server background) for functions, stored procedures, packages and
triggers. Must be knowledgeable on cursor types and processing.

* Must know how use and invoke stored procedures from custom languages
(Java, .NET) as well as Cognos BI Framework Manager and Cognos TM1 TI.

* Must know when to use a materialized view versus a summary table and the
concept of query rewrites

* Must have client and stakeholder interaction abilities and working with
Cross functional teams.

* Desired experience with latest Business Intelligence and analytical
technologies (Ex: Analytics, Big Data, Statistics, Algorithms, and Cloud
computing etc...)





*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 
"USITCV" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to usitcv+unsubscr...@googlegroups.com.
To post to this group, send email to usitcv@googlegroups.com.
Visit this group at https://groups.google.com/group/usitcv.
For more options, visit https://groups.google.com/d/optout.