Futran Tech Solutions Pvt. Ltd.
Erwin/ Data MOdeler
Futran Tech Solutions Pvt. Ltd., Jersey City, New Jersey, United States, 07390
Role : Erwin/Data Modeler
Location: New Jersey(Intially remote)
Duration: Fulltime
JD - As below.
Must-have skillsThis position does not offer sponsorship.8+ Years overall IT development experienceERWIN / Data modelerAzure good to haveNice-to-have skills
Design the data marts in dimensional data modeling using star and snowflake schemas.Develop data architecture prototypes and data models including ETL staging models, audit control models and traditional data warehouse dimension/fact models.Design logical and physical data-models normalizing unstructure mainframe data into OLTP schema.Assist in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.Develop stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
Location: New Jersey(Intially remote)
Duration: Fulltime
JD - As below.
Must-have skillsThis position does not offer sponsorship.8+ Years overall IT development experienceERWIN / Data modelerAzure good to haveNice-to-have skills
Design the data marts in dimensional data modeling using star and snowflake schemas.Develop data architecture prototypes and data models including ETL staging models, audit control models and traditional data warehouse dimension/fact models.Design logical and physical data-models normalizing unstructure mainframe data into OLTP schema.Assist in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.Develop stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.