Data Modeling ,

Reposted 7 Days Ago
Be an Early Applicant
Warren, NJ, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design, develop, validate, and maintain logical and physical data models for DW/BI projects. Collaborate with stakeholders, BAs, architects, developers and DBAs; enforce naming standards, manage metadata, support data governance and quality, and perform performance tuning in DW environments.
Summary Generated by Built In
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.

Skills Required

  • Experience with Teradata, Netezza or Oracle databases
  • Experience in Unix environment
  • Hands-on experience with Erwin (data modeling tool)
  • 3+ years experience in Data Warehousing (DW/BI)
  • Experience in performance tuning in DW environments
  • Data modeling using Dimensional and ER models
  • Working knowledge of industry-standard reporting and ETL tools
  • PL/SQL skills
  • Banking and financial domain knowledge
  • Worked in both OLTP and DW implementations
  • Experience with Ab Initio
  • At least 2 years with DW/BI and related tools
  • At least 1 year with data modeling related tools
  • Bachelor's degree (or equivalent; three years progressive experience may substitute per year of education)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

TD Bank Logo TD Bank

Data Scientist

Fintech • Insurance • Financial Services
In-Office
5 Locations
93823 Employees
96K-156K Annually

SonSoft Inc. Logo SonSoft Inc.

Data Modeling ,

Information Technology • Professional Services • Software • Consulting
In-Office
Livingston, NJ, USA
87 Employees

Citizens Logo Citizens

Senior Data Scientist

Digital Media • Fintech • Information Technology • Machine Learning • Financial Services • Cybersecurity • Automation
In-Office or Remote
2 Locations
17000 Employees
124K-165K Annually
In-Office
5 Locations
27791 Employees
163K-237K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account