Data Modeling , at SonSoft Inc. in Warren, NJ

Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, => Software Consultancy and Information Technology Enabled Services.

Job Description

Mandatory Technical Skills

• Have strong experience in databases like Teradata, Netezza or Oracle etc.

• Good Experience in Unix Environment

• Good experience in Industry standard data modelling tools like Erwin.

• Have good working knowledge of Data warehousing concepts. 3+ experience is required.

• Experience in Performance tuning in DW environment.

• Experience on data modeling using Dimensional as well as ER-Model

• Have working Knowledge of Industry Standard Reporting/ETL tools.

• Having good PL SQL Skills

• Have good Banking and Financial Domain Knowledge is Must.

Preferred/Good to have

• Worked in both OLTP and DW implementation

• Experience on Ab Initio.

Job description

• Person needs to Interacting with Project stake holders to understand functional as well as technical requirements and documenting, publishing to Team.

• Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating, publishing, maintaining PHYSICAL data models

• Evaluate existing data models and physical databases for variances and discrepancies

• Experience with managing meta data for data models

• To develop, publish, maintain all documentation for data models

• Work with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives - delivery dates, cost objectives, quality objectives, business customer satisfaction objectives, etc.

• Take part Data Quality, Data governance processes

• Leverage and enforce standards for data naming conventions to ensure consistency and reuse of data models

• Validate business use cases for accuracy and completeness of proposed data models.

• Ability to communicate strategies and processes around data modeling and architecture to cross functional groups and senior levels

• Good hands on knowledge on Erwin knowledge is must require.

The job entails sitting as well as working at a computer for extended periods of time. Should be able to communicate by telephone, email or face to face. Travel may be required as per the job requirements.

Qualifications

Qualifications Basic

• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

• At least 2 years of experience with DW/BI and related tools

• At least 1 years of experience with Data Modeling related tools

• Understanding of Data Modeling architectural principles

Additional Information

Note:

· Only US Citizen, Green Card Holder, H4-EAD, GC-EAD & L2-EAD can apply.

· No H1B & OPT-EAD

. We are unable to sponsor at this time.