Job Description
Job title :- Sr Data modeler
Duration :- long term
Location :- New Jersey USA
Rate: $50/Hr on W2
Infosys
Solid grasp of Data Modeling, Data Validation, and Data Source Evaluation, along with a deep understanding of Data Warehouse and Data Mart Design, ETL, BI, OLAP, and Client/Server applications on AWS and Azure platforms.
Experience in using ER modeling tools such as Erwin and ER/Studio.
Good experience on Data Modeling (Dimensional and Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension Tables
Worked on Data Modeling involving Dimensional Data modeling, Star Schema/Snowflake schema, FACT & Dimensions tables, Physical & logical data modeling
Developed data Mart for the base data in Star Schema, Snowflake Schema involved in developing the data warehouse for the database.
Designed both 3NF data models for ODS, OLTP systems and dimensional data models
Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
Created DDL scripts using Erwin and source to target mappings to bring the data from source to the warehouse.
Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.
Experience in data analysis, data migration and data modeling activities.
Job Tags
Similar Jobs
Lallaks Delivery Service
...efficiently while adhering to all traffic regulations and company policies. A strong emphasis on safety, punctuality, and customer service is essential. Responsibilities Operate commercial vehicles, including tractor-trailers, flatbeds, tankers, and dump trucks....
Delek US
...Field Gas Pipeline Operator - Hobbs, NM Location: Libby Plant (Libb), NM, US, 88240 Are you looking for a career in a dynamic and innovative company that values versatility, growth, and teamwork? Look no further than Delek US Holdings! WHAT IS DELEK? WHAT DO...
Life Time Fitness
...Pilates Instructors Pilates Instructors are responsible for supporting all members in championing happier, and healthier lives by building and nurturing relationships. They provide a positive member experience that is educational, supporting, and upholds the integrity...
Toledo Clinic
...Part-Time Medical Receptionist Toledo Clinic's Dermatology Office located in South Lyon, Michigan is seeking a part-time Medical Receptionist. This position will work Wed/Thurs (8-4) and Fri (8-2). Previous experience in a medical office is strongly preferred. General...
SynergisticIT
...Synergisticit at Oracle Cloudworld 2023 Synergisticit at Gartner Data & Analytics summit Why do Tech Companies not Hire recent... ...recent grads in Mathematics, Statistics , Computer Science or Engineering or candidates with gaps in their career or people wanting to switch...