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 
"Citrix and Sap problems" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at https://groups.google.com/group/citrix-and-sap-problems.
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 
"Citrix and Sap problems" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.

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

URGENT :: BIG DATA Architect.......Chicago,IL........12+Months

[Raj Yadav @ SYSMIND LLC]

Hi Professionals,

Please let me know if you have any resource for this position:



*Big Data Architect – Chicago,IL*

*Required Experience*



· Data management (Data flow, Data Profiling , Data analysis and
Data Validation, Definition/Meta data, Reference Data, Data Quality, Data
Lineage, Data Transformation, Modeling, Reporting)

· Strong business analysis skills

· Strong communication skills, verbal and written (interface with
global teams)

· Hadoop based technologies like Hive, Map Reduce, Pig, Hbase

· Advanced skills in Mapreduce, Hive and Pig

· Experience in Financial Services – Credit Risk



*Role *

· *Data Profiling, Analysis and Validation*

· Defining *Business rule and transformations in the Big Data
environment*

· Create conceptual and logical data model

· Define Business POC

· Define strategy for data consumption

· *Define strategy and provide data for Ingestion*

· Create full functional specifications for ITO team

· Providing support to ITO team

· Data lineage (for all RBWM data elements)

· End user interaction to understand currently applied business
logic

· Documentation (either in Office or directly into Colibra) of data
information and meta-data where applicable

· Engaging with IT to verify source to target mapping

· Engagement with RBWM parties on Data Policy implementation for
BCBS  (e.g. what are DQ rules for BCBS data elements, who are the owners,
DQIM process for BCBS data, etc.)

· Candidates would extract the data from a wider data lake created
by customer and based on the requirement from business would *filter,
massage/transform, Data model *them and then pass on to the IT team to
execute in production.

·





Thanks  Regards,

*Raj Yadav*

Email: rya...@sysmind.com

Ph: 609-897-9670 x 2168

Fax: 609-228-5522

SysMind LLC

Address: 38 Washington Road, Princeton Jn, NJ 08550



*[image: cid:image001.gif@01CD1E36.E1381A30]* http://www.sysmind.com/

[image: cid:image002.png@01CF4A69.18319D80]  [image:
cid:image003.png@01CF4A69.18319D80]  [image:
cid:image004.png@01CF4A69.18319D80]



NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this
mail cannot be considered Spam as long as we include the contact
information for removal from our mailing list. To be removed from our
mailing list please reply with 'remove' in the subject heading and your
email address in the body. Include complete address and/or domain/aliases
to be removed. If you still get these emails, please call us at the number
in the signature.

-- 
You received this message because you are subscribed to the Google Groups 
Citrix and Sap problems group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at http://groups.google.com/group/citrix-and-sap-problems.
For more options, visit https://groups.google.com/d/optout.

URGENT :: BIG DATA Architect.......Chicago,IL........12+Months

[Raj Yadav @ SYSMIND LLC]

Hi Professionals,

Please let me know if you have any resource for this position:



*Big Data Architect – Chicago,IL*

*Required Experience*



· Data management (Data flow, Data Profiling , Data analysis and
Data Validation, Definition/Meta data, Reference Data, Data Quality, Data
Lineage, Data Transformation, Modeling, Reporting)

· Strong business analysis skills

· Strong communication skills, verbal and written (interface with
global teams)

· Hadoop based technologies like Hive, Map Reduce, Pig, Hbase

· Advanced skills in Mapreduce, Hive and Pig

· Experience in Financial Services – Credit Risk



*Role *

· *Data Profiling, Analysis and Validation*

· Defining *Business rule and transformations in the Big Data
environment*

· Create conceptual and logical data model

· Define Business POC

· Define strategy for data consumption

· *Define strategy and provide data for Ingestion*

· Create full functional specifications for ITO team

· Providing support to ITO team

· Data lineage (for all RBWM data elements)

· End user interaction to understand currently applied business
logic

· Documentation (either in Office or directly into Colibra) of data
information and meta-data where applicable

· Engaging with IT to verify source to target mapping

· Engagement with RBWM parties on Data Policy implementation for
BCBS  (e.g. what are DQ rules for BCBS data elements, who are the owners,
DQIM process for BCBS data, etc.)

· Candidates would extract the data from a wider data lake created
by customer and based on the requirement from business would *filter,
massage/transform, Data model *them and then pass on to the IT team to
execute in production.

·





Thanks  Regards,

*Raj Yadav*

Email: rya...@sysmind.com

Ph: 609-897-9670 x 2168

Fax: 609-228-5522

SysMind LLC

Address: 38 Washington Road, Princeton Jn, NJ 08550



*[image: cid:image001.gif@01CD1E36.E1381A30]* http://www.sysmind.com/

[image: cid:image002.png@01CF4A69.18319D80]  [image:
cid:image003.png@01CF4A69.18319D80]  [image:
cid:image004.png@01CF4A69.18319D80]



NOTE: Under Bill s.1618 Title III passed by the 105th U.S. Congress this
mail cannot be considered Spam as long as we include the contact
information for removal from our mailing list. To be removed from our
mailing list please reply with 'remove' in the subject heading and your
email address in the body. Include complete address and/or domain/aliases
to be removed. If you still get these emails, please call us at the number
in the signature.

-- 
You received this message because you are subscribed to the Google Groups 
Citrix and Sap problems group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at http://groups.google.com/group/citrix-and-sap-problems.
For more options, visit https://groups.google.com/d/optout.

data architect---chicago/IL---6 months---phone+skype

[rahul arya]

*Job Title*

*data architect*

*Project Location*

*chicago/IL*

*Duration*

*6 months*



*MOI: PHONE+SKYPE*

*SKILLS:*


*experience with Enterprise Information Management (EIM).*

* * Must have  experience in DW / BI *

** Must have some data modeling experience in the Healthcare domain *

** Must have experience as a Data Architect / Modeler in an Enterprise
environment *

Experience:

-   experience in combined experience in data warehousing, BI
and application development.

-   experience designing and implementing Star Schemas

-   experience implementing DW presentation layer - including
design and definition of logical tables, physical sources, dimensions,
columns, aggregation rules

-   experience in writing advanced SQL queries, views, and
optimization of SQL queries

-  Comprehensive Knowledge of Ralph Kimball's Data Modeling
Concepts including Transaction dimensions, conformed dimensions and facts,
slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different
types of Fact tables

-   experience with 3NF Data Modeling and NORMALIZED schema

-  Comprehensive Knowledge of Bill Inmon's Data Modeling
Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes,
Abstraction, Associative entities / tables

*PLEASE REVERT ME ONLY @ ra...@rgtalent.com ra...@rgtalent.com*

-- 
You received this message because you are subscribed to the Google Groups 
Citrix and Sap problems group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at http://groups.google.com/group/citrix-and-sap-problems.
For more options, visit https://groups.google.com/d/optout.