Previous Job
DWH Data Modeler (AWS Redshift)
Ref No.: 18-34920
Location: Peapack, New Jersey
Position Type:Direct Placement
Start Date: 05/21/2018
Role: DWH Data Modeler (AWS Redshift)
Location: Peapack, NJ
Full-Time (Permanent)
Job Description
Relevant Experience& Experience Required (in Yrs.): Total 10+ year experience
Technical/Functional Skills (Must Have Skills)
Knowledge and Experience on ErWin
Extensive experience in Data Modeling and Data Architect
Possesses experience or knowledge in supporting as well as implementing Redshift, DB2, Oracle and SQL data infrastructures.
Has experience in meta data management and data integration engines such as Informatica/ Talend.
Has proven analytical and problem-solving traits.
Shows knowledge of the design, development and maintenance of various data models and their components.
Understands BI tools and technologies as well as the optimization of underlying databases.
Exhibits knowledge of the entire process behind software development including design and deployment
Roles & Responsibilities
§  Designs data architectures; translates data so that it can be read by various types of computer systems.
§  Designs and builds databases that are used in relation with data architectures.
§  Assists in the development of strategies for archive recovery, database implementation and data acquisition.
§  Cleans and maintains databases by restructuring and deleting old data.
§  Leads and sometimes directs the work of others; works with a team to accomplish common goals for the employer.
§  Completes reports to provide to a team leader, manager or supervisor.
§  Works with other IT groups and departments to assist in the coordination of future activities and plans that involve computing and data.
§  Identifies and recognizes areas in which policy or procedure changes could assist in the future expansion of businesses