Required Skills

OLAP OLTP Star Schema Snowflake Schema

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 1st Oct 2022

JOB DETAIL

Must Have Skills:

1. 10+ years of experience in System Analysis, Design, Development, Data Analysis, Data Modeling

2. Solid experience in Data Warehousing concepts, OLAP, OLTP, Star Schema, Snowflake Schema, Fact tables, Dimension tables, Ralph Kimball Methodology, Bill Inmon Methodology, Conceptual Modeling, Logical Modeling, Physical Modeling, Relational Modeling, Dimensional Data Modeling using Erwin, Microsoft Visio and IDERA E/R Studio, Data Vault 2.0 Data Modeling methodology.

3. Good understanding of Master Data Management (MDM) architecture, MDM concepts, MDM Hub components such as MDM Hub Console, Hub store, Data Mappings (Landing/Staging/Base Objects)

 

Nice to have skills:

1. Knowledge on AWS Cloud Architecture, NoSQL database (MongoDB) concepts

2. Knowledge on AWS Cloud Architecture, NoSQL database (MongoDB) concepts

 

Detailed Job Description:

• 10+ years of experience in System Analysis, Design, Development, Data Analysis, Data Modeling

• Knowledge on AWS Cloud Architecture, NoSQL database (MongoDB) concepts

• Understanding of SOAP, REST APIs, JMS Queue, XML, XSD schemas, microservices

• Experienced in developing Test Plans, Test Strategies and Test Cases for Data

• Solid experience in Data Warehousing concepts, OLAP, OLTP, Star Schema, Snowflake Schema, Fact tables, Dimension tables, Ralph Kimball Methodology, Bill Inmon Methodology, Conceptual Modeling, Logical Modeling, Physical Modeling, Relational Modeling, Dimensional Data Modeling using Erwin, Microsoft Visio and IDERA E/R Studio, Data Vault 2.0 Data Modeling methodology.

• Good understanding of Master Data Management (MDM) architecture, MDM concepts, MDM Hub components such as MDM Hub Console, Hub store, Data Mappings (Landing/Staging/Base Objects)

 

Top 3 responsibilities you would expect the Subcon to shoulder and execute*:

Primary responsibility will be, the candidate will work closely with the Architects and developers to assist them on their data needs to be able to deliver APIs that will assist in data integrations with both upstream and downstream systems.

 

Company Information