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
Walmart
...comprehensive patient care by administering any clinical service programs (for example immunizations point-of-care testing) offered by Sams Club in compliance with State Board of Pharmacy statutes/regulations. Assists in inventory management by monitoring stock levels...
Auto Auction Holdings
...Job Description Job Description Join Our Awesome Team as an Auto Mechanic! Orlando Longwood Auto Auction Who We Are (And Why You'll Love It Here!) Welcome to Orlando Longwood Auto Auction - where cars meet community in beautiful Longwood, Florida! We're the...
Domino's Pizza LLC
Company Description Job Description Operate all equipment. Stock ingredients from delivery area to storage, work area, walk-in cooler Prepare product. Receive and process telephone orders. Take inventory and complete associated paperwork. Clean...
Paschall Truck Lines
...Job Description Paschall Truck Lines is Now Hiring CDL-A Solo and Team Drivers! Solos Earn Up To 64 CPM - Teams Earn Up To 79 CPM Split! We appreciate our drivers so much that we gave them the company! Anyone can say thank you, but at PTL, we put our appreciation...
Sanford Burnham Prebys
...is a preeminent, independent biomedical research institute dedicated to understanding human... ...is seeking a highly motivated Research Assistant with some background in biochemistry or... ...favorable performance. No prior research experience is required.Duties And Responsibilities...