Data Modeling ,

Sonsoft Inc; New Jersey; On-site; USD 80,000 - 100,000; Full time

Job summary

A software solutions company based in the United States is seeking a professional with strong database experience, particularly in Teradata, Netezza, and Oracle, as well as expertise in Data Warehousing and Data Modeling. The ideal candidate will have a Bachelor's degree and at least 2 years’ experience with DW/BI tools. Strong knowledge of Erwin is essential. This role requires working both independently and collaboratively with teams to achieve project goals. Only US citizens and green card holders may apply.

Qualifications

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

Responsibilities

• Work with stakeholders to understand functional and technical requirements.
• Develop and maintain documentation for data models.
• Collaborate with Business Analysts and DBAs to meet project objectives.

Skills

Databases (Teradata, Netezza, Oracle)

Unix Environment

Data Warehousing Concepts

Performance Tuning

Dimensional and ER-Modeling

ETL Tools

Banking and Financial Domain Knowledge

Data Quality

Data Governance

Erwin

Education

Bachelor’s degree or foreign equivalent

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.