Data Modeling ,

Sonsoft Inc; Livingston (NJ); On-site; USD 80,000 - 100,000; Full time

Job summary

A growing software development firm in New Jersey is seeking a candidate for a specialized role in data modeling and data warehousing. The ideal candidate will have strong experience with various databases and tools like Erwin, alongside a good understanding of banking and financial domains. Responsibilities include collaborating with stakeholders, validating data models, and ensuring data quality. This position requires at least a bachelor's degree or equivalent experience, and only US citizens or specific visa holders may apply.

Qualifications

• At least 2 years of experience with DW/BI and related tools.
• At least 1 year's experience with Data Modeling related tools.
• Understanding of Data Modeling architectural principles.

Responsibilities

• Interact with Project stakeholders to understand and document requirements.
• Develop, validate, and maintain logical and physical data models.
• Evaluate existing data models for variances and discrepancies.
• Work with cross-functional teams to achieve project objectives.
• Take part in data quality and governance processes.

Skills

Strong experience in databases like Teradata, Netezza, or Oracle

Good experience in Unix environment

Industry standard data modeling tools like Erwin

Good working knowledge of Data warehousing concepts

Performance tuning in DW environment

Data modeling using Dimensional and ER-Model

Industry Standard Reporting/ETL tools

Banking and Financial Domain Knowledge

Education

Bachelor’s degree or foreign equivalent

Three years of progressive experience in lieu of every year of education

Tools

Erwin

Job 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 UnixEnvironment
• 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.
• Have good Banking and Financial Domain Knowledge is Must.

Preferred/Good to have

• Worked in both OLTP and DW implementation
• 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 least2 years of experience with DW/BI and related tools
• At least1 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.
• We are unable to sponsor at this time.